.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Query to list currently running queries on the sql server 2000

Posted By:      Posted Date: September 10, 2010    Points: 0   Category :Sql Server
Hi all Who to check, what all queries are running curently on the sql server 2000, I need to list who all logged in and what queries are getting executed and how long its running. Thanks in advance. shan  

View Complete Post

More Related Resource Links

sql server query get a list of a table

Hi guys, I've a hard query to manage ... I need to get for a report the number of required people to an appointment, but this query works but just for the regarding person related to the appointment. SELECT CRMAF_FilteredContact.OwnerID ,CRMAF_FilteredContact.OwnerIDname ,SU.businessunitidname ,SU.eu_reporthubname -- ,SU.eu_reportcountryidname ,CRMAF_FilteredContact.ContactID ,CRMAF_FilteredContact.FullName ,CRMAF_FilteredContact.invoke_tiername ,CRMAF_FilteredAppointment.ActivityID ,CRMAF_FilteredAppointment.RegardingObjectID ,CRMAF_FilteredAppointment.Subject ,AP.ActivityPartyID ,AP.PartyID ,case when CRMAF_FilteredAppointment.ActivityID is null then null else CRMAF_FilteredContact.ContactID end as s_contactsvisited -- # of contactsvisited FROM FilteredContact CRMAF_FilteredContact JOIN FilteredSystemUser SU ON CRMAF_FilteredContact.ownerid = SU.SystemUserID <strong> LEFT JOIN FilteredActivityParty AP ON ( AP.PartyID = CRMAF_FilteredContact.ContactID or AP.PartyID = CRMAF_FilteredContact.OriginatingLeadId) AND AP.participationtypemask = '8' -- regarding</strong> LEFT JOIN FilteredAppointment CRMAF_FilteredAppointment ON AP.ActivityID = CRMAF_FilteredAppointment.ActivityID AND CRMAF_FilteredAppointment.ownerid = SU.SystemUserID AND CRMAF_FilteredAppointment.stat

SQL server management studio 2008 freezes when running a query to Grid result

Hello, I've got problems when I run a Query to a grid result using SQL server management studio 2008 under W7 pro. When I execute the query, the first part of the grid returns, but then it freezes. The query should present a double resultset and contains approx 6100 records, devided over 2 grids. Strange enough, the query runs fine when I export to TXT or to a file. It seems though that the problem is building the grid. When it occurs I cannot end the application bij shutting down de SSMS window, but have to kill the Ssms.exe. In task manager I see only 25% CPU usage and approx 20% memory usage. Nothing exiting there I guess. Suggestions anybody? Microsoft SQL Server Management Studio      10.0.2531.0 Microsoft Analysis Services Client Tools      10.0.3798.0 Microsoft Data Access Components (MDAC)      6.1.7600.16385 Microsoft MSXML      3.0 4.0 5.0 6.0 Microsoft Internet Explorer      8.0.7600.16385 Microsoft .NET Framework      2.0.50727.4952 Operating System      6.0.6001 regards, Pim


I have MSSQLSERVER (Running - \\D1XFZ9C1\SQLEXPRESS-MSSQL Server) running. Under my Programs I have MicroSoft SQL Server 2005 but the only items listed are Configuration Tools. Am I missing something? I am trying to run a CREATE DATABASE query in order to create a database for PRO WPF using VB 2008 (Visual Studio 2008) but I don't know where to run it. Can anyone please help as I am new to this.

Error in SQL server 2000 after the migration (internal query processor error)

I just moved a couple of databases from one instance of SQL 2000 from different hardware to SQL 2000 instance of other hardware and after the move from the application side the app team gets an error -2147217900 - Internal Query Processor Error: The query processor could not produce a query plan.  Contact your primary support provider for more information.', 'E', '2UA929041X. Does any one have any idea about this. I took a trace while they were testing and I found out this in the trace. exec usp_DlyPrc_LogProcessEvent '-2147217900 - Internal Query Processor Error: The query processor could not produce a query plan.  Contact your primary support provider for more information.', 'E', '2UA929041X An idea or direction on this will be greatly appreciated. Thanks hash

SQL Server 2008 R2 Report builder - Cannot update a list of fields for the Query



I have existing report connected to SSAS cube. When I try to change the query and click OK, i get this message "Could not update a list of fields for the query. Verify that you can connect to the data source and  your query syntax is correct"

My Query syntax and access to data source dont have any problem.  Because fo this issue, i cannot update the query used in the report. How do i resolved this issue?



Executing XML query from SQL 2005 pointing to SQL 2000 server

