摘要: From https://technet.microsoft.com/en-us/library/aa337272.aspx MSSQLSERVER_3271 Other Versions Other Versions Other Versions Other Versions Topic Stat 阅读全文
posted @ 2018-07-12 14:35 rosewong 阅读(1763) 评论(0) 推荐(0) 编辑
摘要: USE DBGO DECLARE @TableName AS varchar(max)DECLARE @Script AS varchar(max) DECLARE CurGrant CURSOR FORSELECT nameFROM sys.tables WHERE name LIKE '%Sal 阅读全文
posted @ 2018-06-28 10:42 rosewong 阅读(111) 评论(0) 推荐(0) 编辑
摘要: 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 阅读全文
posted @ 2018-06-27 10:30 rosewong 阅读(474) 评论(0) 推荐(0) 编辑
摘要: Reference from below links: http://www.itprotoday.com/microsoft-sql-server/seven-step-process-changing-databases-collation https://www.mssqltips.com/s 阅读全文
posted @ 2018-06-26 17:27 rosewong 阅读(265) 评论(0) 推荐(0) 编辑
摘要: From link : https://blogs.msdn.microsoft.com/sql_server_team/upgrading-a-replication-topology-to-sql-server-2016/ SQL Server Replication provides mult 阅读全文
posted @ 2018-06-07 10:12 rosewong 阅读(548) 评论(0) 推荐(0) 编辑
摘要: 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 阅读全文
posted @ 2018-05-23 11:50 rosewong 阅读(160) 评论(0) 推荐(0) 编辑
摘要: From:http://sqlity.net/en/1843/log-reuse-waits-explained-database_mirroring/ Introduction There are eight reasons SQL Server might report when it cann 阅读全文
posted @ 2018-05-16 15:04 rosewong 阅读(177) 评论(0) 推荐(0) 编辑
摘要: From: http://sqlity.net/en/1839/log-reuse-waits-explained-active_transaction/ Introduction There are eight reasons SQL Server might report when it can 阅读全文
posted @ 2018-05-16 15:02 rosewong 阅读(205) 评论(0) 推荐(0) 编辑
摘要: 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 阅读全文
posted @ 2018-05-16 15:00 rosewong 阅读(395) 评论(0) 推荐(0) 编辑
摘要: 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 阅读全文
posted @ 2018-05-16 15:00 rosewong 阅读(314) 评论(0) 推荐(0) 编辑