Server Configuration
in [Microsoft SQL Server]
|
3701 Errors after installing SP2 Environment: SQL Server 2005 Enterprise Edition SP2 Windows 2003 R2 x64 Enterprise 80+ Databases, all upgraded to compatibility 90 Since upgrading to SP2 for SQL Server 2005, my scheduled jobs based on Maintenance Plans which include Statistics Updates, Index Rebuilding and Index Reorganization tas... 28 Feb 2007 16:22
Error in maintenance plan after SP2 Before SP2 my maintenance plan was stable. Now, I get the following when I try to modify the plan: Microsoft SQL Server Management Studio is unable to load this document: Retrieving the COM class factory for component with CLSID {E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to the following error: 8007007... 1 Mar 2007 14:09
Operation: Connection reset Hi there, I build an application on top of SQL Server 2005. If my dataset is quite big, then there is an SQL exception as following. com.microsoft.sqlserver.jdbc.SQLServerException: An exception occurred during the DBComms.receive method. Operation: Connection reset. Context(1) [Thread[main,5,main], IO:a2dce, ... 26 Feb 2007 04:16
SQLWB.exe Application Error I tried to open SQL Server Management Studio and it gives an error message "The application failed to initialize property (0x00000135). Click on OK to terminate the application" And even I tried to open SQL Server Configuration Manager and it gives an error message "Snap-in failed to initialize, Name: SQL SErv... 21 Feb 2007 15:54
Long running Job - SQL Server Agent View the job history to view how long the job normally runs. Could also be that the job should allways be running. I think you can better post in the Bizztalk newsgroup. Greetz. -- I drank alot of beer and ended up in the police department database. Drank more beer and learned SQL in the dark hours. DELETE FR... 19 Jan 2007 15:47
Database Engine Tuning Wizard: "Failed to initialize MSDB database for tuning (exit code: -1). (DTAClient) With regard to the "Database Engine Tuning Wizard: "Failed to initialize MSDB database for tuning (exit code: -1). (DTAClient)" error, I just ran into this myself with a fresh install of MS SQL Server 2005 + SP1. I ran SQL Profiler on another server, that was working, to see what was happening when firing up th... 10 Jan 2007 13:22
Server could not load dcom Hi I am trying to run a query from query analyzer using SELECT * FROM OPENROWSET but I get the error The server could not load DCOM. I was just wondering what the solution may be on this? I have some sql 2005 components installed as well as SQL2000. Thanks. -- Paul G Software engineer. ... 10 Jan 2007 11:16
[TCP/IP Sockets]ConnectionCheckForData (CheckforData()) MS SQL 2000. When I attempt a SELECT I get the following: [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionCheckForData (CheckforData()). Server: Msg 11, Level 16, State 1, Line 0 General network error. Check your network documentation. Connection Broken The offending SELECT select a.a... 8 Jan 2007 22:48
XP_Sendmail Hi, I need to send an email on an trigger on Insert. Is xp_sendmail what I use to do this with? I tried using it however received an error message: "Syntax error or access violation" This is basically what I am executing: xp_startmail xp_sendmail {@recipients = 'receiver(a)someServer.com'}, @message =... 11 Jan 2007 06:35
ActiveX component can't create object (DSO) Hi. I am trying to upgrade from SQL 2000 with the latest SP to SQL 2005. When I run the Upgrade Advisor I get the following error message: Analysis Service ActiveX component can't create object (DSO) Any ideas as to what I need to do to fix this? I have SQL 2000 installed as part of SBS 20... 23 Dec 2006 18:00 |