Gail I had mentioned in the first message that SQL was restarted in single user mode and then tried to create sysadmin login. however could not get logged in through...

Yes all the sysadmin logins

Exactly..all the logins with sysadmin role are locked out..Windows login is restricted by the trigger...how do I get in??

Hi,

Connecting via DAC requires to specify User Id and password. Since none of the login is available, SQL server cannot be connected. to connect via DAC I am using following...

Hi all,

Thanks for your replies. Yes Group by was missing but it was not the concern. Anyways, i figured out and got the performance. I used clustered index on table...