InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 11:28:00 GMT20http://www.sqlservercentral.com/Forums/Topic752448-1506-1.aspxYou can also login using SQLCMD, then drop the trigger.Logging in using SQLCMD bypasses the trigger, I have had to do it dozens of times when things go wrong.Mon, 05 Apr 2010 13:28:07 GMTGregoryFhttp://www.sqlservercentral.com/Forums/Topic752448-1506-1.aspxIt's a pity that the correct answer (login using DAC and set the default database and language for that login back to what they were before) isn't available. I assumed the trigger concerned had a purpose - probably relating to corporate policy - and disabling as a quick fix would be unacceptable, also that I had followed good practise and backed up master before changing properties of a login, and since I wasn't allowed to pick the correct answer opted for what I still think is the least wrong of the options provided.Sun, 21 Mar 2010 03:34:21 GMTL' Eomot Inverséhttp://www.sqlservercentral.com/Forums/Topic752448-1506-1.aspx[quote][b]SanjayAttray (7/21/2009)[/b][hr][quote][b]Marcin Zawadzki (7/15/2009)[/b][hr]Resource database is not wide known. We belive in 4 system databases: master, model, tempdb, msdb.For those who would delete resource database - remember, you have to restore your tempdb database from backup after that ;-)[/quote]I thought SQL server would not work properly and have to re-install SQL Server.[/quote]Ha HA........I got your sarcasm here. Good one. You cannot take backup or restore operation on tempdb.Tue, 21 Jul 2009 14:49:12 GMTSanjayAttrayhttp://www.sqlservercentral.com/Forums/Topic752448-1506-1.aspx[quote][b]Marcin Zawadzki (7/15/2009)[/b][hr]Resource database is not wide known. We belive in 4 system databases: master, model, tempdb, msdb.For those who would delete resource database - remember, you have to restore your tempdb database from backup after that ;-)[/quote]I thought SQL server would not work properly and have to re-install SQL Server.Tue, 21 Jul 2009 14:47:31 GMTSanjayAttrayhttp://www.sqlservercentral.com/Forums/Topic752448-1506-1.aspxResource database is not wide known. We belive in 4 system databases: master, model, tempdb, msdb.For those who would delete resource database - remember, you have to restore your tempdb database from backup after that ;-)Wed, 15 Jul 2009 01:37:19 GMTMarcin Zawadzkihttp://www.sqlservercentral.com/Forums/Topic752448-1506-1.aspx[quote][b]pdanke (7/14/2009)[/b][hr]The fact that there were any votes for the "delete Resource database" option was a bit scary.[/quote]88 people opted this answer till now! :w00t:Wed, 15 Jul 2009 00:54:25 GMTVM-723206http://www.sqlservercentral.com/Forums/Topic752448-1506-1.aspxThe fact that there were any votes for the "delete Resource database" option was a bit scary.Tue, 14 Jul 2009 07:20:57 GMTjjtetzlohttp://www.sqlservercentral.com/Forums/Topic752448-1506-1.aspxComments posted to this topic are about the item [B]<A HREF="/questions/Security/66534/">Login Failed</A>[/B]Mon, 13 Jul 2009 21:12:33 GMTMarcin Zawadzki