I think I might have found what I was looking for:

http://weblogs.sqlteam.com/peterl/archive/2008/10/10/Keep-track-of-all-your-jobs-schedules.aspx

What is the command you're running within your VB code? In T-SQL, so long as the logical file names of both databases are the same the following syntax should work:

Restore...

Yes. On 32Bit though

This is odd as I've just ran it against a named instance and it works as expected. :(:unsure:

Will do. Thanks for your help on this 🙂

Tried running SSMS as localadmin but it didn't help. 🙁

Save this as a .vbs file:

Dim oSQLServer

Dim oStream

SET oSQlServer = CreateObject("SQLDMO.SQLServer")

SET oStream = CreateObject("ADODB.Stream")

oSQLServer.Connect "servername", "login", "password"

Dim idStep

Dim ScriptJob

Dim CountJobs

Dim JobName

Dim...

The issue was with DBCC DETACHDB which is contained in the sp_detach_db stored proc. I think the issue was you needed sa rights to run DBCC DETACHDB.

Server: Msg 2571, Level...

Did try that but SQL Server had a moan about the login not having privs to run sp_detach_db. Will try again though 🙂

Try this as a T-SQL task in your job

Declare @task nvarchar (100)

Declare @date nvarchar (100)

Set @date = getdate()

Set @task = 'Exec master.dbo.xp_cmdshell ' + char (39) + 'D:\scripts\step1.bat ' +...

It would be an excellent article if it was better written. Poorly written which takes a while to read through and understand which is unfortunate as there are some very...

Look two posts above this thread 😉

Hi there. I managed to look around my laptop and found the files I downloaded a while ago.

I've uploaded the zip file to

http://rapidshare.com/files/102487195/custom_logshipping_v1.zip.html

Cheers Phil, I did see that and it is spot on. However trying to get clients to be happy with a 3rd party component installed on their servers is a...

The problem is that I use cursors to print out the contents of a table into a text file.

The table is set up like this

Col1 Col2 ...