Or send him to Alaska :hehe:, let Bob deal with him.

When you click reply, there is a "Last 10 Posts" section below the edit box and reply options. It is closed by default, but you can open it to see...

Very interesting responses, and a lot of what I expected, though Phil's "promote him" caught me a little off guard. Phil, too much civil service work, perhaps?

Firing Evelyn isn't something...

I would run backups. Sooner or later a developer will break something and want to get the schema from yesterday.

Add the AD groups as logins, not the users, and assign permissions to the group.

Wow, that's surprising. Wonder if that happens in 2008. I'll have to check that.

I'd pass in the stuff you have, then maybe query information_schema.columns for the table name, get the columns. You can concatenate those in a query and then build a string...

I'd really love to hear what other people think is a "healthy" database. Hmm, maybe that would be a good Friday poll 😉

I think that health has to be measured...

With merge, it's publisher/subscriber, but not really. If one server goes down, the other one still has all the data it should (or that's committed). If you have a load...

Replication does not delete anything. It copies transactions from the publisher to the subscribers.

Unless you have merge setup, as mentioned above, it should not move data from the subscriber to...

You should remove the triggers as they're not helping. The people querying the variables will do as well against the table. You can query with a NOLOCK, and set a...

Nope, as explained above.

Please post what you've tried and some information about the tables.

You need a MAPI client (Outlook or equivalent)

http://www.sqlservercentral.com/articles/SQLMail/sqlmailusingpop3andsmtp/1577/

http://www.sqlservercentral.com/articles/Administering/sqlmailresources/605/

You can't survive a kill. If someone has authority to kill your process, SQL Server will do an orderly kill and roll back the work.