SSwords said: "What if a device were programmed not to steal data, but to delete or damage it by launching a new virus worm from inside the company firewall?"

Though this...

Thanks, Brian! I didn't know that you could have traces running outside of Profiler, I just did some reading up on it in BOL. I would assume that...

Brian: You can with 2000 if you use tracing. That's the audit mechanism. There are trace events corresponding to object creation/deletion.

But then you're dealing with having Profiler running constantly, how...

If I recall correctly, 2005 allows you to audit changes to the system catalog, so it would be possible to log the creation of database objects. But under 2000,...

I would create either a reference table consisting of Month# and Month Name then link that into your query for your order clause, or perhaps do it through a UDF....

Thank you for the recommendation, Michael. I'll check it out.

I have heard that the Sybase cert is a real bear compared to the MS cert, but once you're certified, it's gravy train time. 🙂

FWIW.

I wrote this A LONG time ago, you might find it useful. There might be a metadata object that has this info, but I'm not too up on what...

Personally, I create a view that gives me a select from the meta data. The TOP 100 PERCENT allows you to do an ORDER BY in a view. ...

I am VERY disappointed. There is obviously a dearth of hard-core Dos or *nix people here. 🙂

From a command prompt you can do:

c:\>ipconfig | find "IP Address"

You can get...

I may be totally off-base on this, and I can't find anything in BOL to back me up, but it was my understanding that UNION views are SELECT or INSERT...

You could possibly look at a hung transaction preventing the log from shrinking below a certain point. Basically it's a transaction that, as far as the system is concerned,...

I posted this in May, I am not a fan of outsourcing and here's my rant why.

There are two problems with off-shoring (ok, slightly OT, but related, and as the...

I haven't read the article yet, but today this site had an article on encryption and SQL Server. Perhaps it would be useful. It has what appears to...

SOLUTION!

Logs didn't show anything. Our support tech, don't ask me why, suspected a video card driver. Like I said, don't ask me why. Anyway, when he came...