Server Configuration

sp_send_dbmail and email encoding
Hi, I use sp_send_dbmail to send some emails and I have the problem that one of them has <meta http-equiv="Content-Type" content="text/html; charset=ks_c_5601-1987"> and the other <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> inside the body (text inserted by sql server) which... 29 Sep 2008 06:46

DB Tuning Advisor - Statement does not reference any tables
When running the DB Tuning Advisor on a SQL 2005 database that has a stored procedure with parameters and the SQL for that SP in the tuning advisor it shows CategoryID S001, Statement does not reference any tables. Why is it not detecting any tables and how can I correct this? ... 21 Sep 2008 17:56

Ticking Clock - TempDB LDF Getting too big
Hi, We are running SQL 2000 and for some reason TempDB LDF is getting too big. TEMPDB MDF is only about 35MB while LDF has grown to 11+GB in three days. I have confirmed that it is growing by a few MB every few seconds. I read a prior post with similar issue and ran the commands mentioned. Here are the resul... 16 Sep 2008 08:43

MSSQL / MS Cluster Issue
Hi there, Did you get a solution for the error "The Cluster Service function call 'ClusterResourceControl' failed with error code '1008(An attempt was made to reference a token that does not exist.)'" Regards, Piet Michau ... 18 Aug 2008 05:25

Auto stats interfere with ALTER COLUMN...
Friends, I am trying to programatically list column "dependents" so they can be elimianted prior to ALTER COLUMN. I am having great success, except for statistics, such as '_dta_stat_*'. I know what these are, of course, and have a nice query for SQL Server 2005/2008, but that query won't work on SQL Server ... 18 Aug 2008 06:26

Default Trace Logs - increase size
The default trace file that is located in the following location: ~\Program Files\Microsoft SQL Server\MSSQL\LOG\log_1.trc ~\Program Files\Microsoft SQL Server\MSSQL\LOG\log_2.trc ~\Program Files\Microsoft SQL Server\MSSQL\LOG\log_3.trc .... .... .... How do I configure to increase the file size ... 14 Aug 2008 04:13

linked server to foxpro, how??
I am using SSMS to create a linked server to a VFP free tables directory, and I keep getting this error after clicking 'Tables' in the SSMS GUIr: The OLE DB provider "VFPOLEDB" for linked server "T1" reported an error. Access denied. Cannot obtain the required interface ("IID_IDBSchemaRowset") from OLE DB provi... 22 Jul 2008 12:41

[DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security e
Hello, We recently performed a server migration of a server that functions as both a web server and database server. The OS is Windows Server 2003. The SQL Server is running SQL Server 2005. The main web site is not configured to use SSL. Every two days or so on an intermittent basis, users accessing the site ... 18 Jul 2008 08:13

cannot create maintenance plan - error 17828
I have just updated an existing SQL Server Express server to SQL Server Developer Edition 9.0.1399. In general this has worked fine, but I cannot create a Maintenance Plan, either using the Wizard or by using "New Maintenance Plan..." The latter brings up a dialog saying that: Exception has been thrown by the ... 15 Jul 2008 10:14

SQL Server 2008 developer RC0 missing setup.exe?
I downloaded RC0 onto a Vista Business Dell Optiplex 755 (x86) quad core. My directory listings for \x86 and \setup look like this: C:\downloads\x86\setup>dir /b 1033 catalog config.xml owc11.msi owc11sp1.msp rsfx.msi rssharepoint.msi sqlbrowser.msi sqlserver2008_bol.msi sqlserverbestpracticespolicies.m... 27 Jun 2008 09:04