How do I find, alter, create, edit, etc. the stored procedures, triggers, and foreign keys on an MS SQL 2000 database? I'm trying to figure out how a given database maintains its referential integrity but I can't get behind the scenes on those things. I'm using SQL Server Enterprise Manager 8.0 to try to do this.
Thanks.
well for stored procedures, just right click on them and click properties
for the triggers, right click on the table, then go to all-tasks and click on manage triggers
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.