I assume it's not listed in sys.databases at all?

I might look to remove anything from the registry that references it. Not sure what's there, but dig around under HKLM/Software/Microsoft/Microsoft SQL...

It's fairly simple logic in the WHERE clause, no different from a select clause.

In fact, I'd recommend testing with the SELECT first, then changing the update.

You can add another AND...

VMs have a config file and virtual disk file, which have creation dates, but again, I'm not sure, whether thought out or not, that this has something to do with...

I'd go look at what's offered by SQL Skills, Solid Quality mentors, Scalability Experts and see if something fits. Lots of those people who deal with large systems are at...

What is standard auditing?

In 2000, there isn't any good way to do this. Triggers won't help. Instead you'd have to set up a trace that would capture SELECTs against this...

I do run ad hoc queries here and there. And no, not likely to expose that 🙂

The MVP leads contact me at times, and feel free to refer them to...

I'd start here: http://www.sqlservercentral.com/articles/Monitoring/61373/

You'd have to examine the execution plans but my hunch would be just put them in the view.

I'm with Jack. #2 is easier to read, but I'd suspect that #1 works better.

What are the errors? The script looks OK here. Conversion errors usually mean you're not extracting the data correctly.

If you had the rights, and could dbcc inputbuffer your SPID, that might work. But it doesn't always get you everything.

What are you trying to accomplish here? Figure out where...

I'm not sure what you mean. Do you mean you need both conditions? Or update if either is there?

The Microsoft classes are geared towards teaching the exam, not getting you better at strong skills.

Really you need one of a few things. A custom class from End to End...

Profiler/SQL Trace is really your only choice here. Set up a trace to capture stuff hitting the table.

Closing this thread as it's drifting a bit.

Please post requests in the appropriate forum.