Thnx to all for your valuable feedback !! .. 🙂

Yes, I am able to create the SQL Agent Jobs. But, in the job, while trying to add the steps the error is appearing.

Unable to attach the screen shot here....

Very nice question.

Slightly different than the one, we get generally !!

Thanks Reo. This is the exact doc I was looking for. Quire relevant in my context.

Thanks a lot Lowell.. I am now using the below string...which is still fine.

[SELECT @fileDate = CONVERT(VARCHAR(300),GETDATE(),112) + '-' + REPLACE(CONVERT(VARCHAR(35),GETDATE(),114),':','')

]

Use master

GO

declare @filename varchar(400)

declare @filedate varchar(300)

declare @path varchar(300)

declare @name...

I do agree with "england0".

The system databases are excluded from Database snapshot. Question doesn't to look like correct..!

Hello Guys

I am still facing the same issue. The restore job in the Secondary Server is failing with the error.

==========================

The restore operation cannot proceed because the secondary database 'GTM_LS' is...

I had fixed the issue.

Actually, there was a timestamp column in the source table, so while doing the BCP IN, it was erroring out since the timestamp field must be...

Nice one. I hope 2.50 and 2.5 or 3.60 and 3.6 are taken as same!

I just checked the datatype of all the available columns in the table, and found that, the table doesn't have: BLOB or image type data. The used data types are-

timestamp,...

The link doesn't help me much....!

exec master..xp_cmdshell 'bcp hghj.dbo.file1 in "C:\Manoj_Table_Contents_BCP\file1.txt" -w -n -T -S W2TZDF4B02'

I created the table in my local SQL Server (SQL 2K5), with the same...

It is SQL 2000

Thanks Guys, for all your suggestion.

However, what are the best points u had mentioned, I followed everything before-hand itself. No Luck so far.

OS installed to the server: Windows Server 2003...

By default, the audit events are written to the audit target in an asynchronous fashion. Question was not posted properly I guess.

Dear Lynn

In your query analyser, after executing the below query, are u able to see the result as 6?

select name, endpoint_id from sys.endpoints where endpoint_id < 65536

I think TCP port...