I'd check the default trace, I'm sure it's a logged event.

From there on out it's a matter of checking regularly...

Having issues with users creating dbs without your knowledge?

I'm not sure I understand the real issue with that error (Gail's the real expert on any corrution around here).

To my little self it just seems that there's...

If you use SET NOCOUNT ON; at the top of the query the n rows affected message should be gone.

I'm not sure I understand the rest of the request, can...

+1 for everything Phil said.

When I first read the topic title I was under the impression of SSRS export to excel.

The good news is that Denali "should" be compatible with...

Happy to almost have helped :hehe:.

Let me point out something very important... I've never tuned a server with anywhere near that much traffic.

That being said here are a few ideas :

It's a...

Don't know what to tell you. I've definitely done this in the past and I was getting ever increasing counts in the table. I don't know what could...

What is it waiting on? (sp_WhoIsActive)

You'll see it as it inserts.

Not 100% sure you'll get any numbers like 16472 instead of multiples of 1000. But that might be a fun test to setup.

Care to...

Craig Farrell (7/26/2011)

---

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

---

You can['t] use truncate on a table with FK on it. So you'd have to use delete + reseed on all tables. That would get...

Ok I was late moving to sql 2k5, but I'm...

WHERE i.is_unique = 0 AND i.type_desc NOT IN ('HEAP', 'CLUSTERED')

If I were you I'd read up on those tables in BOL. There's a ton of info in the new...

You need to filter all the unique constraints from that report. The PK is there for a reason. It is also index to speed up operations, not the...

Nope. First time I see such a requirement. ...

Gail asked to run this on sql 2000. This seems to be sql 2K5.

How long has the DB been in production on sql 2K5?