Try MOM 2005 (Microsoft Operations Management). It's got everything a DBA could want to monitor (and a lot more) with the SQL Server...

If its for application security such as password storage (one way encryption only), try undiocumented functions pwdencrypt() and pwdcompare(). Otherwise you'll have to resort to third party software/calls.

You've tried cable switching. You're looking at the 3rd party software vendor)have you un-installed it yet ?). Regsitry, well thats everyone's own choice ... How about NIC settings. I've had...

How about using the MOM (Microsoft Operations Manager) ? It will monitor a plethora of things SQL related, notify you and optionally execute commands/scripts to remedy issues you've encountered. We're...

MainFrame, Digital, Altair, CPM, MPM, PC-DOS, MS-DOS, Win3.11, NT v3.5 ... and only a few grey hairs

No. TRUNCATE_ONLY clears committed transactions and writes a record to the log. So if it's full it fails and then suggests that you use NO_LOG (which does the same thing...

I've used Ethereal on and off for about 4 years now. In each of the 3 locations I've worked at the in-house network staff has used this product exclusively for...

The 'forcing' of integer division given in the examples above rely on 'implicit' conversions. Functional, yes; a best practice no. CAST/CONVERT are the functions to use in order make things...

Usually backing up over a network toa disk on another machine is a big no-no. However Microsoft left a hole in things to accomplish just that (if you have faith...

If you are after speed, try adding solid state disk just for your transaction logs. In a benchmark about 5 years back and the results on high volume insert/update/delete were...

You could do this quite easily if your site is using SMS. If SMS has gathered the information you could generate a report via the console or query the tables...

DECLARE @return_code int

EXECUTE @return_code = execute sp_disasterrecovery

IF @return_code = 0 execute sp_update_resume

ditto here ... Cisco VPN, RDP Client, multiple server connections executing EM all via a 128 Kb ISDN line ... no problems ... it's almost like a desktop workkstation onsite...

All that for only 100 K ??? Let's get real here  ... besides, this is a...

I agree about 2 possible answers ... although the more accurate answer would be a combination of adding the cluster resource and then taking SQL Server offline and online again...