I have used Linked servers quite a bit.  If you are calling a stored procedure via linked serverrs you need to make sure RPC is enabled.  I am by no...

I am still amazed at how well this process has served me.  It also makes it easy to keep a copy of all my DTS pacakges from various places without...

Hi Douglas,

Thanks for the reply. I agree with you in some cases but how many servers are you managing?  In a single server environment I think your points are well...

One caveat to logging information to a file. Make sure each package that runs at the same time logs to a different file name. The packages can "Blowup" trying...

I schedule quite a few things using SQL jobs. I believe this is the same thing as the agent. Here are some things I found...

1. I ran...

Now I see your issue. 🙂 I have the sending company send me two files. A large .Zip file and a small .DONE file. I do not and...

Have you modified the code at all? The .Done file is going to be located in the ftp directory. If you right click on the DTS package one of...

I took the code from what Andy had done to do my backups. Things I have tinkered with to make it useful in my situation. I have some code...

there is a wscript event that writes to the application event log.

set wshShell = createObject("wscript.shell")

WshShell.LogEvent 0, "The following process was killed programatically "

This works in VBS for me it should...

Hi Brian,

Wow, if I was ever included with Andy on SQL-DMO being one of the "guys." Thanks a lot! What I was guessing you meant was SQLServerCentral and...

Hi Andy,

Nice article, I have learned a ton about SQLDMO from your articles. It is amazing what can be done using this object model.

Bruce Szabo, MCSE+I, MCDBA, MCSD

Everything looks fine to me, unless DBs would not allow logins to be restored with the database which is not my experience. I do some restores between servers to...

Although it is complex and not something I have used I think without a doubt what you are looking for requires replication.

I think replication is a complex topic...

It sounds like you have a table on one server with this field in it but on the new server this field is not present. There is a product...

The feedback to ther articles is amazing. In some cases just some ratings feedback is nice but it is a lot more humbling putting an article up and knowing people...