Discovering SQL Server Object Dependencies

Apart from it being one of the features advertised by TOAD, where else
might I be able to find tools for displaying the dependencies between
objects. A node-based viewer (eg tree control) would be ideal. Does
any such tool exist?Hi Kofi
http://www.ag-software.com is one option.
Regards,
Greg Linwood
SQL Server MVP
"Kofi" <kofisarfo@.gmail.com> wrote in message
news:5c157557.0405130109.12ccc481@.posting.google.com...
> Apart from it being one of the features advertised by TOAD, where else
> might I be able to find tools for displaying the dependencies between
> objects. A node-based viewer (eg tree control) would be ideal. Does
> any such tool exist?

Discovering SQL Server Object Dependencies

Apart from it being one of the features advertised by TOAD, where else
might I be able to find tools for displaying the dependencies between
objects. A node-based viewer (eg tree control) would be ideal. Does
any such tool exist?
Hi Kofi
http://www.ag-software.com is one option.
Regards,
Greg Linwood
SQL Server MVP
"Kofi" <kofisarfo@.gmail.com> wrote in message
news:5c157557.0405130109.12ccc481@.posting.google.c om...
> Apart from it being one of the features advertised by TOAD, where else
> might I be able to find tools for displaying the dependencies between
> objects. A node-based viewer (eg tree control) would be ideal. Does
> any such tool exist?

Discovering SQL Server Object Dependencies

Apart from it being one of the features advertised by TOAD, where else
might I be able to find tools for displaying the dependencies between
objects. A node-based viewer (eg tree control) would be ideal. Does
any such tool exist?Hi Kofi
http://www.ag-software.com is one option.
Regards,
Greg Linwood
SQL Server MVP
"Kofi" <kofisarfo@.gmail.com> wrote in message
news:5c157557.0405130109.12ccc481@.posting.google.com...
> Apart from it being one of the features advertised by TOAD, where else
> might I be able to find tools for displaying the dependencies between
> objects. A node-based viewer (eg tree control) would be ideal. Does
> any such tool exist?

Disconnecting from engine does not closes database

I connect Managment Studio to MSDE 2000SP4.

Open database, open some object, then disconnect from engine (not simple collapse DB objects). In other programm try to drop database. Until you don't close MSSQL MStudio, database is in use.

In older version collapsing DB objects in tree closes DB.

Hi!

I don't have access to MS from 2000SP4, but I can tell you that MS in SQL2005 have Disconnect command in context menu of the server node. I think this is what you need.

|||Does not matter what engine you use. I wrote, that when I DISCONNECT (using this command from menu - this is one way) from engine, database is in use while MS running. So, MS does not disconnect from DB, only delete engine from list.|||Strange, when you Disconnect from server, it must lost connection and must release locks on any DB that was locked.|||

Please, read my first post and try to reproduce it. After disconnecting, try to drop database you used in SSMS. Open new query in SSMS and try. "Cannot drop..."

It's not strange, IT IS A BUG.

|||I have "Drop connections" checkbox for that case. It works in SQL2000 and I see it in SQL2005.|||

Where did you see this checkbox in SSMS?

May be this checkbox exists (I don't find it, but when I DISCONNECT from server all objects incl DB MUST be CLOSED.

I had no this problem in SQL2000 cause database was auto closed after collapsing it's objects in tree and when it wasn't selected in tree.

|||

I have it in window that appears after "Detach" command. Also I remember there was switch "Auto close" in SQL2000 Enterprise Manager (last tab in DB properties).

Perhabs this is MSDE behavior? I run on SQL Server and don't use MSDE for a long time.

|||

I don't need detach database.

Autoclose is a DB property (must NOT overrides by SSMS) and it's "TRUE". And Autoclose have another purpose - it closes DB after all users disconnects.

I had try with Autoclose = True and AC = false. Result: Cannot drop database.

There is no difference between MSSQL and MSDE for such things.

May be you'll try?

|||Please, describe steps to reproduce, I will try it.

Disaster Recovery

Whilst importing some procedures, I have left the
'Transfer Dependent Object' checked and the 'Drop Destination Objects'
result I have over-written certain tables
Can it be undone with the
transaction log and if so How ?
regards EarnieIf you have a backup of your target database, prior to the overwrite,
restore it. Or restore it with a different name, and copy the objects you
need.
In case of no backup, you can use a tool like Lumigent Log Explorer to undo
those changes.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Earnie" <Earnie@.discussions.microsoft.com> wrote in message
news:EADFAF0B-FD14-4937-9F6D-98DFAE297CFF@.microsoft.com...
Whilst importing some procedures, I have left the
'Transfer Dependent Object' checked and the 'Drop Destination Objects'
result I have over-written certain tables
Can it be undone with the
transaction log and if so How ?
regards Earnie|||Assuming you have valid database and log backups, use the STOPAT option
to restore the log to a point in time before the tables were droppped.
David Portas
SQL Server MVP
--

Disapearing Records

The first line in my global.asax is the creation of an ActiveX object that will hold a data connection to a SQL2000 Server database for the lifespan of an "Application" scope.

< OBJECT RUNAT="Server" SCOPE="Application" ID="Conn" name="Conn" PROGID="ADODB.Connection" VIEWASTEXT >< /OBJECT >

With that done, every time a new user invokes global.asax, a routine will verify rather it needs to open the connection or if the connection is already open:

If Conn.State <> adStateOpen Then
Conn.ConnectionTimeOut = 999999
Conn.ConnectionString = strConnStr
Conn.CursorLocation = adUseClient
Conn.Open
End If

The purpose of this is to avoid 400 simultaneous users from having to wait for their connections to estabilish communication to the server before initiating transaction.

Surprisingly enough, this works perfectly (for a massively shared, perpetual Connection object), except that once or twice a month, a record disapears from the main database and takes with it all relevant records from supporting tables.

Yes, it seems like a Forced Roolback is being issued...

Do you see Why?

Aleks,

I don't see anything that would cause that behavior based on the code you've provided.

Logging deletions through a trigger is one possible first step to figuring out when, where and why the behavior is occurring.

David Sceppa
Microsoft

Disable Report ToolTips

I am running my report in a web browser and have found that whenever i hover my mouse cursor over any object within the report at runtime a tooltip is displayed indicating its programatic name and type.

e.g. @.DeptName (String)

Is there anyway to disable this ? Obviously this info would mean nothing to users.

Thanks.Found It.

To disable the tool tips for an object:

a. Open the report in the Crystal Reports designer.
b. Right-click an object and select 'Format' from the pop-up menu.
c. Go to the 'Common' tab and click the 'X+2' button beside 'Tool Tip Text'.
d. The formula editor appears. Type 'chr(9)' and save the formula and report.

Its a right pain to have to do this for every object but it works.