终极斗士4自由,香港回归15周年大阅兵,特种兵之火凤凰剧情分集介绍
1.查询的内存
sql_get_memory ='select name, value, value_in_use, [description] from sys.configurations where name = "max server memory
(mb)" order by name option (recompile)'
2.查询用户权限,server级别
sql_get_user_right_server = "select * from sys.fn_my_permissions(null, 'server')"
3.查询用户权限,database级别
sql_get_user_right_db = "select * from sys.fn_my_permissions(null, 'database')"
4.切换数据库主备关系
sql_change_master = "alter database elbert08 set partner failover"
如对本文有疑问,请在下面进行留言讨论,广大热心网友会与你互动!! 点击进行留言回复
SQL Server免费版的安装以及使用SQL Server Management Studio(SSMS)连接数据库的图文方法
SQL Server 2017 Developer的下载、安装、配置及SSMS的下载安装配置(图文教程详解)
网友评论