No, you do not need to restart SQL Server.

The first thing you need to do when you change your database from SIMPLE recovery model to BULK LOGGED or FULL recovery...

Trey Staker (7/5/2011)

---

Craig Farrell (7/5/2011)

---

Stefan Krzywicki (7/5/2011)

---

Brandie Tarvin (7/5/2011)

---

SQLkiwi (7/5/2011)

---

Just so we're all clear on this, I'm interested in how you justify things like attending the summit to the person...

SQLkiwi (5/15/2010)

---

If the source table is large and there are many duplicates, deleting all the duplicates in one go is likely to be slow and use a great deal of...

If it matters, BS in...

Syed Jahanzaib Bin hassan (7/4/2011)

---

Again, all we are stating is that the advice you provided was wrong. Your code used depreciated features that may not work in future versions of...

Would help if you post the error message you get in production.

another non professional person ,I didnt say anything about anyone solution here because every...

Jeff Moden (7/2/2011)

---

YSLGuru (7/1/2011)

---

Jeff Moden (7/1/2011)

---

Craig Farrell (6/30/2011)

---

Jeff Moden (6/30/2011)

---

I don't know if it'll make people feel any better about the "Quirky Update" but Tom Thompson and Paul White added...

Ninja's_RGR'us (7/2/2011)

---

Lynn Pettis (7/2/2011)

---

Could be me, but I think this was a bit too much. We really should not attach the messenger...

Could be me, but I think this was a bit too much. We really should not attach the messenger but the message.

I may be wrong but looking at the code I have to ask, is this PL/SQL?

If I did, it probably wouldn't work on your system.

Please read the first article I reference below in my signature block regarding...

alhayalara (7/2/2011)

---

Its written to meet the possibility of having several inserts made to temptable. Thus the ID is saved so that when propagation is done the record with the ID...

Syed Jahanzaib Bin hassan (7/1/2011)

---

@opc.three

thanks and I appreciate

mentally disorder

Yes I absolutely did read the entire paragraph. Are you telling me that when DBAs write scripts...

Different applications, different screens in the same application, I don't know in your particular case. You need to do some data analysis of your data to figure out how...