P.S. Replace all of the smileys byt a closing parenthesis " ) " when pasting the code.

Here's a script I use to do a similar task, I'm not doing any updates, but the selects are quite easy to follow.

Let me know if you have any questions.

...

Yes there is, can you tell us the do something so we can figure it all out?

In the mean time you can check out sp_msforeachtable and sp_msforeachdb

Very quick example :...

Holly shit... is the only way to describe those results!!!

********************************************************************************

Found, no index

********************************************************************************

===== Far Right =====

--------------CharIndex

SQL Server Execution Times:

CPU time = 24187 ms, elapsed time = 24650...

shmuel (9/12/2008)

---

sorry, she gets paid to make the rules. I get paid to be her loyal servant.

Still, why should an sp_inner call from within sp_outer run slower and have a...

How are you calling the sps?

Are the settings the same on all connections (if they are different)?

Are you qualifying the names?

Are you using the same case for all characters?

Just go from there... don't know how you need to use it, so here it goes :

--Make sure Saturday is the 7th day of the week on your server...

I always love to see that from a boss, don't post the sp code, don't post the DDL, but ya sure post the actual full executions plans... they won't be...

Good points... another questions to check with that varchar(2000) is how much of that is actually used. I've seen description fields as varchar(8000) with never more than 25 characters...

Thanx for all the help... there's so much data on the subject, and no simple answer besides asking them... now I know what I'll be talking about and what to...

Just read this, that is your solution (2nd code snippet)

Yes, screw them. Select the data as multiple rows. Present into a single text object... or use a concatenation on the server to present the data (straight in...

I taught we couldn't have on cascade delete on when the reference is on the same table!!!

Finish the logic, we'll kock it out for you ;).

No offense, but that's just the way it felt to me... and we get that all the time here.

Next time you might want to check the Books Online (BOL for...