Visual Studio 2005 - "Generate Create Script" for SQL 2000 stored procedure

Hot Topic

Error 0xc0202009 for importing access97 into sql
How can i generate a cube of XML Data
FMTONLY, LONG Running ?
Report performance issue - time in processing
connecting to database from script component
Adding Integration Services Node in Server Management Studio
Understanding code created by SSIS import/export Wizard
Error Reporting: Installation on SQL 2005 on x64
Documenting a reporting services site
Change query issues

SQL Server

Hundreds Of VIEWS
Cannot connect to Database in Server Management Studio
getting calendar control in sql reporting 2000
Newbie: sql 2005 encryption --- or where do I put that key?
Error when using VariableDispenser in a custom task.
What Maximum size of a parameter?
Enter date into Default Value or Binding
Internet integration
Management Studio slow?
Re Transactional Replication

Visual Studio 2005 - "Generate Create Script" for SQL 2000 stored procedure

Hello.

I have noticed that "Generate Create Script" feature changed in VS 2005 (compared to 2003).

In VS 2003 this feature was displaying dialog window where I could choose some options on what to include in script and where to place it.

In VS 2005 this feature just creates SQL script in "Create Scripts" folder, without any intermediate dialog, and now it uses sp_executesql procedure in a script.

Is there any way to change this behaviour (back to what it used to be in VS 2003)

Thanks

Iouri

 

Answer this question

Visual Studio 2005 - "Generate Create Script" for SQL 2000 stored procedure

  • JBond007

    I guess this is a wrong forum - I'll try to re-post this in "Visual Studio General".

    At this time I had no choise but to return to VS2003 for all database projects.

  • Hibri Marzook

    yes... I too would like to know the answer to this.
  • Visual Studio 2005 - "Generate Create Script" for SQL 2000 stored procedure
Answer this question