Thank you for the explanation Paul....MUCH appreciated!!!

this one looks interesting@!! I will dig in here and see what is under the covers so I understand it!! Thank you!!!!:-P

Yeah! Again, Thank you!!!

can you give me more details on your suggestion please???? thank you!!

this works for me and thank you again!!

SWEET!! Thank you!!

Steve....just to clarify.....(LOL)

when you query the sys.sysdatabases view, you get dbid as a column. the sp_msforeachdb proc querys this view. my code says 'if DB_ID >4' ...

got it! Thank you!!!

Steve, how does one see the code for sp_MSForeachdb stored proc????? in my code I have..."where db_ID >4......."" which takes care of 1-4 being the system tables. I...

Way cool Steve!!!

OK, I took out the @sql stuff and just put the create table code in as the parameter and it worked. I guess it makes...

I got the idea to do it this way from the following code:

DECLARE @sql VARCHAR(1000)

SET @sql = 'SELECT ''?'', so.name, MAX(si.rows)

FROM sysobjects so

JOIN sysindexes si on...

aaahhh.....good point!! Thank you!!! Numeric it is!!

expand away....grasshopper!!

Thank you all for the ideas, I am trying them all!!!!!!!!!!

thank you all!!!! Trying all ideas!!