You could also use sysprocesses for a quick ref.

This is a system-table, NOT to be modified/updated by anyone but the system !!

But you...

I guess your reboot-policy comes from an NT-4 era

We only reboot if fixes are planned and installed or if our production-plant has a...

I've used PSTAT.exe from the Wk2 resource kit to capture the data,

then transfered the intercepted output to a central place

, imported them into SQL and ran a filterquery to...

print screen on a stone plate ??

I've got 50+ servers to monitor.

Thé big thing with any RDBMS (sqlserver/oracle/db2/...)  is to work set-oriented. Once you get that in the fingers, things will work smoothly.

Maybe...

Let's hope your worktables are no #- or ##tables

These are only available within their own connection.

- Avoid using a cursor !!

Is this what you aim for ?

Declare @MyError int, @MyRowcount int

   Update S

 SET NAME = REPLICATE(  CHAR(65 +...

- How many times is your trigger fired ?

  (I've seen systems that perform an insert and then do a couple of updates to the same row to complete data....

win2k3 ? MSDTC enabled for remote usage ?

you'll have to look for negative length parameter used in a substring function.

I've encountered this some times when using "dynamic" substrings based on CHARINDEX.

e.g. select substring(mycol,

April 14, 2005 at 12:41 am