Generate script fails with SQL 2005 instances - by Assaf Fraenkel

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 307255 Comments
Status Closed Workarounds
Type Bug Repros 1
Opened 10/29/2007 1:34:23 AM
Access Restriction Public


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.
Sign in to post a comment.
Posted by Microsoft on 12/5/2007 at 5:27 AM
Hi Assaf,

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.

Posted by Ronald Ramirez on 11/21/2007 at 3:15 PM
This error continues with SQL Server Management Studio "Katmai" November CTP.
Posted by Microsoft on 10/29/2007 at 7:32 AM
Hello Assaf,

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.