Re: Documenting Tables and Queries


"Michael Cheng [MSFT]" <v-mingqc@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:6AULFbFqFHA.2928@xxxxxxxxxxxxxxxxxxxxxxxx
> Hi Hugh,
>
> Thanks for your post.
>
> From your descriptions, I understood you would like to know how to
> document
> the tables and queries in SQL Server. However, I would like to restate my
> understanding of "document". You want to get the struct of the tables, the
> codes of stored procedures, etc. If I have misunderstood your concern,
> please feel free to point it out.
>
> Based on my knowledge, SQL Server does not provide a stored procedure
> directly.

You guys should create a Data Dictionary segment for SQL Server and hide it
under Managment. DB2 has had this capapbility for a long time.

The drawing of a model in SS2000 is pretty lame.


.

Relevant Pages

  • Extreme performance issues (SQL Server 2000/ADO.NET/C#)
    ... This process runs very quickly if run through Query ... same exact stored procedures and views, run in the same exact order, through ... system that runs SQL Server (a 4-cpu Xeons system with 2gigs of physical ... When I execute these steps manually through query analyser,, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Querying on dates in dd/mm/yyyy hh/mm/ss format using Access2002 And SQL Server 7
    ... For parsing a string to a date/time, the 103 format doesn't limits the user ... > which is used as the row source for the results form). ... > other solutions assuming I have to use SQL Server 7? ... > I don't understand how I can use parameterized stored procedures to solve ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Help understanding Stored proc Level Secuirty?
    ... Jasper Smith (SQL Server MVP) ... I set permissions to my Stored Procedures, ... Access to stored procs fail ...
    (microsoft.public.sqlserver.security)
  • Re: Limiting views on data in a table
    ... returns the Windows login the user uses to connect to SQL Server. ... > The way I was implementing this was to use Windows Auth with a Windows ... > covered by which salespeople, ... > with it via the stored procedures. ...
    (microsoft.public.sqlserver.security)
  • Re: Scripting T-SQL CREATE Statements
    ... a backup of user-defined SQL Server objects. ... I am having a hard time finding the T-SQL functions and system stored procedures used to return the scripted ... like when you right-click an object and select Script Object to New Window as>> Create. ... I am trying to get it much like the instnwnd.sql file that comes with the .NET Framework SDK v1.1. ...
    (microsoft.public.sqlserver.programming)