Satish,

You can get that information using Activity Monitor

That query will list *all* sessions open on a given database. Just tweaked the query. In the output you can filter out the "internal" and "external" sessions based on the...

Satish,

You should be able to get the requisite information using this query.

SELECT * FROM sys.dm_exec_requests where DB_NAME(database_id)='YourDBName'

The easiest alternative would be to schedule a Windows Scheduled Task to run a batch file which does

NET STOP SQLSERVERAGENT

NET START SQLSERVERAGENT

Salman,

There is no Service Pack for SQL Server 2008 R2 yet. CU4 is the latest and you can download it from here

This article has all the details.

Ashkan,

Sorry I did not notice the forum under which this question was posted. In SQL Server 2000, this stored procedure does not exist and the only way to recycle the...

You can make use of sp_cycle_agent_errorlog in SQL Server 2005 and above.

In that case, instead of calling WinZip from an UNC path, you can directly refer to the local path as "C:\Program Files\...."

7-zip does not require any command line tool to...

I am not too sure if you can call WINZIP.exe from a UNC path. Did you try installing winzip on the computer from which you are executing this comd?

I have...

You are getting this error because some sessions are active on that database. Execute this query to find out which are those sessions and KILL them.

SELECT * FROM sys.dm_exec_requests WHERE...

Unless the names have a pattern it would be difficult to define any logic.

This question should have been posted in the SQL Server 2000 forum here

@hydbadrose,

Please start SQL Server instance from the command prompt (sqlservr.exe). Wait for a few minutes until the master database is upgraded. Then try connecting to the instance using...

You can make use of MSXMLFIX.exe. More details here[/url]

You can also make use of Change Data Capture in SQL Server 2008.