Search

Monday, January 20, 2014

DMV to check SQL Server edition specific feature

There are some features of Server Server Database Engine which change the way that Database Engine stored information in Database Files. These features are restricted to specific edition of SQL Server. If a database is containing these feature than that database cannot be moved to some other edition of SQL Server (Which does not contain that Feature).You can use below DMV to find all edition specific features enabled in the current database. 

SELECT DB_NAME() AS [Database Name], FEATURE_NAME AS [Feature] FROM SYS.DM_DB_PERSISTED_SKU_FEATURES

This DMV can check below four feature: 
  • Change Data Capture 
  • Data Compression
  • Transparent Data Encryption
  • Partitioning


Monday, January 13, 2014

Error showing while opening SSMS 2012, Value cannot be null

Today when I was opening SQL Server Management studio in SQL Server 2012, I got below error:

Value cannot be null. Parameter name: viewInfo (Microsoft.SqlServer.Management.SqlStudio.Explorer)

To solve above problem I done below steps:


1. Open Windows Explorer, paste the %USERPROFILE% in the navigation bar,
or go to C drive --> Users --> Your user ID.

2. Go to the following directory My Documents\SQL Server

Management Studio\Settings and delete all the files exists there.

3. Restart the SQL Server management Studio.


And problem is solved.

Monday, January 6, 2014

Property Owner is not available for Database 'AdventureWorks'.

When I try to check the properties of the AdventureWorks database from SSMS. I couldn't able to see the properties of the database and i got below error.

Property Owner is not available for Database 'AdventureWorks'. This property may not exist for this object, or may not be retrievable due to insufficient access rights.  (Microsoft.SqlServer.Smo)

To solve above error I had changed the database owner using below stored procedure.

USE AdventureWorks
GO
EXEC sp_changedbowner 'sa'
GO