Board index MS SQL Server

Preventing Auto-update of Diagrams

Preventing Auto-update of Diagrams

Post by Jason Clar » Wed, 13 Oct 1999 04:00:00



Has anyone discovered a way to prevent the Database Diagram utility (in
Enterprise Mangler 7 or Vis. Studio 6) from auto-updating the diagram
when opened?  I would like to generate a schema definition script from
an existing Diagram, however, the source tables no longer exist.  When
I open the diagram, all non-existant tables disappear.

If this isn't possible, is the diagraming code exposed as a com
object?  The diagram data stored in dtproperties is stored in binary
(image) fields. Is it possible to access the diagraming object model to
de-serialize the model data and then generate the schema script?

Sent via Deja.com http://www.deja.com/
Before you buy.

 
 
 
Top

Preventing Auto-update of Diagrams

Post by Bob Pfeif » Wed, 13 Oct 1999 04:00:00


I don't think what you want to do is possible because the diagram is built
in part by querying the system tables of the database every time you open it
which is why the tables disappear if they don't acually exist.

--
Bob Pfeiff
MCDBA, MCSD, MCSE, MCT, SQL Server MVP
Practice Leader, Data Management
CIBER, Washington, DC

 
 
 
Top

1. Auto create/ auto update statistics, server 7.0

        I was inspired by another posting to this NG and checked the statistics
on a few tables in my DB. I am having problems for quite a long time
that SQL server sometimes chooses very stupid execution plans. I found
out that statistics on one of the very frequented tables was updated
last time at the end of March. But auto create/update statistics is
turned on. Is this normal? At what moments SQL server decides to update
the statistics? Should I rather schedule the job that would force an
update of the statistics at that moment?
        I could hardcode the execution plan into my SQL queries, but there are
those rare moments when SQL server comes up with really good plans (even
better than mine :) and I also do not fancy the idea of writing hints
into the code.

Ivan

2. ORA-01017 : invalid username/password : logon denied

3. Auto create, auto update stats:

4. DED and DataReport problem

5. Auto-update a number field w/ Auto-Enter Calculation

6. Connection between an Applet and Db ???

7. Preventing Auto dialup

8. URGENT! - RollBack a db Restore (an empy db on a full db!!)

9. Preventing Duplicates with Auto Serial #'s

10. How to prevent updates on foreign key default values

11. Preventing exclusive table lock with UPDATE

12. prevent updates/deletes on certain rows

13. Trigger prevents execution of update statement


All times are UTC
Board index