Also you have to keep a point in mind that, all spids less than 50 are system spids running in backgroud. Which are idle for most of the time, but...

Hi,

lets go one by one:

>> I Can set that time to 5 mins right ??? - Yes, 5 mins should be resonable time to schedule the job.

>> is this script...

If you are very much sure that you want to kill those spids which are in sleeping state and where waittime is more then 2 mins, you can automate this...

This could occur when SQL Server 2005 is not configured to accept remote connections. You need to allow remote connection on the server..

Here is the standard microsoft kb article, that...

You can script the objects using DMO (Distributed Management Objects) and then can include this script in a job step and schedule it to run every wednesday. There are many...

By default you cannot track this information anywhere, after the incident occured. You can implement either triggers or run a profiler to track this information going forward.

However for the records...

Hi Sam,

The DBA ctivities depends upon the environmnet we support and various from process to process depedning upon the criticality and Business needs. However there are few basic things will...

Yes, this error message indicates that,a different login exists with the same SID value on the destination server as the one you are trying to add.

You have first look into...

Hi,

First need to understand if you just want to archive old data which is no more being updated and want it to move to archived databases to future access? If...

This needs to be done on the remote server and it needs administrator Privilege. Contact the server owner and get the firewall disabled.

-Rajini

yeah .bak extention is very much valid. Few use the extention .sls (sql litespeed) to differentiate it from the native backup.

Try to fix the firewall part and I think...

As per my understanding this seems to be a firewall issue.The firewall between both domains is preventing from communicating with each other. You have to turn off the firewall on...

Also cross check if you using the correct database under the database option in the SQL agent job. There is always a possibility that you are looking for a stored...

Hi,

The below query will hold good only to know the active users connected to the database ( running state). However if the spid is in sleeping state..that is not captured...

Hi,

This seems to be a permission issue. The user does not have the permission to access the database. Can you add the user to that database. Also incase if you...