That looks ok to me... did you test it?

Did you mean create the indexes afterwards?

HTH.

If I remember correctly it has something to do with sessions timing out or something like this... maybe the webmaster of this site can shed some light on this.

Or even faster for the same result without a cursor :

SELECT 'EXECUTE sp_spaceused ''' + name + '''' FROM sysobjects WHERE xtype LIKE 'U' ORDER BY name

The advantage of...

k, that makes more sens .

Let me know if you need more help.

Did I post a solution of this thread???

I don't remember posting one... maybe you've read too many of my post lately Michael .

You don't need dynamic sql for this task, read up on the links we posted.

Well you could have a parameter name @NestedLevel as tinyint that defaults to 0, then on every recall of the proc, you increment that value. Then in the code...

Are you using a list of tables because the tables to transfer can change from one exec to another?

SELECT convert(varchar, DatePart(year, getdate()))

+ '-'

+ RIGHT('0' + convert(varchar(2), DatePart(month, getdate())), 2)

The database doesn't shrink when you delete data from it.

It happens only when you shrink it.

Look up DBCC SHRINKDATABASE in bol.

Depends of what you need... if you need to be able do resend the file as is once in a while. I would save the file on the hd...

if you need ^ as in 2^5 = 32

then look up the function power

select power(2,5) = 32