You cannot restore a SQL Server 2005 database backup to SQL Server 2000.

Hi Ratheesh,

This [/url]script on SSC might do the trick for you.

Sometimes it takes that much time, depending on what it was doing before kill.

DBCC INPUTBUFFER(SPID) would tell you the current status.

Hi Ratheesh,

You are referring to "TEMPLOG" as the database instead of "TEMPDB". Change it to TEMPDB and everything will be...

You may find this article on SSC useful.

Looks like a duplicate post of this

You cannot use ALTER COLUMN to set the Defaults. The below query should work.

I assume that your requirement is "Log Shipping". More information can be found here.

Please check whether any scheduled jobs like 'Backup' or 'Re-index' jobs run during that time. Also check for any "Blocking" processes during that window.

If not, please also check any resource...

Hi Vijay,

The SQL Server Logs and the Windows Event Log would certainly have some information regarding the SQL Mail failure. Please try to post them here.

Hi Ansar,

I presume that you are running SP1. The comments here might help you resolve the issue.

Hope this helps..

Hi Waseem,

Hope you are doing good.

You can find out whether the user is locked or not, using the below query.

SELECT Name FROM SYS.SYSLOGINS WHERE LOGINPROPERTY (name , 'IsLocked') = 1...

Hi Manoj,

Please verify whether the Owner of the job has access to the Linked server.

These links might help you

http://msdn.microsoft.com/en-us/library/ms190374.aspx

http://technet.microsoft.com/en-us/library/ms179478.aspx