Monday, February 27, 2017
Wednesday, February 22, 2017
How to find database is in single user mode
SELECT * FROM sys.databases where user_access_desc='SINGLE_USER'
Monday, February 20, 2017
Friday, February 17, 2017
How to give create database permission to a user
USE master;
GRANT CREATE ANY DATABASE TO LoginName;
Saturday, February 11, 2017
SSISDB: PlEASE Create master key in database
USE [SSISDB]
OPEN master Key decryption by password = 'A006S@s2$'
ALTER MASTER KEY ADD ENCRYPTION BY SERVICE MASTER KEY
ALTER MASTER KEY ADD ENCRYPTION BY SERVICE MASTER KEY
Thursday, February 9, 2017
Subscribe to:
Comments (Atom)