I tried sql ping for a while, the command line version, but it takes forever because it needs to look at each IP.

It returns a nice report of what version...

Great article - I've been locked out of servers by vendors who won't share the sa password and have had to go through hoops like this just so I could...

Before I got a neck injury I was a black belt and it was a great way to blow off steam.

You kind of forget about a lot of things when...

No I hadn't and for a sql 2000 instance that just may do the trick!

That's what I love about these forums - there are so many good ideas out there.

I set up a user id called 'batchid' on a test server and created a logon trigger like this:

CREATE TRIGGER usrLoginCheck_LogonTrigger

ON ALL SERVER WITH EXECUTE AS 'batchid'

FOR LOGON

AS

BEGIN

...

I am running SQL 2005 so the LOGON Triggers, DDL Triggers looks like just the ticket.

I'll have to experiment on a test server to see how they operate but from...

I'm not a network guy either so I was hoping someone else would know if it could be done and if so how to do it.

I know net nanny can...

Your article referred to timestamps but I've had the same problem with date fields in Oracle and had to do the same thing you suggested and convert them to character...

Perhaps another reason that CLR is not being adopted is that it is a lot more involved than using TSQL and for the added complexity there needs to be a...

I for one despise the certification process as just another money making scheme for M'soft.

I get really annoyed when I go to a class and they gear it to the...

As a DBA for several platforms at a hospital I don't have a choice as to which platform to use but the vendors we purchase solutions from are overwhelmingly using...

I found this to be an informative and helpful refresher, thanks!

I too think it is obvious that the consumer should expect to pay for what he recieved.

I think that even though the other party in this transaction happens to be a corporation...

I have the impression that the certification cycle is just another money maker for the companies that provide the training and testing.

I'm sure the benefits of studying for an exam...

I too have used his utilities and have read with interest his work on rootkits, and I echo the concern that, having been assimilated into the borg, we may never...