Mike,

I'm confused, you asked for all databases, then you say a few. What exactly are you trying to do?

You can also grab the query from sp_helpdb and filter out system...

Lynn Pettis (3/16/2009)

---

But Tom Sawyer got other people to do his work for him WITHOUT insulting and offending people. Obviously, and I may be wrong here, foxjazz must not...

I think THE THREAD has no worries from this one.

Edited your code so it would better fit on the page.

A couple of things:

- sending mail in a trigger is a bad idea. It's part of the transaction, and if...

The punishment isn't for you, it's your co-workers. If you resign today, and they're not aware, then your work gets shuffled to them, starting today, because you resigned.

I understand the...

Julie,

I hate to ask.

Bob,

Excellent point. I believe all are edited now.

It's strange since the proc shows nvarchar. ntext conversions are what make this error.

Are you sure this is the correct definition? Did this come out of VCS or the server?

I believe the T-SQL endpoints are the listeners for normal SQL connections using TDS. Meaning every connection you make outside of an http/mirroring connection.

Hey, I think I worked there.

Bevan had the advice I followed and it worked well. Make a backup and then whack a table a developer needs if you have to...

Gift Peddie, apologies. I've edited the post.

There's no way to give you blanket recommendations. That's like asking which car should you choose for a race.

Do you have an existing system?

How many people will use the system?...

We don't allow the topics to be deleted. We prefer that you just put another post out there.

default fillfactor?

DBCC showcontig give you similar results? I almost suspect the DMV is not updating correctly after the rebuild.

Stranger. Is the body field ntext?