The function I use fn_hadr_group_is_primary from this post is a UDF (User Defined Function) that we create in the master database. The function gets an Availability Group name as an input parameter and returns a Boolean value indicating...
Run this command to see if any database on the SQL Server is using enterprise features
IF OBJECT_ID('tempdb.dbo.##enterprise_features') IS NOT NULL
DROP TABLE ##enterprise_features
CREATE TABLE ##enterprise_features
N' USE [?]
IF (SELECT COUNT(*) FROM sys.dm_db_persisted_sku_features) >0
INSERT INTO ##enterprise_features
If you got an error about compression, when trying to attach the database from an enterprise version to a standard version. You will have to attach the database to an enterprise database, and remove...
If you want to take a backup from Microsoft SQL Server management Studio, and get this error: Operating system error 5(error not found), then the problems is that the user running SQL Server services...