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

Hi Loki,

Please try adding the "sqlservr.exe" to the exception list of Symantec.

I feel the date format of the servers differs. Please check it in "Control Panel --> Regional and language Options --> Customize --> Date".

I think I misread you question.

Please try using CONVERT as below.

select * from tbldeals

where CONVERT(VARCHAR(10),trade_date,111) = '2009/03/06'

Correct. Please try changing the compatibility level of the SQL 2005 database to "90".