Posted by jsfromynr on 05/17/06 17:21

Hi db55,

I think this will help you

Create Table TableNameRow
(
TableName varchar(100) Not Null,
recs int
)
Go
Exec sp_msforeachtable 'Insert into TableNameRow Select ''?'',count(1)
from ?'
Go
Select * from TableNameRow

With Warm regards
Jatinder Singh
http://jatindersingh.blogspot.com

• Next in forum: alter table nocheck constraint still some dependencies
• Prev in forum: Re: the datatype
• Thread view: Re: Create Status Table

[Reply to this message]