Server Configuration

xp_msver 'Unable to determine server language
SQL Server 2000. In SQL Enterprise Manager, the properties page for the server is blank for the operating system, language, platform, OS memory and processors. The processor tab shows no processors. If I run xp_msver get the error 'Unable to determine server language version'. Can anyone help? I can o... 28 Jun 2008 17:49

Warning: Failed to get MSFTESQL indexer interface for full-text catalog
Good Day, I have noticed this warning in my SQL Server 2005 log. The full message reads:- Warning: Failed to get MSFTESQL indexer interface for full-text catalog 'JobsFullTextIndex' ('10') in database 'XXXXXXX' ('7'). Error: 0x80043613(A status change is occurring or the project is in a force paused state, so ... 18 Jun 2008 23:06

SQL_Latin1_General_CP1_CI_AS versus Latin1_General_CI_AS
Dear reader Our database is rolled out to several locations. Normally because of the default and some specified typing, all text fields (varchar etc.) are created as SQL_Latin1_General_CP1_CI_AS. But at one location the instance was different and the default was changed to Latin1_General_CI_AS, this was not... 13 Jun 2008 16:55

Class not registered error in Business Intelligence Dev Studio
I am trying to add a new data source to a new project in Business Intellegence Developmnet Studio. When I do this I get the error: class not registered looking for object with clsid {4503861B-5694-45AE-94DD-BC6541316FB7} Any idea what this might be related to? I am using SQL Server 2005 Standard on a Win... 30 May 2008 18:10

SQL 2005: sp_send_dbmail encodes e-mail in base64
On Apr 11, 2:50 pm, joshua.robinso...(a)gmail.com wrote: On Mar 13, 3:33 pm, mjhs...(a)gmail.com wrote: Hi all, We're using database mail (sp_send_dbmail) in SQL 2005 (64-bit) to e- mail a dataset to a customer. The procedure works perfectly with the major exception that the generated e... 30 May 2008 15:02

Missing SQL 2000 PCSOE registry values
The following keys are missing from my SQL 2000 installation. HKEY_LOCAL_MACHINE\SOFTWARE\PCSOE\SQLServerConfiguration\Version HKEY_LOCAL_MACHINE\SOFTWARE\PCSOE\SQLServerConfigurationAddIn\Version HKEY_LOCAL_MACHINE\SOFTWARE\PCSOE\SQLServerInventory\Version\ HKEY_LOCAL_MACHINE\SOFTWARE\PCSOE\SQLServerSchemaAl... 29 May 2008 15:24

SQL Server 2000 shuts itself down.
For the past couple of weeks now, my sql server agent shuts down on its own without leaving any error messages. Nothing really occurs prior to the shut down. 2008-05-19 13:57:28.84 server SQL server listening on TCP, Shared Memory, Named Pipes. 2008-05-19 13:57:28.84 server SQL Server is ready for clien... 21 May 2008 03:14

xp_sendmail is hanging(SQL Server 2000/sp4)
Hi All, I'm running one SQL Server 2000 sp4 and my problem is that the xp_sendmail is hanging . I tried the follow in order to solve this problem: - xp_stopmail ('Server: Msg 17955, Level 16, State 1, Line 0 xp_stopmail: Failed to stop SQL Mail session.) - killing all of the processes trying to send email... 5 May 2008 14:40

Languages supported by single-byte code page.
Hi all, This was already posted in microsoft.public.sqlserver.programming, but no answers since yesterday. I have the task of evaluating the effort to convert a couple of web pages of a large application to accept multiple languages. The web pages are data driven. The application is old and we won't change th... 5 May 2008 13:06

17066 :SQL Server Assertion: File: <umsio.cpp>, line=563 Faile
Thanks. We moved the SQL Server back to the old hardware and everything became normal. Looks like this was an issue with VMWare. "Jason Massie" wrote: An assertion is almost always a bug with SQL Server. However, you are not going to get very far with Microsoft support on this being SQL 2000 especiall... 10 Apr 2008 09:40