Currently I am migrating a web app from a Sybase database to a MS SQL server
database. I have a admin section that allows administrators to print reports
on table structures, stored procedures, triggers, functions, indexes and
foreign keys. My problem is that I can't find any information on where in
the system tables Microsoft stores their function, trigger, and procedure
definitions. How are they stored within SQL Server? What system tables and
fields is this information located in: the table the trigger resides in, the
name of the trigger, and its definition (source code)?
Thanks,
Nicholas W. Watson
Assistant Web Developer
Concurrent Technologies Corporation
Email: [EMAIL PROTECTED]
Phone:(814) 269 - 2653
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
