Viewing 15 posts - 1 through 15 (of 48 total)
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...
April 1, 2005 at 8:32 am
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...
January 28, 2005 at 5:14 pm
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...
April 8, 2004 at 6:44 pm
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...
June 5, 2003 at 6:28 am
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...
February 26, 2003 at 7:15 pm
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...
November 22, 2002 at 4:26 am
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...
November 20, 2002 at 6:27 pm
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...
October 5, 2002 at 6:16 am
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...
September 27, 2002 at 11:47 am
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...
September 19, 2002 at 1:22 pm
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
September 19, 2002 at 4:21 am
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...
September 12, 2002 at 8:24 pm
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...
August 29, 2002 at 5:02 am
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...
August 29, 2002 at 4:59 am
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...
August 28, 2002 at 7:29 pm
Viewing 15 posts - 1 through 15 (of 48 total)