I think I'd do something similar to what you're doing. I might create a real table, populate with the data + SPID perhaps, extract batches of 300 from there. Maybe...

This should be a list of options set for the database. Is there something set differently on that database?

You can look at the code for this proc in master to...

This help?

http://support.microsoft.com/kb/271624

You could set some things up, like DDL triggers, but a sysadmin could disable them.

Remove them from sysadmin access if you need to.

The above is correct. Once you've done this, you require a full backup to be able to restore. This should not be a standard practice in production. The TRUNCATE ONLY...

Can you explain what you mean by combine? Run both of them together? Run one of them based on Z?

Please don't cross post.

Answered here: http://www.sqlservercentral.com/Forums/Topic440533-338-1.aspx

Any of the 2005 books are fine. I like the one from Brian Knight, but I know him and he's a business partner.

That's really the only way to make this work. The trigger will always execute as the person updating the table, and it would need rights to the other database if...

Inside SQL Server is here: http://corporate.books24x7.com/home2.asp

I like to stay fairly current, but if I couldn't thoroughly test, I'd wait for SP3. I would recommend if you have an issue fixed in a cumulative pack, get...

I haven't messed with the maintenance plans much in BIDS, but you should be able to open them in SSMS, under the Management folder. There is a subset of SSIS...

Typically named pipes is disabled on SQL Server. I think W2K used that as the default, XP uses TCP/IP. Change the Win2K machines to TCP or allow named pipes on...

RAID 5 isn't recommended. I'd really look at R1 or R10 for this, they will give you better performance.

When you say temporary files, do you mean temp tables in tempdb...

First, why do you use those values in the HAVING clause instead of the WHERE clause?

Also, it's not really clear what's not working. If you get extra rows, then you...