You need to have sufficient delay between the copying and restoring the log backups. This is to take account of network condition and if the log backups are large. The...

Does using instead of trigger mean I have to handle the insert and delete in my script after saving the record to my audit table?

How can you use app role to control access from MS Access? Anyone who has done it before or knows how it can be done should please explain.

Thanks.

Thanks for your suggestion. I have decided to use the isql as suggested.

I need to do this everytime the sp fires. In fact the sp is going to be scheduled as a job. The result is to be emailed.

I made the chnages but still got the error.

I am psoting the entire query in cae it might help.

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

DECLARE @ID INT

DECLARE @Name varchar(200)

DECLARE @Text nVarchar(2000)

DECLARE @cDate datetime...

I have the following:

DECLARE @Name varchar(200)

DECLARE @Text nVarchar(4000)

Can this be the problem?

One thing I have done is to delete a case using the test server and use profiler to find all the tables involved in the delete. There was a total...

The company that supplied the application built the queries into the front end. The company says it does not want anyone to have an idea of how its application works...

Thanks to all. I found out that strangely enough the differential backup and the trans log backup at 10am were being done with the the noinit option. Changing this to...

Thanks for your replies. This large diff backup only started in the last 2 days. I do a tran log backup at 10am, 2pm,4pm and 6pm. The 10am trna log...

Thanks a lot for your help.

Thanks. Does it mean I can not use getdate within a a user defined function.?

How can I work around this?

The link below will answer all your questions concerning log shipping. It contains the steps you need to take. Just print it out. Hope it helps.

http://www.microsoft.com/technet/treeview/default.asp url=/technet/prodtechnol/sql/deploy/confeat/sqlha/SQLHALP.asp

The URL...

Thanks. We have 2 apps that need to run with 2 different versions for compatibilty reasons. I also got help from MSDN Library which confirmed what you said.