我写了个触发器,想限制IP登录,结果所有用户所有机器都不能登录服务器了请高手帮忙,十万火急CREATE TRIGGER [tr_LoginCheck]
ON ALL SERVER
FOR LOGON
AS
IF
EVENTDATA().value('(/EVENT_INSTANCE/ClientHost)[1]', 'varchar(15)') = '172.16.0.72' ROLLBACK TRAN
GOSET ANSI_NULLS OFF
ON ALL SERVER
FOR LOGON
AS
IF
EVENTDATA().value('(/EVENT_INSTANCE/ClientHost)[1]', 'varchar(15)') = '172.16.0.72' ROLLBACK TRAN
GOSET ANSI_NULLS OFF
2.将MDF,LDF文件全部备份出来
3.重装sql server
4.附加你备份出来的MDF,LDF文件.
http://www.cnblogs.com/ffufeng