Before you perform as ALZDBA Posted Today @ 2:52 PM. You might want to delete the dependent tables before the Independent tables ... to list the dependent tables execute...

The people here are all volunteers and are more than willing to provide a tested answer to your question, but to do so they need you to help them.

Your question...

With Jeff Moden Posted Today @ 10:58 PM

Jeff are you pulling another 40+ hour week?

Relax man, do you rXmas shoping.

anolan

In addition to prior forum replies, may I also refer you to the following Blog post:

http://adventuresinsql.com/2010/09/how-is-fill-factor-impacting-my-indexes/

It contains sample code that returns a large amount of index data, and ...

To deternine the extent of index fragmentation you may want to execute some code like: (this found in a SSC posting so long ago that I can not remember the...

Try this

Select * From Information_Schema.Columns

or get what you appear to desire using:

Select Table_Schema,Table_Name,Column_Name,Data_type,Character_Maximum_Length

From Information_Schema.Columns

Have you considered running the 50,000/5,000 or so rows within a BEGIN TRANSACTION and COMMIT TRANSACTION?

What is your backup mode/schedule for this database?

For those who may have missed it.

Jeff Moden waxes poetic

In days of old,

When Knights were bold,

And Windowing was not invented,

He wrapped his code

In a familiar mode

And RBAR was prevented....

It would assist those who would like to assist you if you would post the table definition, some sampe data and desired results from that sample data. Refer to...

See my other post, it is you who gave me the idea for the question, and I thank you for that, and...

By including this in my justification of the correct answer:

I had hoped to...

stan-617410

Have to attend a meeting and must leave in a few minutes... will attempt to get back to assisting you .. but it might be tomorrow ...

Give serious thoughts to...

1. Altered your table LoadTbls to include a unique value, in this case an identity column, so that I could pass in the specific load I required,

2. Inserted...

You gave us a procedure, now what is the problem ? ?

Posting here on a forum .. has been going s l o w very s l o w ,

but eventually it...