sql server programming: Database/Application Documentation -- sql server programming

Database/Application Documentation

Chad
9/30/2005 11:47:54 PM

sql server programming:

Just general thoughts...

It seems to me that there is a lack of compile time binding between a .NET
application and the a SQL server database.

Can someone suggest the best way to do things like
-identify stored procedures that are no longer being used by an application
-genrerate a call tree of .NET classes and modules which flows all the way
to database SPs.

Is using strongly typed classes, something i am not very familiar with,
helpful?

I've looked at Project Anayzer by Avisio and the output is confusing.

Does Rational have something to help document an application that spans
tiers by analyzing the code?
Is the output quality or quantity?

RE: Database/Application Documentation

SQL
10/1/2005 3:02:01 AM

You could run a trace on the server and analyze the output for missing
procedures

http://sqlservercode.blogspot.com/

[quoted text, click to view]

Re: Database/Application Documentation

Mary Chipman [MSFT]
10/3/2005 8:11:18 PM

That is correct. When you compile a .NET application, it only compiles
the managed code. SQL Server objects are considered to be external
resources, and are not compiled or checked in any way. Only the
provider syntax is checked, embedded strings, parameters and SQL
statements are not. There are other Microsoft partners who provide
third-party tools, which you may like better than the one you tried. I
used FMS analyzer a long time ago, which I liked at the time, but I've
not kept up with the available tools. See
http://www.microsoft.com/sql/partners/dbtools.asp for a complete list.

--Mary

On Fri, 30 Sep 2005 23:47:54 -0400, "Chad"
[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.