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

No, the easiest way is to create a split function that can return the list of codes. Then it can be reused everywhere else in the application... Also...

I'm not sure it's the best place to speak about hacking...

1 min to update 1m rows doesn't seem like a long time to me but I've never really worked with tables that big. Maybe you could merge some of...