"Anyone up for my challenge yet?"...

Remi - you should start a new post with your challenge...you have a limited audience here...

??? what're the cons of sp_depends ???

"Anyone took up my challenge yet?"....

I'm in my QA doing so right now....Oops..didn't mean to let that slip!<;-)

Bill - now all you have to do now is compare the cost...

search this site for info on the topic!

Here're a couple of links discussing this...

http://www.sqlservercentral.com/forums/userinfo.aspx?id=132447

http://www.sqlservercentral.com/forums/userinfo.aspx?id=153059

"....the original poster will appreciate any thoughts you have!"...

Thoughts are that some sort of check/filter needs to be placed on this automated response...<;-)

General opinions...

"I'm thinking about not returning all joined tables as we have some procedures that join probably 10 to 15 tables, and that's going to make the documentation less readable..."

I...

Here's something my search threw up...

"SqlXml restricts the input URL size to 1K for security reasons.A similar

restriction (The restriction could be 4K, I don't remember in detail) was

also introduced in...

Can you remove the PK constraint before moving data ?! Though you'll have some analysis to do on that table once the data is moved to identify a PK...maybe there're...

Bill - until you find the perfect documenting tool...you could start by looping through all the procedures in each of your databases with a

"SELECT name FROM sysobjects where xtype...

Maintain a balance, don't get too caught up in planning for the future nor just enjoying the present, but balance your life....

Easier said than done Steve, but we all know...

Jeff - took some courage to share that - thanks and do well! Funnily enough I'm heading to Nashville tomorrow (another story for another time)...

Re: "neither one of them can...

Alpoor...

Try this: SELECT ISNULL(CAST(datefiled AS varchar(15)), 'Not Assigned')

SELECT ISNULL(CONVERT(varchar, n.TestDateTime),getdate())...

substitute getdate() with whatever you want it to return if value is NULL.

You can do this with the data export wizard in enterprise manager!

Are you the owner of all the objects in the diagram ?! It could be a permissions/access issue!