Set your Query Analyzer connection to use the "foobar" database and run the same script. Both WT2 and WT3, members of the SQL Server Tools family of...
Assuming your dependency records are intact this quick-and-dirty query should work... SELECT T.name FROM sysobjects AS T LEFT JOIN...
If the needs are simplistic then a simple query is all that's necessary. If the needs are more demanding then a robust utility can be very helpful....
quote:Ok, I just installed your trial software to audit, it just generated a simple report on all my objects in the DB, oh and dependancies, am I...
If you would like to go beyond simple query results and generate a detailed reference, consider WT3 - one of the SQL Server Tools applications......
There is a new version of a free package of T-SQL routines and documentation. This version includes several new routines and other improvements. It...
Thanks for the comments! I have a library of common Transact-SQL routines that I believe is organized and debugged. It includes error-trapping and...
For further discussion follow this link... http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=28429
Would a typical SQL Server DBA or database developer ever be willing to buy a coherent and comprehensive package of advanced T-SQL routines? There...
This link (which is case-sensitive) http://www.wingenious.com/dbaction/DBFree.zip leads to a package of free SQL Server resources. The package...
For those who may be interested... With the help of Microsoft technical support, I think we have this problem resolved. I'm not an expert on...
Thanks for the reply! The account in question has two options selected, the user can not change the password and the password never expires. The...
On three different SQL Server 2000 Standard (SP3) systems we periodically have to reset the proxy account for SQL Agent (sometimes daily). After we...
Separate names with a comma.
