Viewing 15 posts - 37,966 through 37,980 (of 39,490 total)
You are confusing this info. The job is the definintion of a command that runs. What is runs is something separate and that could be deleted.
The job is encrypted so...
February 21, 2002 at 4:22 pm
Just making sure everyone else is paying attention. Hopefully others will read this before trying the patch.
Steve Jones
February 21, 2002 at 2:57 pm
It will if it connects to that server. If it connects to another server, you won't see anything.
Steve Jones
February 21, 2002 at 2:55 pm
February 21, 2002 at 11:36 am
The way that MS.com does it, or used to, was to write out XML files (flat) onto each web server. These are then transformed by the ASP into what you...
February 21, 2002 at 11:35 am
Dirk,
try logging into the server as the account under which SQLAgent runs and see if you can execute this.
Steve Jones
February 21, 2002 at 11:22 am
Is the pacakge on the same server as this is executing? That is the exact code I am using and I place the name of the package in a global...
February 21, 2002 at 11:18 am
Hold off if you can. If you feel you must apply the patch TEST IT ON A SECOND server.
Steve Jones
February 21, 2002 at 11:12 am
Brian and Antares are right. You can change the sort order at the db level and not affect other dbs.
CPU is more often, IMHO, what kills a server. If you...
February 21, 2002 at 11:07 am
February 21, 2002 at 11:05 am
Sorry, this is one of those things that is very difficult to track down. One thing you might do is before you run the process that fails is save off...
February 21, 2002 at 10:42 am
Probably. Profiler will at least tell you if this is doing something on your box. It might be doing something on another SQL box, in which case, you'd have to...
February 21, 2002 at 10:39 am
Yes. When running Active/Active, you have 2 SQL Servers. there is, of course, a shared virtual SQL Server as well, but the two instances "pose" as this virtual.
change them...
February 21, 2002 at 10:22 am
Perhaps. You'd have to have a reference to the existing package and then add an object to it.
Is there some reason you do not want to call another package?
Steve...
February 20, 2002 at 3:30 pm
You might try searching for some .DTS files on the server and see if there are any.
Steve Jones
February 20, 2002 at 3:28 pm
Viewing 15 posts - 37,966 through 37,980 (of 39,490 total)