Viewing 15 posts - 36,886 through 36,900 (of 39,771 total)
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
November 7, 2002 at 11:09 am
the inputbuffer has the values for each user. Not for the database. Guess you could query sysprocesses to find out who had the last query (there's a timestmap in here)...
November 7, 2002 at 10:12 am
Viewing 15 posts - 36,886 through 36,900 (of 39,771 total)