Or:

begin

declare @sql nvarchar(1024)

set @sql='xcopy "d:\mssql\BACKUP\*.bak" \\MyServer\backup  /V /R /K /Y /Z /I'

EXECUTE xp_cmdshell @sql

end

see if that helps: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=65&messageid=287820

correction: defrag database should read as dbcc shrinkdatabase 

LSN has to match. Unless there is a program which can do that...Next time think about making Diff backup at least once a day. By the way, can you restore missing...

I would agree with Noel. Some time ago from our 900GB database we archived about 200gb and decided to defrag database. Defrag ran for over 20 hours and it was no way to...

See if you have white space to performing that...

See if you can use shrinkdatabase instead of shrinkfile, but it takes longer...

40,000 In Clause elements in the above example I can get back literally within few seconds...

insert your data from the IN Clause into temp table ( make sure temp table has an index)

And then make join between temp table and perm table and your performance...

Or:

Set objComputer = CreateObject("WScript.NetWork")

MsgBox(objComputer.ComputerName)

Set objComputer = Nothing

From my personal experience with LiteSpeed: you can do backups of individ tables, but somehow restore doesn't work ( but it supposed to work!)

Did you try running trace while this package is executing?

User accounts used to start the agents on both machines has to have privileges to read & write to the share folder where Tr logs are stored...

Did you try the following?:

EXE sp_insertRecord 4, 'ER Vol 1', 'DVD'

GO

EXE sp_insertRecord 5, 'ER', 'VHS'

GO

EXE sp_insertRecord 6, 'Sixth Sense', 'DVD'

GO

--- Delete record with...

try to run SQL Server trace ( as opposed to SQL Profiler which is the client-side implementation)...and see if it is produces less load...

You might want to take care of this problem on the front end using smth like that:

replace(CStr(Request.Form("LastName")),"'", "''") when inserting into DB.