Tag Archives: Remote DBA

Bug Fix:Cannot find template file for the new query

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

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.

SELECT feature_name FROM sys.dm_db_persisted_sku_features ;
GO