81 reputation
3
bio website
location
age
visits member for 1 year, 9 months
seen Apr 3 at 3:24

May
24
comment Exporting database Oracle 7.3 on Windows NT 3.51
Wow, it's been about 18 years since I've been near a server like that. Is this syntax more helpful? EXP73.EXE USERNAME/PASSWORD@INSTANCE FILE=OUTFILE.DMP FULL=Y LOG=LOGFILE.LOG
Jan
11
comment WSUS for SQL server patching
Two interesting answers, adding to Aaron's answer: I wouldn't use WSUS for updating a SQL Server that is rev-locked by a 3rd party vendor application thus breaking the app's support agreement, or for updating a server with the WSUS database on it. However, I would consider it for a small db server in a dmz.
Sep
21
comment How do I monitor which Windows user is logging in as SA?
Great point Aaron, and sys.dm_exec_sessions is four times faster than master..sysprocesses (19 msec instead of 77 msec), I've edited the snmp trap query above.