Perhaps there is a way to run Litespeed on Server'A' to restore the database to server'B' ??

I think Litespeed customer support might give you the best answer, since versions and...

Thanks for the replies. We will find a different box to use.

I will put this directly before the restore:

ALTER DATABASE MyDatabase SET OFFLINE WITH ROLLBACK IMMEDIATE

That should be more reliable than the "kill @spid" loop currently in place.

Thanks

Resolved:

Seems I needed to set Protection Level = "Rely on server storage and roles for access control"

when importing the package from file system into MSDB.

Thanks. The way the documentation is written suggested each linked server had it's own "Provider Options" page

nivedita talukdar (6/24/2013)

I just edited the job and ran this below command:

SELECT * INTO trace_table1 FROM ::fn_trace_gettable('C:\PWB_Test\T.trc', 1)

The job went fine....and also deleted my T.trc file from folder...

But how do...

For one-time large deletes, I also do batches as suggested above. It can take a long time, but is not disruptive to other users and t-logs do not get out...

Thanks, that's helpful

I also found I needed the 64 bit ODBC driver:

http://www.microsoft.com/en-us/download/confirmation.aspx?id=20065

I am now able to query MySQL data from SQL, so I have made progress !

No, I haven't delved into that .... not a lot of SSIS experience. The package itself runs fine though when run "stand-alone". It doesn't run when invoked from a...

Thanks for all the replies.

It runs every day at 4:00 am, and usually take 10 minutes. It processes a list of members and their recipeints of emails for reporting...

Nice Reply 😀

I don't really want to take on anything else right now, but may have to.

Back to my original question, would you expect that table to be locked until...

You asked for it 😛

Here's the code as I found it. The table being locked from other users is WebSiteMessageRecipient

CREATE PROCEDURE [dbo].[spWebSiteMessageDumpProcess]

AS

BEGIN

-- SET NOCOUNT ON added to prevent...

I only see a transaction inside the loop, doing a commit/rollback based on error code.

Good question .... not part of a solution that I know of .... (But I am part of the problem it seems

Do I need to save it as part of...

Yes, thanks