Quite a neat question. If people read the title (or even just the tag) the won't be fooled by the acronym. I would have thought it would be...

Not fair Gail, surely on topic comments are not allowed in the thread. 🙂

A finer display of ignorance and misunderstanding is hard to imagine. I can...

Ouch! I must get...

While I agree with most...

Ed Wagner (9/11/2014)

---

Heh - We just got our driveway paved with asphalt on Tuesday (the day before the rain) and our dog doesn't know what to do any more. ...

Although the first two chunks indicate clearly that NULL is ordered low by ORDER BY, they don't indicate anything else.

The "spanners" added...

I think you will need to give your user select access on sys.all_objects and deny select access on sys.syscolumns and sys.sql_modules for the user to get SP names but not...

Eirikur Eiriksson (9/9/2014)

---

Alan.B (9/9/2014)

---

IF @user > '' --This checks for not null and not empty

Cool. I never knew you could do that, very interesting :laugh:

Edit: sql code tag messed up...

Luis Cazares (9/10/2014)

---

Eugene Elutin (9/10/2014)

---

Alan.B (9/9/2014)

---

IF @user > '' --This checks for not null and not empty

Cool. I never knew you could do that, very interesting :laugh:

Edit: sql code tag...

I find that if I stick <shift in>, <shift out>, and <data link escape> into a string...

More to the point, if the data...

djj (9/11/2014)

---

BWFC (9/11/2014)

---

SQLRNNR (9/10/2014)

---

Sean Lange (9/10/2014)

---

SQLRNNR (9/10/2014)

---

Is that old age or...

Iulian -207023 (9/11/2014)

---

What happens if while the pages are deallocated , another task / process / txn ( or something ) allocates that space for other purposes...

Koen Verbeeck (9/11/2014)

---

Vimal Lohani (9/11/2014)

---

TRUNCATE TABLE removes the data by deallocating the data pages used to store the table data and records only the page deallocations in the transaction log.

this...

Iulian -207023 (9/11/2014)

---

Although I answered more based on the instinct that the data is safely recovered after a rollback. I am still wandering why have I thought that TRUNCATE would...