在应用程序启动时, 用以查询检查:select count(*) from (select distinct hostname,net_address from master..sysprocesses a join master..sysdatabases b on a.dbid=b.dbid where net_address <>'' and Program_name not like '%SQL%' and b.[name]='客户端应用程序名' ) as y
sorry,打错了,应是"数据库名": 你执行一下下面语句,看看:select hostname,net_address,Program_name,name from master..sysprocesses a join master..sysdatabases b on a.dbid=b.dbid where net_address <>''
RECONFIGURE WITH OVERRIDE最後得啟服務master..xp_cmdshell 'net stop 服務器名'
master..xp_cmdshell 'net start 服務器名'
用以查询检查:select count(*) from
(select distinct hostname,net_address from master..sysprocesses a join master..sysdatabases b on a.dbid=b.dbid
where net_address <>'' and Program_name not like '%SQL%' and b.[name]='客户端应用程序名' ) as y
2。Program_name为什么我的应用程序名不能查询出来呢?
3。b.[name]的内容只有数据库的名称,而没有我的客户端应用程序名?
你执行一下下面语句,看看:select hostname,net_address,Program_name,name from master..sysprocesses a join master..sysdatabases b on a.dbid=b.dbid
where net_address <>''