I've definitely a part of the training business, but you don't necessarily need formal training to learn how to do things well. Regularly reading, buying a few books, even debates...

That does make some sense, but I think you could get lots of common attributes in properties. Searching could be easier if you stored all the attributes in an XML...

It would be on the primary server.

Apologies for the delayed response and it may be gone by now. You might want to just restore a new copy of the primary...

Take all backups to separate files. You never know when you might have an issue with the file and then you lose multiple backups. There are scripts on this site...

Be careful in that your trigger only works for one row inserts/updates. If someone inserts 2 rows, you might not get the right behavior.

Also, I'd really suggest you create a...

It doesn't have any effect on the server. It's code that might be using this account to connect that would break. If it does, it shouldn't be using this...

The way the SQL parser works, it can't compile a plan without having a table name available, so this isn't allowed. Dynamic SQL (EXEC) as shown above is the only...

What do you mean by secure?

From the source or what you've collected? If you want to secure what you've collected, keep it in a separate db (I'd recommend one on...

Can you post the actual queries? Doesn't sound like you missed anything, but I'd like to see them. Also, if you check the data, what is the selectivity for the...

For backup, use the native SQL backup to get a backup to disk. NtBackup can take it to tape if you need it.

For reports, I'd use Reporting Services. Not sure...

First, should put this in the SQL 2000 forums (I've moved it).

Second, how did you move the dbs?

Third, is memory adjusted differently for SQL Server? same for data file layout...

RTM is the original release of 2000. That is build 194 (8.00.194). Service Pack 4 is 8.00.2039

What does @@version return? There are hotfixes post SP4, so your version might be...

Jeff brings up good points, though I'm not sure everyone feels that way. If you have experience and have gotten certified (MCDBA, MCITP), then you can show that the test...

I actually tend to agree with Sir Slicendice that it's hard to predict where you'll be, to what level you'll have success, what type of scalability is needed, etc. And...

Veritas centralizes many of your backups, but are you going to tape or disk with Veritas? I've had problems before with Veritas and Seagate's drivers in restoring databases, so be...