peter.mauss (10/22/2014)
Sean Smith-776614 (10/22/2014)
peter.mauss (10/22/2014)
Yes, it displays theobject_name, the column_name for each hit. It would be cool if it would also Display
the Name of the Primary key column for the object and its value so a further query could be formed later on.
Something like "select [pkey_name],[column_name] from [object_name] where [pkey_name]=[pkey_value]"
Gotcha. The problem is that if it's a view or a table which is a heap then there's no PK. I usually just query the table in question against the column were the result was found using the value returned in the "column_data" column.
OK, i see. Tanks anyway for thist script..
No problem. Hope you find it handy.