Viewing 15 posts - 36,931 through 36,945 (of 39,818 total)
My 2 cents. This is pretty good, though be sure you can deliver what you promise. If you don't you sully your reputation rather than enhance it (for that job).
However,...
November 15, 2002 at 2:55 pm
How long are the locks held? I wouldn't expect most of these to run long.
Steve Jones
November 15, 2002 at 2:44 pm
seems pretty easy in SQL Server as well.
Steve Jones
November 15, 2002 at 2:43 pm
Is your local server set for SQL Authentication?
Steve Jones
November 15, 2002 at 2:42 pm
though by ANSI standard, the order of the rows returned is not guarenteed. If you want a particular 1000 rows, include an order by (which might force a table scan.
Steve...
November 15, 2002 at 2:41 pm
decrypter in the script library here as well.
Steve Jones
November 15, 2002 at 12:09 pm
I'd batch a script of the jobs and store it somewhere. Easier than messing with permissions on the jobs.
Steve Jones
November 14, 2002 at 1:23 pm
Wrote about this recently:
http://www.sqlservercentral.com/columnists/sjones/killthattarget.asp
Steve Jones
November 14, 2002 at 10:44 am
Wrote about this recently:
http://www.sqlservercentral.com/columnists/sjones/killthattarget.asp
Steve Jones
November 14, 2002 at 10:36 am
you are welcome. It's one area we need some more articles to let people know how easy it is. Glad it worked for you.
Steve Jones
November 13, 2002 at 4:41 pm
There isn't a good way in SQL to script out everything. There are ways to get at the data, but no easy way to script them. Is there a reason...
November 13, 2002 at 10:25 am
Thanks. It is simple, but you might end up digging around and no one wants to do that in a pressure situation.
Glad you like it and hopefully this is an...
November 11, 2002 at 9:25 am
Not sure if this is a huge problem. Could lead to some confusion and Brian has good points. In general, if you do not need a stored procedure executed from...
November 8, 2002 at 9:33 am
November 8, 2002 at 9:26 am
Viewing 15 posts - 36,931 through 36,945 (of 39,818 total)