Err >> SysProperties

Your english is fine, but you're design is wrong, by a lot and I don't have time/want to redo it and then rebuild the proc and then the calling code....

check out fn_listextendedproperty in BOLS.

They are kept in the syscomments table IIRC.

Farrell, I've shown this trick so many times I'm surprised you didn't pick it up yet >>>

IF Object_id('ListTableColumns') > 0

DROP FUNCTION ListTableColumns

GO

CREATE FUNCTION dbo.ListTableColumns (@TableID as int)

RETURNS varchar(8000)

AS

BEGIN

Declare @Items as...

"

Anyway, I have the creation scripts. But I'm not sure where to find the relations. The only way that the tables relate to each other is that they all...

Let me put it this way, if this had been designed correctly in the first place you wouldn't even have had to come here for help and you'd've been done...

No he needs to correct the design... this is just the beginning of his problems.

And yes farrell, this is one problem where no set solution exists

Why not just correct the design on the server one time and then just do a simple agregate query?

Send me the creation script from all the tables (including the relations) an dI'll build it.

Show him the execution plan of query analyser... can't get much better explanation than that.

How much free space do you have on the drive?

What does he want to see exactly?

It's 1024 :

CREATE TABLE test

( [1] int not null

)

DECLARE @I as int

DECLARE @Exec as varchar(8000)

PRINT '1'

set @I = 2

while @I < 3000

begin

SET @Exec = 'ALTER TABLE test ADD ['...

What happens if you rerun the statement in the same context but from query analyser (to get the actual server error).

Do not cross-post, we monitor all boards.

Finish the thread here : http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=212663