Viewing 8 posts - 1 through 8 (of 8 total)
We use pretty much the same method as David and some others. It is really based in the "Programming by contract" concepts from OO design. The docs include...
November 12, 2003 at 7:11 am
Unfortunately, Kill really only sets a flag for a spid to "KIll yourself" If it never comes back to see its "Kill yourself" flag set, it will just sit...
October 27, 2003 at 2:38 pm
MSDE does not install any of the tools by default so you must have installed them from another source. So, you likely have 2 different issues.
Take a look at...
October 27, 2003 at 2:34 pm
This could be any number of things. Is this a server with high utilization, limited memory, I/O bottlenecks....
How are you determining the CPU utilization?
The SP doesn't use...
October 27, 2003 at 2:23 pm
We use the sp_cycle_errorlog. We have not had issues with it. Scheduled tasks have been running for years.
October 27, 2003 at 1:49 pm
An interesting conceptual article with limited practical use. However, the author does caveat the baggage of EXEC commands.
Using this requires explicit permissions for users at the table level...
October 24, 2003 at 10:31 am
Viewing 8 posts - 1 through 8 (of 8 total)