I cant thank you enough....... its the major goof up i had done in my 6 years as a DBA. I was testing THE logon triggers and created it on sysadmins and worse without knowing the sa password.

Thanks to this forum, i now cleared the problem with out getting all the attention.

C:\Documents and Settings\dove165>sqlcmd -s ghdb78 -e -A -q "Disable trigger tr

igLogon_CheckForSysAdmin ON ALL SERVER"

Disable trigger trigLogon_CheckForSysAdmin ON ALL SERVER

1>

It worked like MAGIC!

thanks all