sql server programming: Objects related to DB -- sql server programming

Objects related to DB

Jaisol
6/12/2007 10:01:14 PM

sql server programming:

Hi Folks,

I suppose should exist a way to find the relationship between all external
objects (logins, dts, jobs, ...) with one database. I mean, the objects
related\attached with database.

That is because we have to take off several databases including objects
related.
Of course we have the respective documentation of the relationships but in
the past several engineers did mistakes and they missed the removement of
some object related....So, we got sql server with dirty objects.
The idea is to make a kind of script that checks all external objects
related to database before to delete it.

Thanks in advance.

Re: Objects related to DB

Greg O
6/13/2007 12:00:00 AM

HI ,
You could try a documentation tool like my SQL Scribe Documentation Builder.
There a 14 day trial . Document the entire system , the documentation
details logins, jobs and other server elements as well as the schema details
http://www.geckoware.com.au/Content.aspx?Doc_id=1001

-
Greg O
SQL Server Documentation the easy way
SQL 2000, SQL 2005 the best is back
http://www.geckoware.com.au/Content.aspx?Doc_id=1001
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server programming group.