need brief answers

what are pseudo tables
how queries run by MSDE
how stored procedures run in backend by MSDE
how triggers run by MSDE
where triggers and stored proc stored in MSDE and in which form
where logs are being maintained of transactions/DML statement by default

what are pseudo tables - Never heard of them, you may mean Derived Tables (A table created in a query that lives only during that query), or Views (a sql statement describing a virtual table)

how queries run by MSDE - You have to use a tool, like Query Analyzer or a client application to send queies to the MSDE engine

how stored procedures run in backend by MSDE - Same as above

how triggers run by MSDE - Triggers are run automatically by the database engine when the proper event happens to a table with a trigger on it.

where triggers and stored proc stored in MSDE and in which form - They are stored in system tables, you access them to create and edit them through Enterprise Manager or writing a DDL query in Query Analyzer

where logs are being maintained of transactions/DML statement by default - The log file(s) are where ever you tell the database to put them when you create a database. By default I think they are in the <SQl Server install location>\Data folder.

|||I sometimes use the term "pseudo table" to describe the INSERTED and DELETED logical tables that are available in triggers. I am not sure if that is what applies here or not.|||ah, good point. I have never heard that term though, always heard them referred to as virtual tables.

Need 2005 Wizard to create INSERT and UPDATE stored procedures.

In SQL Server 2000, the database wizard would create insert and update stored procedures for all of my tables.

I have a large SQL Server 2005 database with many tables and columns. I need wizard support to create insert and update stored procedures for them. Typing them all in manually is out of the question.

The 2005 Generate SQL Server Scripts Wizard does not create stored procuedure scripts. It only scripts tables.

Is there some other way to make Management Studio create stored procedure scripts the way Enterprise Manager did?

Are there any plans to restore this critical functionality that was left out of SQL Server 2005 and the service pack?

Do you know of any utilities that can fill this gap?

Any help would be appreciated.

Please file a suggestion for this functionality on http://connect.microsoft.com/sqlserver. We use customer feedback to prioritize future work. Suggestions and defect reports filed on the Connect site are placed directly into our internal issue tracking system so the appropriate team will see your request.

I don't think there is an easy way to do what you want using built-in functionality in SSMS. If you are comfortable writing .NET code, you could write a small Visual Basic or C# application using the SQL Management Objects to iterate through all your tables and generate the stored procedure code you need.

Thanks,
Steve