I am not a fan of open workspaces. When I am working, I do not want to be able to see anyone nor do I want to be seen. I...

Nice script and great tip on doing the left join to get table info.

SELECT

DISTINCT

TypeDescription,

SchemaName,

Name,

'...' + SUBSTRING(t.ObjectDefinition,

CHARINDEX(@chvStringToFind,

t.ObjectDefinition)

- @intNbCharToExtract,

LEN(@chvStringToFind)

+ ( @intNbCharToExtract * 2 )) + '...' AS Extract,

CreationDate,

ModificationDate

FROM (

SELECT DISTINCT

o.name AS Name,

SCHEMA_NAME...

Really enjoyed the article.

However... on the parameter split if parameter list happens to be exactually 8000 characters the substring in the select will fail. For example:

DECLARE @Parameter VARCHAR(8000) ...

We had to 1) make sure that there was not extra white space to the right of the report's columns and 2) on the File -> Report Properties -> Layout...

How do you "set it as a system object"?

I created a test stored procedure in master but I could not get it "see" the table of data in my calling...

We had to 1) make sure that there was not extra white space to the right of the report's columns and 2) on the File -> Report Properties -> Layout...