Occurs with root command.
Executed as user: DOMAIN\SERVER01. Error Code: 0  Error Source= ADODB.Command  Error Description: Item cannot be found in the collection corresponding to the requested name or ordinal.    Error on Line 18.  The step failed.
Executed as user: DOMAIN\SERVER01. Error Code: 0  Error Source= Microsoft OLE DB Provider for SQL Server  Error Description: Line 1: Incorrect syntax near 'ROOT'.    Error on Line 20.  The step failed.
Dim oCmd, sSQL, oDom
   Set oDom = CreateObject("Microsoft.XMLDOM")
   Set oCmd = CreateObject("ADODB.Command")
  oCmd.ActiveConnection ="Driver={SQL Native Client};Database=Validation;Server=server1;Uid=sa;Pwd=;"
   sSQL = "<?xml version=""1.0"" ?>"
   sSQL = sSQL &

Processes running lond queries are killed by SQL Server 2008



We recently upgraded a server from 2005 to 2008. We have some long running SP's (1 or 2 min) that used to run ok on 2005. Since the upgrade, whenever we run those SP's after some time, the process ID is no longer up on the server and the SSMS on the client indicates that the query is still running. Is there a new timeout parameter or something like that on 2008 that drops the long running procedures?


How to Query Survey list data from Sql Server



I have a Survey list and i have the 2 Columns with the "Rating Scale" type and want to fetch the data from sql server for each que.

Usually i write Query on the Content database's Userdata table , but this time i dont get the Ans in the nvarchar3,4 etc. only i am able to get is the name of the Question with comma (,) with out answer to it. can anyone please let  me know that How can i query the Survey Data from the Content database



Thanks, Parth

SQL 2000 server has an issue after an unidentifed event and began running at a snails pace.


One of our SQL 2000 servers has an issue after an unidentifed event and began running at a snails pace.

     I know SQL 2000 is no longer supported.

We are running IIS on the same server and no connection can be made to the SQL server on the same machine.

     Microsoft OLE DB Provider for ODBC Drivers error '80004005'

     Specifed driver could not be loaded due to system error 5 (SQL Server).

A std query from outside the server works fine until a  Join is added then it runs forever.

A backup and restord did nothing as well as reindexing, shrinking and optimizing. 

After restoring the database on another SQL 2000 server we compared the speeds.

Bad server 4:22 minutes good server less then 1 second.

Any sugguestions??????  r.morrison@gerresheimer.com

SOAP Error 500 when query in Sql Server 2008 using for reporting a Sharepoint list 2007


I'm doing the reporting services for a SharePoint list, the datasource is configured as a connection with http://<Servername>/_vti_bin/lists.asmx and I add the parameters listName , rowLimit and viewName with the

Sql server 2000 Update Query with join


I have 3 tables . I will give the structure.

1) TblAgency   

PCC     SCCode  AgencyName

2) SegmentCalculation

PCC  StatusDate  Segment   YTD

  3) TblStandard                // for get abt this table. this is i am only for taking the  StartDate . Once i will get the Start Month   and Year to InPut Month and Year , we are going to calculate the sum of Segment  from Segmet Tabl

SCC   startDate EndDate  

the above is my 3 table structure

Now i want a query for update  second table 

SegmentCalculation.YTD =( 
SELECT     sum(Segment) as Total       
FROM    SegmentCalculation P
        inner JOIN TblAgency A ON P.PCC = A.PCC
   left JOIN TblStandard T ON A.groupcode = T.SCCode            &n

MS SQL Server: Search All Tables, Columns & Rows For Data or Keyword Query

If you need to search your entire database for specific data, this query will come in handy.

So when a client needs a custom report or some sort of custom development using Great Plains, most of the time I will have to track down the data in the system by running this query and find the table(s) it is in.

sql server 2000 vs 2005


i would like to ask what the difference between sql server 2000 and 2005 

Query an arraylist of array list using linq


I have an array list called Customer. I t holds a list of array list which has the account details.

proj.customer -> collection of arraylist of type customer

proj.customer.account -> collection of arraylist of type account

Account array list holds type account and it has a poperty account balance. How can I query all accounts which has account balance  >100

I tried the following one

var Accountlist= from Account accountdetails in proj.customer.account

where accountid.balance >100

select accountdetails.id

But it is always throwing an error saying cannot cast type customer to type account

Please help

Parallel LINQ: Running Queries On Multi-Core Processors


Use Parallel Language Integrated Query (PLINQ) to take advantage of multi-processor computers and the newer wave of multi-core processors.

Joe Duffy and Ed Essey

MSDN Magazine October 2007

Extreme ASP.NET: Tools of the Trade: SQL Server Profiler and Query Analyzer


In my last column, I discussed Microsoft® Application Center Test and how it could be used to measure the performance of your Web application (see Extreme ASP. NET: Tools of the Trade: Application Center Test).

Rob Howard

MSDN Magazine August 2005

Data Points: XML Features in SQL Server 2000


SQL ServerT 2000 includes several XML features that let you transform relational rowsets into hierarchical XML documents, read XML documents, and bulk load data via XML. For example, you can pass an XML document to a stored procedure, join the XML to some tables and return a rowset, or even modify data in the database.

John Papa

MSDN Magazine June 2005

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend