GilaMonster (5/2/2011)

---

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

---

More to the point is the endless list of certifs in his signature. At some point if you search for a cert code, his name will be...

asterman_3 (5/2/2011)

---

I am working with SQL Audit Logs. I am auditing any update, delete, insert statement taken into specific table.

So, my goal is to extract column names that has been...

+1

That doesn't mean it's slow.

How many rows in each tables touched by the...

How to you implement that with a DB with 30 000 tables?

Makes more sens to have a DDL trigger which stops all truncates. Then again permissions / security...

What's the big goal of the project here? Parsing all that is not going to be easy. Especially across an entire application.

Ya it's a naked link but it still has decent weight in the google algorithm, especially with 100s to 1000s of posts across the top 3-6 db forums. That's...

Stefan Krzywicki (5/2/2011)

---

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

---

Same here... hence #1 for...

Naomi N (5/2/2011)

---

In other words, there is no way to prevent TRUNCATE by a trigger, right? The only way will be in setting up permissions.

I'd say, it seems like we...

A couple ideas for further googlers :

Setup and use a dev server.

use implicit transactions and also always type ROLLBACK as the first thing in your code (at the bottom...

Same here... hence #1 for amount of wrong...

sachnam (5/2/2011)

---

Syed Jahanzaib Bin hassan (5/2/2011)

---

this creates a database 100 MB in size. However, the backup file is only 2MB in size, since the database contains only metadata at this...

Grant Fritchey (5/2/2011)

---

Steve Jones - SSC Editor (5/1/2011)

---

So I've gotten more than a few complaints about posts like this from Syed Jahanzaib Bin hassan.

http://www.sqlservercentral.com/Forums/Topic1101142-146-1.aspx#bm1101269

I can certainly appreciate he/she is annoying,...

Did you READ THE SCRIPT? There's no compression in it.

For the 10TH TIME already, stop blabbering answers just for the sake of getting points and links to your useless...

Ray Mond (5/2/2011)

---

As stated by the other guys, a backup file only contains data pages that are actually used. If you run the following script:

CREATE DATABASE sizetest ON PRIMARY(NAME...