Generated script of a view from SQL Server 2005 Management Studio Express CTP with the 'Script for Server Version' will not run in
Script of a view generated with 'Script for Server Version' to 'SQL Server 2000' option using 'Generate Scripts...' from SQL Server 2005 Management Studio Express CTP will not run in SQL Server 2000. The script is generated with:
IF NOT EXISTS (SELECT * FROM sys.views WHERE objectid = OBJECTID(N'[dbo].[v_GroupMembers]'))
and results with "Invalid object name 'sys.views'." when executed in SQL 2000 Query Analyzer
Upvotes: 0<=-=Mar 24 2006 9:32AM=-=>
Thank you for your bug report. We will investigate this for a future service pack.<=-=Mar 28 2006 8:44AM=-=>
Quick update. We are placing this bug report under consideration for SP2.<=-=Apr 11 2006 12:04PM=-=>
Thank you for reporting this. This issue is fixed in the SP1 release of SQL Server Managment Studio Express.