Error
Cannot find template file for the new query ('C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\SqlWorkbenchProjectItems\SQL\SQLFile.sql')
Solution:
Step 1: Go to C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\SqlWorkbenchProjectItems\SQL\
Step 2: Create .SQL File named SQLFile.SQL
Showing posts with label Remote DBA. Show all posts
Showing posts with label Remote DBA. Show all posts
Sunday, May 1, 2011
Tuesday, April 26, 2011
DMV to identify database features restricted to specific edition of SQL Server 2008
If you have configured the user database any of below feature of SQL Server 2008 Enterprise Edition
-- Data Compression
-- Partitioning
-- Transparent Data Encryption
-- Change Data Capture
Above list of features will internally change the way the database engine stores information within the database files. If a database configured to use any of the above features which are specifically designed to be used in Enterprise Edition of SQL Server 2008, it cannot be moved to other editions of SQL Server 2008.
You can check the above feature by querying the sys.dm_db_persisted_sku_features DMV against database.
[sourcecode language="sql"]
SELECT feature_name FROM sys.dm_db_persisted_sku_features ;
GO[/sourcecode]
-- Data Compression
-- Partitioning
-- Transparent Data Encryption
-- Change Data Capture
Above list of features will internally change the way the database engine stores information within the database files. If a database configured to use any of the above features which are specifically designed to be used in Enterprise Edition of SQL Server 2008, it cannot be moved to other editions of SQL Server 2008.
You can check the above feature by querying the sys.dm_db_persisted_sku_features DMV against database.
[sourcecode language="sql"]
SELECT feature_name FROM sys.dm_db_persisted_sku_features ;
GO[/sourcecode]
Subscribe to:
Posts (Atom)