Yes, you cannot drop PK if table is involved in replication, drop article from publisher make changes and then add back article to publisher, don't forget to re initialize subscriber...

It doesn't matter, it is your call!

EnjoY!

You said Broken Replication, what is the error message? Check the constarints too.

EnjoY!

If i understood correct, you are trying to alter a table which is involved in replication. You cannot alter table or do schema changes if the schema changes option is...

Yes, it will fire an alert if latency is more than 10 secs. That is what you set up correct?

EnjoY!

What about other SQL instances? Don't you have Defrag maintenance job on other SQL servers? Use same script it doesn't matter, we use same script for all SQL servers including...

Yes check fragmentation and when stats were updated, how much memory this server has?

EnjoY!

Indianrock (2/24/2010)

---

For many years various people would copy a backup of a production database to a development server for restore/testing. For many reasons there is talk of either ending...

Steve is right, Check this out for steps.

http://social.msdn.microsoft.com/forums/en-US/sqldatabaseengine/thread/46e3ecf9-6eab-4aa0-9453-11e7269efb6e/

EnjoY!

Unfortunately i don't think it is possible, Because when some delete job then an entry is also removed form sysjobs...

I would say one domain account for all SQL Server Services, But don't login using this account for day to day activities use, Use this account only if you need...

Apologies, I missed that point.

EnjoY!

When I'm ready to restore the most recent version should I just do a restore, letting that overrite everything, or am I better of explicitly deleting the DB and...

From BOL

NORECOVERY specifies that roll back not occur. This allows roll forward to continue with the next statement in the sequence.

In this case, the restore sequence can restore other backups...

Check...