USE master GO IF OBJECT_ID (‘sp_hexadecimal’) IS NOT NULL DROP PROCEDURE sp_hexadecimal GO CREATE PROCEDURE sp_hexadecimal @binvalue varbinary(256), @hexvalue varchar (514) OUTPUT…
USE master GO — 보조 복제본 읽기 전용 연결 허용 (UI로 변경 가능) ALTER AVAILABILITY GROUP [ALG] MODIFY REPLICA ON N’WS16-AOSVR1′ WITH (SECONDARY_ROLE (ALLOW_CONNECTIONS…
EXEC sp_configure ‘external scripts enabled’, 1 RECONFIGURE WITH OVERRIDE EXEC sp_configure ‘external scripts enabled’ USE <database_name> GO GRANT EXECUTE ANY EXTERNAL SCRIPT TO [UserName] EXEC…
SELECT OBJECT_NAME(p.object_id) AS ObjectName, i.name AS IndexName, p.index_id AS IndexID, ds.name AS PartitionScheme, p.partition_number AS PartitionNumber, fg.name AS FileGroupName, prv_left.value AS LowerBoundaryValue, prv_right.value AS UpperBoundaryValue,…
Views Today : 60
Views Yesterday : 39
Views This Month : 1414
Views This Year : 20014
Total views : 56054
Who's Online : 0