I did not know of this aritcle -- but when log shipping broke Saturday because of a third party log backup I decided I had nothing to lose if it...

Try putting the server name in double quotes like -S"abc\xyz" I have had similar problems and the \ in the server name seems to throw bcp

I couldn't resist -- I wanted to query to find them. Didn't read all replies first. So here is my simple query to find a table without an...

The following dm views also need "View Server State" to function

sys.dm_exec_sessions

sys.dm_exec_requests

sys.dm_exec_connections

Therefore these cannot be substituted for sp_who2 which also needs the same permission