It looks OK, however your design would allow multiple projects per job. If that's not the case, it doesn't make a lot of sense to build the separate table unless...

The installed might need to do something, create db, add users, etc. Likely it doesn't need sysadmin, but it's probably not worth figuring it out, unless you want to document...

#s 1 and 2 are why I also recommend you touch your resume every quarter.

And what worries me about #2 is that people will just accept the answer and run things, not bothering to check themselves if they can't check first.

I'll admit there are...

Lynn is correct. You'll be fine, and I wouldn't stop any full or diff backups due to log shipping.

There are a few issues with snapshots.

they don't stay up to date. They are a point in time. To update it, you need to either drop the snapshot and recreate...

You can't selectively restore logs, but you can continue to restore filegroups (new FG backups) over time.

Just a note, and not to impact performance any more, but R0 is asking for trouble. One failure and everything is lost. You might have to reinitialize the subscribers and...

I assume you mean database and not table. A table uses the space allocated to it, +/- an extent. A database should always have reserved space. The table might...

That works if the logins are new. If there is an existing login, you would need to use sp_change_users_login. As to auto or one, it depends. Auto should fix all...

I'd agree with Seth. You don't need an identity, but you need a unique way to identify rows, otherwise you're likely have have similar issues in the future.

I sometimes think people are trying hard to build a reputation by answering, and don't want to read. They want to just throw something out there.

Thanks!

I'm not sure WMI is easier, or even more foolproof. We had issues in W2K with the service. Not sure about W2K3 or @2k8

However, I agree that posting the...

IAN has stated it well, but I tend to like combining apps on one server. Hate instances because of the memory issues, but I do like sharing stuff.

I'd dig in...