22,210
社区成员
发帖
与我相关
我的任务
分享
declare @sql varchar(5000)
select @sql='exec xp_cmdshell ''net stop SQLAgent$'+@@servicename+''' '
exec(@sql)
select @sql='exec xp_cmdshell ''net start SQLAgent$'+@@servicename+''' '
exec(@sql)
EXEC sp_configure 'show advanced options',1
RECONFIGURE
EXEC sp_configure 'xp_cmdshell',1
RECONFIGURE
DECLARE @STR VARCHAR(100)
SELECT @STR = CASE WHEN @@SERVICENAME = 'MSSQLSERVER' THEN 'NET START SQLSERVERAGENT'
ELSE 'NET START SQLAgent$' + @@SERVICENAME END
SELECT @STR
EXEC master..xp_cmdshell @STR
xp_servicecontrol 'stop', 'SQLSERVERAGENT' -- 停止
xp_servicecontrol 'start', 'SQLSERVERAGENT' -- 启动
select @@SERVICENAME
/*--------------------------------------------------------------------------------------------------------------------------------
SQLSERVER2008
(1 行受影响)
*/
查看数据库服务器名和实例名
print 'Server Name...............: ' + convert(varchar(30),@@SERVERNAME) --服务器名
print 'Instance..................: ' + convert(varchar(30),@@SERVICENAME) --实例名