摘要:
From https://technet.microsoft.com/en-us/library/aa337272.aspx MSSQLSERVER_3271 Other Versions Other Versions Other Versions Other Versions Topic Stat 阅读全文
摘要:
USE DBGO DECLARE @TableName AS varchar(max)DECLARE @Script AS varchar(max) DECLARE CurGrant CURSOR FORSELECT nameFROM sys.tables WHERE name LIKE '%Sal 阅读全文
摘要:
From:https://docs.microsoft.com/en-us/sql/relational-databases/databases/msdb-database?view=sql-server-2017 The msdb database is used by SQL Server Ag 阅读全文
摘要:
Reference from below links: http://www.itprotoday.com/microsoft-sql-server/seven-step-process-changing-databases-collation https://www.mssqltips.com/s 阅读全文
摘要:
From link : https://blogs.msdn.microsoft.com/sql_server_team/upgrading-a-replication-topology-to-sql-server-2016/ SQL Server Replication provides mult 阅读全文
摘要:
From:https://www.mssqltips.com/sqlservertip/3559/how-to-grant-permissions-to-run-sql-server-profiler-for-a-non-system-admin-user/ Steps to give access 阅读全文
摘要:
From:http://sqlity.net/en/1843/log-reuse-waits-explained-database_mirroring/ Introduction There are eight reasons SQL Server might report when it cann 阅读全文
摘要:
From: http://sqlity.net/en/1839/log-reuse-waits-explained-active_transaction/ Introduction There are eight reasons SQL Server might report when it can 阅读全文
摘要:
From:http://sqlity.net/en/1830/log-reuse-waits-explained-log_backup/ Introduction There are eight reasons SQL Server might report when it cannot trunc 阅读全文
摘要:
From:http://sqlity.net/en/1835/log-reuse-waits-explained-active_backup_or_restore/ Introduction There are eight reasons SQL Server might report when i 阅读全文