Also check whether single quotes (') are there in comments column....

Can u pls tell what createdate u want.... Even u can try with max/min in ur query... depending upon the requirement...

Sankar,......... Appreciated...

Check whether you can open the database...... (if u r aware of sql server...)

I agreed with Gail's Suggestion.

Meanwhile you can check whether dropping and recreating indexes will help....

Check..... This will resolve ur problem.

bcp [ServerName].[Owner].[TableName] in "Path for text file" -c -SServerName -UUserName -PPassword

Take the latest log backup and apply on the mirrored database. Then reconfigure mirroring. Hope it will work.

Do u want to keep the rights/permissions from the prod server to the dev server or u want the rights what ever in dev server remains same?

Did u check updatedate column in sys.syslogins table for ur login???

Check whether the shared folder is accessible from the server where u r doing restore operation. Also u can check the permissions on the shared folder for the windows user...

I knew its a silly Q.. Can u pls check whether its a correct filename u have mentioned ( as per ur database).?

R u using port no. with IP Address???

LogShipping jobs runs continuously as the way they are configured. If network goes down for what ever reason, the copy job will fail. As soon as the network comes up,...