Viewing 15 posts - 37,936 through 37,950 (of 39,456 total)
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
You can query to see if new objects have been created. There is a create data in sysobjets. If the objects are altered, however, you cannot determine this with a...
February 20, 2002 at 3:27 pm
Not sure about the syntax for the BCP. Guess you'd need a shell of some type.
To execute another package:
Dim oPkg, intError
Set oPKG = CreateObject("DTS.Package")
oPKG.LoadFromSQLServer strServerName, , , 256, , ,...
February 20, 2002 at 1:17 pm
I wouldn't do this in a trigger. Instead, use the trigger or the original code to insert a value into some process table. Then have something that runs every minute...
February 20, 2002 at 1:14 pm
February 20, 2002 at 1:12 pm
Viewing 15 posts - 37,936 through 37,950 (of 39,456 total)