<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Marcin Zawadzki
»
Login Failed
Login Failed
Rate Topic
Display Mode
Topic Options
Author
Message
Marcin Zawadzki
Marcin Zawadzki
Posted Monday, July 13, 2009 9:12 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Monday, April 08, 2013 4:59 AM
Points: 196,
Visits: 79
Comments posted to this topic are about the item
Login Failed
Post #752448
jjtetzlo
jjtetzlo
Posted Tuesday, July 14, 2009 7:20 AM
Ten Centuries
Group: General Forum Members
Last Login: 2 days ago @ 3:13 PM
Points: 1,089,
Visits: 4,537
The fact that there were any votes for the "delete Resource database" option was a bit scary.
- Jeff
Post #752656
VM-723206
VM-723206
Posted Wednesday, July 15, 2009 12:54 AM
SSChasing Mays
Group: General Forum Members
Last Login: Saturday, April 06, 2013 12:20 AM
Points: 649,
Visits: 263
pdanke (7/14/2009)
The fact that there were any votes for the "delete Resource database" option was a bit scary.
88 people opted this answer till now!
Post #753190
Marcin Zawadzki
Marcin Zawadzki
Posted Wednesday, July 15, 2009 1:37 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Monday, April 08, 2013 4:59 AM
Points: 196,
Visits: 79
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
Post #753218
SanjayAttray
SanjayAttray
Posted Tuesday, July 21, 2009 2:47 PM
Hall of Fame
Group: General Forum Members
Last Login: Friday, March 15, 2013 2:43 PM
Points: 3,924,
Visits: 1,554
Marcin Zawadzki (7/15/2009)
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
I thought SQL server would not work properly and have to re-install SQL Server.
SQL DBA.
Post #756971
SanjayAttray
SanjayAttray
Posted Tuesday, July 21, 2009 2:49 PM
Hall of Fame
Group: General Forum Members
Last Login: Friday, March 15, 2013 2:43 PM
Points: 3,924,
Visits: 1,554
SanjayAttray (7/21/2009)
Marcin Zawadzki (7/15/2009)
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
I thought SQL server would not work properly and have to re-install SQL Server.
Ha HA........I got your sarcasm here. Good one. You cannot take backup or restore operation on tempdb.
SQL DBA.
Post #756973
L' Eomot Inversé
L' Eomot Inversé
Posted Sunday, March 21, 2010 3:34 AM
SSCertifiable
Group: General Forum Members
Last Login: Yesterday @ 6:38 PM
Points: 7,077,
Visits: 7,116
It'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.
Tom
Que conclure à la fin de tous mes longs propos? C'est que les préjugés sont la raison des sots. (Voltaire, 1756)
Post #887054
GregoryF
GregoryF
Posted Monday, April 05, 2010 1:28 PM
SSC Eights!
Group: General Forum Members
Last Login: Tuesday, April 23, 2013 3:40 AM
Points: 961,
Visits: 794
You 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.
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
Post #896977
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
