I had a three-table solution. One was currently active data, which was only a few dozen rows, but was under constant updates, in terms of up to a hundred...

What edition of SQL Server are you using? Standard, Enterprise, or something else?

What do you get if you run this query in Management Studio on that server?

select * from fn_trace_getinfo(0)

That will give you data on active traces.

See if this helps: http://www.sqlservercentral.com/Forums/Topic735882-338-1.aspx

Are you asking for documentation on a recovery strategy, or for code?

I've done something very similar on 2000, and the data in Create View in BOL has all the rules on partitioned views. It's pretty easy to set up, and...

It has "downgrade rights", but doesn't have the installation media for it. Difference between having a right and having the tool to implement it. (Like, you have the...

Null and 0 aren't the same in databases. Null means an unknown value, a field that hasn't been provided with a value yet.

In that case, change the "is null"...

Check to make sure the file system rights are the same for the login the job is using and the login you're testing from.

Lowell's solution looks almost right. It needs to have a couple of typos fixed, and it checks for a non-zero value instead of null. Your original message mentions...

In order to do that, you need to have valid media for SQL 2005, including a product key. You can't install 2005 from 2008 media, nor can you use...

It sounds like you're asking for changes in the database engine, as opposed to changes in the features. You're more likely to get a valid response on that directly...

I guess it depends on what exactly you want it to do.

For example, does it reject the insert and raise an error, or does it accept the insert but also...

That makes some sense. Let me know how it goes, please. I'm very curious.

The wider spaces are probably from emptry strings. That would result in a double-space.