Have you examined / evaluated the use of Change Data Tracking. If not you may want to start here"

http://msdn.microsoft.com/en-us/library/bb933875(v=sql.105).aspx

This might be what you need.

EXECUTE sp_msforeachdb 'USE ?

IF DB_NAME() NOT IN(''master'',''msdb'',''tempdb'',''model'')

PRINT DB_NAME()'

Returns:

ReportServer

ReportServerTempDB

Test2008K

Test2012

SSISDB

Scores

TIPSNTRICKS

VaTax

TestPartition

AdventureWorks2012

QOD100

To learn more about this...

For my own learning experience, following Glenn Berry's blog posting here is a query I fashioned

DECLARE @LookF VARCHAR(9)

SET @LookF = 'procedure'

SELECT...

Here is an excellent source for information on Extended Properties by Glenn Berry

http://sqlserverperformance.wordpress.com/2011/01/10/fun-with-extended-properties-in-sql-server-2008/

which I believe will provide you with the information you requested.

Agree with the title of the QOD being missleading, and to make sure people do NOT conclude, incorrectly, how ISNUMERIC works may I suggest that every one read this...

+1

With over 2 hrs since you posted your request and no one has answered . might I suggest that you supply a sample (10 to 15 lines / addresses), the...

Items I believe you should consider. (Not knowing your exact operation).

1. I assume that you have NOT found any evidence/documentation left by your predecessor(s) as to why...

Thank you ..............

L' Eomot Inversé (2/27/2013)

---

Nice question, but two (very minor) niggles: (i) what was the last statement for? and (ii) why refer in the explanation to the output clause returning rows...

+1

bitbucket-25253 (2/25/2013)

---

Was wondering was it my link that failed to show the current QOD, so your note relieved...

Was wondering was it my link that failed to show the current QOD, so your note relieved me...

May I suggest as a first step in your upgrade task using the UPGRADE ADVISOR

http://msdn.microsoft.com/en-us/library/ms144256.aspx

2. If you have "extra" hardware available purchase a copy of the DEVELOPER EDITION of...

To help those who want to assist you ... can you post the table definitions, some sample data.

To do this quickly and easily please click on the first link in...