Server Configuration

Create assembly problem on SQL2005
Hello, when I try to create an assembly: Create assembly LibSql FROM 'c:\SQLNET\LIBSQL\LIBSQL.dll' WITH PERMISSION_SET = External_Access I got the following error Failed to initialize the Common Language Runtime (CLR) v2.0.50727 with HRESULT 0x80131522. You need to restart SQL server to use CLR integration ... 19 Sep 2006 09:07

ddl statement is not allowed
Can someone help me with this. I have installed the trail version of SQL Server 2005 on a 2003 server box alongside an existing installation of SQL Server 2000. I can connect to and create new databases but cannot create tables within the database with create table statements. I get the error 'DDL statement is ... 6 Sep 2006 11:31

SQL Server 2000 errors
Hi - Please could someone explain the cause of the following messages from a SQL Server 2000 machine in a clustered environment: RowId=21953206 TimeGenerated=01.09.2006 01:16:34 Log=App Category=3 CategoryString=Failover Type=1 EventId=17052 Message=[sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed ... 5 Sep 2006 11:31

Max worker threads Error
We received these in our production sqlserver error log last night: 2006-08-31 17:34:06.22 spid342 startsubprocess: Limit on 'Max worker threads' reached. 2006-08-31 17:34:13.58 spid236 startsubprocess: Limit on 'Max worker threads' reached. 2006-08-31 17:34:16.55 spid335 startsubprocess: Limit on 'Max worke... 1 Sep 2006 12:48

tempdb autogrow error message
Has anyone seen this error message? Autogrow of file 'tempdev' in database 'tempdb' cancelled or timed out after 2140 ms. Use ALTER DATABASE to set a smaller FILEGROWTH or to set a new size. I am getting these in my error log. It's a clustered environment with AWE enabled in it. SQL Server version is: Mic... 14 Sep 2006 12:26

xp_sendmail not working
Running: Microsoft SQL Server 7.00 - 7.00.1094 (Intel X86) May 29 2003 15:21:25 Copyright (c) 1988-2002 Microsoft Corporation Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4) When my jobs that use xp_sendmail run, I get the following message: Server: Msg 17926, Level 18, State 1, Line 0... 2 Aug 2006 09:48

KILLED\ROLLBACK on BACKUP
My nightly backup got hung on a "clearchangebits" task and we were forced to kill the process to alleviate some application blocking (Highly used production server). Now the backup SPID is stuck in KILLED\ROLLBACK status and KILL <SPID> statusonly shows rollback is 100% complete? I'm reluctant to restart the ... 17 Jul 2006 08:15

Connection errors
Hi - I originally posted this to windows.server.general, but no responses there. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ I have database application that stops working and the event log shows two errors - I suspect that they are related but I don't know for certain and I'm not sure whether they refer to connections to SQ... 29 Jun 2006 05:42

The SQLBrowser service was unable to process a client request error
I'm using SQL 2005 (no service pack) on a windows 2003 enterprise x64 edition. I'm seeing these errors with regularity in my application event viewer. For the most part, things seem to be running ok. But I'd like to find out why these are occurring? Anyone seen it before? What does it mean? I am in an act... 27 Jun 2006 12:47

SQL 2005 Memory Error
I have a 64 bit sql 2005 server run on a 64 gig windows 2003 64bit server. The sever has been running fine for the last few months. In the last couple of days a problem has come up though. Twice in the last few days the SQL server started reporting not enough memory to run a query and stopped allowing connec... 29 Jun 2006 01:05