If replication is there, better to avoid detach\attach

Thanks Steve, nice easy one.

Thank you Steve, the link you shared was really informative.

Saga... (9/8/2011)

---

Hi I am planning to give this exam for SQL 2008R2 Installation & Maintenance.

Can anybody give me some online tests link... so I can match upto the time &...

Nice simple article. We could also get this information from SQL Server error log.

This question is good for interviews :).

Toreador (9/6/2011)

---

"If you got this wrong, it means you are new to SQL Server as the people other than James Franco and Hugh Hefner are some of the luminaries in...

Thanks for the question, easy one.

Excellent article Gail. I liked all the myths and misconceptions you mentioned escpecially this one.

Myth 4: You have to switch from simple recovery to bulk-logged recovery model to get minimally...

Good question. Thanks.

Can you try creating an output file for the job step and then run the job. If the job fails we would be able to get some more information from...

Thanks for the question.

When you right click on the replication folder in SSMS, you get the option to 'Disable publishing and distribution', you need to use this for disabling instead of directly deleting...

Please don't try this on production, your replication...

eric_van_uden (8/23/2011)

---

I executed the code against a 2008 server and a 2005 server and got this message both times:

[font="Courier New"]Msg 911, Level 16, State 1, Line 1

Database 'test2' does not...