Mulali,

Also noticed the SQL for the INCLUDE doesn't compile - the [ needs to be a (.

Doug

Murali,

Just wondering why the INCLUDE data points all have DESC after them?

Doug

Atif,

My point was SUBSTRING is 1 based, not 0 based.

DECLARE

@String VARCHAR(50)

SET @String = 'Doug'

PRINT SUBSTRING( @String, 1, 3 )

PRINT SUBSTRING( @String, 0, 3 )

It won't error out - but it...

Atif,

That was because you used

substring(val,0,case when charindex(' ',val,0) = 0 then Len(val) else charindex(' ',val,0) + 1 end) as val

instead of

substring(val,1,case when charindex(' ',val,0) = 0 then Len(val) else charindex('...

Atif,

That was a nice hint on the (MAXRECURSION 500 ) - I didn't know that!

Best,

Doug

Atif,

It looks like any time you hit a line which has no spaces eg

Insert into @vTable Values (1,'Atif1')

Insert into @vTable Values (2,'Asif2')

You will display

Atif

Asif

How should we handle this?

TIA,

Doug

Hmm - this does not appear to list the same stored procedures I see with view dependencies?

And I guess you should truncate Tree between runs?

Doug

Paul,

I thought you needed SQL 2005 SP2 to get sp_refreshsqlmodule.

Doug

Jeff,

I tweaked it for SQL 2005 - and I was not a fan of <column> as <column> when nothing was done to the data. Plus I don't think the final...

Nick,

This seemed to work a little better for me:

CREATE TABLE #ExpressionToDataTypeAndNull

(

DATA_TYPEVARCHAR(15),

IS_NULLABLEVARCHAR(3) ,

CustomExpressionVARCHAR(128)

)

INSERT INTO #ExpressionToDataTypeAndNull( DATA_TYPE , IS_NULLABLE , CustomExpression )

VALUES ( 'varchar','YES','LTRIM(RTRIM(ISNULL("<column>",''''))) AS "<column>"')

INSERT INTO #ExpressionToDataTypeAndNull( DATA_TYPE , IS_NULLABLE ,...

Ryan,

In your article I see 'And, the script currently does handle foreign keys. ' Was there supposed to be a does not in there - I don't see the logic...

Steve,

Thanks for letting us know - I've had a great experience with my Toshiba Qosmio 17" with 7200 HD, but I'll hold off on the Windows 7 update until I...

Steve - has there been a resolution? I guess I shouldn't upgrade my Toshiba laptop to Windows 7 Ultimate then, eh?

Doug

Jacek,

I see that you SELECT the TraceID at the end of your Procedure - how do you turn the trace off with that technique? Does it run until C: is...

Gail,

Now I've got - only if the primary key is clustered is it present in all of the other keys.

I won't even tell you how many of the PKs here...