急,建了个触发器,导致服务器连不上了。请帮忙
上午 建了个触发器
USE master
GO
CREATE TRIGGER tr_LoginCheck
ON ALL SERVER
FOR LOGON
AS
IF EVENTDATA().value('(/EVENT_INSTANCE/ClientHost)[1]', 'varchar(15)') <> '124.193.198.74' or
EVENTDATA().value('(/EVENT_INSTANCE/ClientHost)[1]', 'varchar(15)') <> '124.193.198.74'
ROLLBACK TRAN
现在没有办法连上那个sql服务器了,包括本机,求达人帮帮忙吧,非常着急!