SQL Server - Server Roles from Quackit.com
Subscribe to:
Post Comments (Atom)
Check if column exists or not in the SQL server
--method 1 IF EXISTS(SELECT 1 FROM sys.columns with (nolock) WHERE Name = N'LoginName' AND Object_ID = Objec...
-
-- Check the major product version to see if it is SQL Server 2016 CTP 2 or greater IF NOT EXISTS (SELECT * WHERE CONVERT(varchar(128), S...
-
alwayson_ddl_executed - This event collects data when a data definition language statement is executed, including CREATE, ALTE...
-
List of all database with recovery modes and version information. '--- SQL 2005 SELECT NAME,COMPATIBILITY_LEVEL,RECOVERY_MODEL_...
No comments:
Post a Comment