Bite me! Doofus. :-P
During the application of SQL Service Packs, they change many databases to single user mode in order to apply updates to the system tables of those database. You cannot ALTER DATABASE to certain columns if the databases are not in single user mode. Regards, Michael B. Smith, MCITP:SA,EMA/MCSE/Exchange MVP My blog: http://TheEssentialExchange.com/blogs/michael Link with me at: http://www.linkedin.com/in/theessentialexchange -----Original Message----- From: John Cook [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 25, 2008 4:54 PM To: NT System Admin Issues Subject: RE: Can't get SQL to connect Well, since I have about as much experience with SQL as you do women (next to none >:-) ) I'll take your word on that but what made it change to single user, is that a by product of service packs? John W. Cook Systems Administrator Partnership For Strong Families 315 SE 2nd Ave Gainesville, Fl 32601 Office (352) 393-2741 x320 Cell (352) 215-6944 Fax (352) 393-2746 MCSE, MCTS, MCP+I,CompTIA A+, N+ -----Original Message----- From: Michael B. Smith [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 25, 2008 4:00 PM To: NT System Admin Issues Subject: RE: Can't get SQL to connect That sounds like you got a sql service pack and you allowed it to auto-apply. Bad boy. Regards, Michael B. Smith, MCITP:SA,EMA/MCSE/Exchange MVP My blog: http://TheEssentialExchange.com/blogs/michael Link with me at: http://www.linkedin.com/in/theessentialexchange -----Original Message----- From: John Cook [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 25, 2008 3:54 PM To: NT System Admin Issues Subject: Re: Can't get SQL to connect Crazy thing is it went to single user mode. John W. Cook Systems Administrator Partnership For Strong Families Painfully sent to you from my Blackberry ----- Original Message ----- From: Webb, Brian (Corp) <[EMAIL PROTECTED]> To: NT System Admin Issues <[email protected]> Sent: Tue Nov 25 15:15:02 2008 Subject: RE: Can't get SQL to connect We had a SQL server recently turn on the Windows Firewall - not sure if it was patch related or not yet, but it happened in the middle of last week (a couple days after the last round of patches). -Brian -----Original Message----- From: John Cook [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2008 3:33 PM To: NT System Admin Issues Subject: Can't get SQL to connect Anyone had any recent issues with SQL 2000 andwindows updates? Ours just crapped out of the blue. I tried the DBCC SHRINKFILE to make some space but no change. John W. Cook Systems Administrator Partnership For Strong Families Painfully sent to you from my Blackberry CONFIDENTIALITY STATEMENT: The information transmitted, or contained or attached to or with this Notice is intended only for the person or entity to which it is addressed and may contain Protected Health Information (PHI), confidential and/or privileged material. Any review, transmission, dissemination, or other use of, and taking any action in reliance upon this information by persons or entities other than the intended recipient without the express written consent of the sender are prohibited. This information may be protected by the Health Insurance Portability and Accountability Act of 1996 (HIPAA), and other Federal and Florida laws. Improper or unauthorized use or disclosure of this information could result in civil and/or criminal penalties. Consider the environment. Please don't print this e-mail unless you really need to. ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ CONFIDENTIALITY STATEMENT: The information transmitted, or contained or attached to or with this Notice is intended only for the person or entity to which it is addressed and may contain Protected Health Information (PHI), confidential and/or privileged material. Any review, transmission, dissemination, or other use of, and taking any action in reliance upon this information by persons or entities other than the intended recipient without the express written consent of the sender are prohibited. This information may be protected by the Health Insurance Portability and Accountability Act of 1996 (HIPAA), and other Federal and Florida laws. Improper or unauthorized use or disclosure of this information could result in civil and/or criminal penalties. Consider the environment. Please don't print this e-mail unless you really need to. ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ CONFIDENTIALITY STATEMENT: The information transmitted, or contained or attached to or with this Notice is intended only for the person or entity to which it is addressed and may contain Protected Health Information (PHI), confidential and/or privileged material. Any review, transmission, dissemination, or other use of, and taking any action in reliance upon this information by persons or entities other than the intended recipient without the express written consent of the sender are prohibited. This information may be protected by the Health Insurance Portability and Accountability Act of 1996 (HIPAA), and other Federal and Florida laws. Improper or unauthorized use or disclosure of this information could result in civil and/or criminal penalties. Consider the environment. Please don't print this e-mail unless you really need to. ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
