| By product |
| Other |
|
Troubleshooting Troubleshooting and known issues with ApexSQL Tools How to solve missing schema issue in scripts for databases with SQL Server 2000 compatibility Applies to ApexSQL Script Summary This article describes how to create correct scripts with ApexSQL Script for objects that contain schemas other than dbo Symptoms As schemas are first introduced in SQL Server 2005, they are not scripted nor shown in Object filter for databases with SQL Server 2000 compatibility  Schemas also don’t show up as dependent objects in the Script wizard  Resolution To fix this problem, change the database compatibility level from SQL Server 2000 to SQL Server 2005 and up See also ALTER DATABASE Compatibility Level (Transact-SQL) About ApexSQL Script ApexSQL Script generates scripts for SQL Server database objects and data. Script SQL databases to source control, generate .NET executable and C# projects for deployment, and automate script generation using CLI. Last updated November 30, 2011 Labels: ApexSQL Script ... |
