Viewing 3 posts - 1 through 3 (of 3 total)
Rudy,
If I am not mistaken, this connection would be a linked server connection to the other server.
If so, can you create objects (i.e. Tables, SP's, Views, Jobs, Functions) remotely via...
January 15, 2009 at 7:32 am
#927295
You can save the DTS package as a SSF file (.dts) extension.
Then copy the files from Server A to Server B and then open package
in Server B and save it...
April 1, 2008 at 11:50 pm
#797023
Go to msdb database
Look for the Maintenance plan you want to delete
select * from dbo.sysdtspackages90
Then delete it from there.
I got rid of mine this way.
Good Luck
February 15, 2008 at 10:17 pm
#779079