I'm just trying to save you some time.

I don't know for sure but I'd bet a good some of cold hard cash that it took a team of 10 of...

That happens to me a lot when using temp tables.

I use COLLATE DATABASE_DEFAULT to get out of the error and use the same collation for the tempdb object as the...

The "simple" way is to create groups and assign permissions to those groups. Then add the users to that group to get all the permissions.

That's the easy part. ...

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...