SQL Server Home
Generate script fails with SQL 2005 instances
10/29/2007 1:34:23 AM
User(s) can reproduce this bug
I am using the pre-CTP5 version - build 10.0.1075.6
When I'm trying to manage a SQL 2005 instance, I can't generate script from SMMS for existing index or table. It works ok with SQL2008 databases.
SQL Server 2008 July CTP
Tools (SSMS, Agent, Profiler, etc.)
Win2003 Enterprise Server (SP1)
Operating System Language
Steps to Reproduce
Right click on existing table or index on SQL2005 instance and try to generate script to new SSMS windoww
New window with the script
to post a comment.
Please enter a comment.
on 12/5/2007 at 5:27 AM
Currently you can try scripting by changing the "Script for server version" scripting option in Object Explorer to "SQL Server 2005".
This issue is resolved in the latest version. We will keep track of it.
on 11/21/2007 at 3:15 PM
This error continues with SQL Server Management Studio "Katmai" November CTP.
on 10/29/2007 at 7:32 AM
Thank you for reporting this problem.
We understand that script generation on a table/index is a basic operation and can cause great annoyance if it fails. We will check for this problem in SQL Server 2005 as well the recent CTP releases and get back to you.
Do watch out this space for details.
to post a workaround.
Please enter a workaround.
on 11/21/2007 at 3:37 PM
the option must be set to the "SQL Server 2005" value,
Ronald Ramirez Moran (aka DlanorOk,
on 11/21/2007 at 3:36 PM
To enable the support for scripting SQL Server 2005 databases you need to set to "True" the "Script for Server version" option, available at [Tools] > [Options] >> [SQL server Object Explorer] > [Scripting]
Ronald Ramirez Moran (aka DlanorOk),
© 2014 Microsoft