Why do you need to shrink it? Is this for test?

You can shrink it afterwards, and I've heard that Hyperbac supports this restore (less than original size).

Nate,

Send a note to Red Gate Support on this. I'll ping them as well.

Sorry, was in a scheduling mode and missed this was a holiday. I know, I know, I should pay more attention. Between PASS and Thanksgiving (plus vacation) wasn't keeping track...

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?