Server Configuration

Timeout after Mirroring Failover
I apologize if this is posted in the wrong place. It seems to overlap a number of products. We have a SQL Server 2005 Standard SP3 database running on Windows 2008 Standard SP2 x64. It is configured to use database mirroring (High Availability) with an identical server as the mirror and a very similar syste... 7 Oct 2009 23:08

Error 0X8007042B while restarting SQLServer Agent 2005
I got the same problem but it is BITS not starting because i was infected by a Trojan downloader http://www.viruslist.com/en/viruses/encyclopedia?virusid=21782844 Kind regards, James From http://www.developmentnow.com/g/118_2007_6_0_0_984150/Error-0X8007042B-while-restarting-SQLServer-Agent-2005.htm Posted via... 2 Oct 2009 05:25

system shutdown was unexpected
Hola, estamos teniendo problemas al iniciar un reindex con una base, el servidor queda inoperativo, teniendo que ser apagado desde el boton de power para poder reiniciarlo (se cuelga mal). Este servidor tiene varias bases, y corren otros jobs de mantenimiento y optimizacion pero con esta base (que no es muy gra... 30 Sep 2009 07:56

SQL Server Install Fails
I am trying to install sql server 2005 on windows 2003 SP2 and I am getting the following error message during installation ************** MSIEXEC.EXE - Application Error The exeception unknown software exception (0xc000000d) occured in the application at location 0x78138aa0 Click on OK to termina... 28 Sep 2009 13:41

MS_DataCollectorInternalUser
Does anyone know what/who this user is in SQL 2008 msdb database? I looks like an orphaned user to me but it is in all of our SQL 2008 instances. I have searched the internet, including M.S. websites, for any information and I'm coming up with nothing. thanks ... 28 Sep 2009 12:34

Disable index
What is the best way to disable index while we insert data into a huge table with clustered index. how do we enable it after the insert is done thanks ujjwol ... 24 Sep 2009 17:19

SSIS Issue with bulk insert
[SSIS.Pipeline] Error: component "SQL Server Destination" (118) failed the pre-execute phase and returned error code 0xC0202071. From http://www.google.cz/search?hl=cs&q=Error:+component+"SQL+Server+Destination"+(118)+failed+the+pre-execute+phase+and+returned+error+code+0xC0202071.&lr= Posted via DevelopmentNow.com... 24 Sep 2009 11:37

uncontrollable growth in sysmail_mailitems
I'm helping a user on the public forums with an odd error. The LOB allocation for this table is absolutely huge (and continues to grow to over 30GB) and doesn't seem justified by the rowcount or max(length) of the columns. I haven't been able to isolate any reason why this should be happening. The OP only keeps... 24 Sep 2009 08:13

SQL Server 2008 on Windows 2000 Advanced Server?
Hope this isn't too silly a question, but is it possible to install SQL 2008 on Windows 2000 Advanced Server? Thanks. ... 23 Sep 2009 15:36

I try to install the NDP20-KB916002-X86 I get the below error
"The upgrade patch cannot be installed by Windows Installer service because the program to be upgraded may be missing, or the upgrade patch may update a different version of the program. Verify that the program to be upgraded exists on your computer and that you have the correct upgrade patch." ... 21 Sep 2009 05:35