Server Configuration

DB Mail - Error formatting query, probably invalid parameters
On SQL Server 2008 Enterprise 64-bit: I am trying to attach a query to an email with DB Mail. It works in fine in SSMS, but when I put the TSQL script into a job it fails with the following error: Sql Severity 16 Sql Message ID 22050 Executed as user: DOMAIN\SQLServerAgent. Error formatting query, probab... 20 Jan 2009 10:34

Performance Problems with sp_cursorfetch on SQL 2000 - Need Help!!
I am running a SQL 2000 Enterprise SP4 server. Periodically I am seeing blocking issues apparently created by a sp_cursorfetch statement being executed under domain account. The blocking issue doesn't occur every day but generally the same time of day. Specifically the statement is "exec sp_cursorfetch 18015000... 13 Jan 2009 23:05

Force Protocol Encryption
Hello SQL Server 2008 Express and Force Protocol Encryption is set to Yes. No certif. is used. All clients connect to server using ADO/OLEDB, one client (Windows XP with SP3) gets error "Encryption is required to connect to this server but the client library does not support encryption; the connection has b... 7 Jan 2009 00:13

Visual Studio 2008 from SQL 2008 installation media and templa
Many thanks for your reply, unfortunately my problem is I can't see any template, just blanck project nothing more... "George Wen" wrote: the one with SQL 2008 only support SQL related project types, e.g. Reports, cube etc you will need to install it using the full VS2008 CD to support other proje... 6 Jan 2009 16:43

SQL Server 2008 and PowerShell
I'm new to SQL Server 2008 and having trouble with a job that was installed with SQL called syspolicy_purge_history. Step 3 uses a powershell command and is failing. The powershell command is: (Get-Item SQLSERVER:\SQLPolicy\DAVYJONESQL\DEFAULT).EraseSystemHealthPhantomRecords() The error returned is: Ex... 29 Dec 2008 20:44

Cannot restart SQL Server service
I recently installed SQL Server 2008 Express Edition with Advanced Tools. This is the version information from SQL Server Management Studio Microsoft SQL Server Management Studio 10.0.1600.22 ((SQL_PreRelease).080709- 1414 ) Microsoft Data Access Components (MDAC) 2000.085.1132.00 (xpsp.080413-0852) Microsoft ... 6 Jan 2009 16:43

failed to pause full-text catalog for backup
Hi, I'm using SQL Server 2005 and get the following error while trying to backup a database. "System.Data.SqlClient.SqlError: Failed to pause full-text catalog for backup. Backup was aborted. Check to make sure Microsoft Full-text Service is running properly and SQL server service have access to full-text... 19 Dec 2008 13:13

An error occurred during the execution of xp_cmdshell. A call to 'CreateProcessAsUser' failed with error code: '1314'.
George Try EXEC master..xp_cmdshell 'DIR C:\*.*' Where does store CreateProcessAsUser stored procedure? "George Wen" <windyqr(a)hotmail.com> wrote in message news:OF0NJwoWJHA.4412(a)TK2MSFTNGP03.phx.gbl... Hi All, I was trying to assign non-sysadmin users permission to run cmdshell without luck.... 11 Dec 2008 05:35

SQL Server Reporting Services Share Point Integration Error
After installing reporting services in SP Integration Mode. When selecting Set Server Defaults i get the error message: System.Web.Services.Protocols.SoapException: An internal error occurred on the report server. See the error log for more details. ---> Microsoft.ReportingServices.Diagnostics.Utilities.Intern... 2 Dec 2008 07:53

The supplied user buffer is not valid
Hello, We got the below error in our SQLServer and subsequently the ldf files for msdb and Temdb got corrupt. Had to finally restart the SQL service. Has anyone encountered this error? "LogWriter: Operating system error 1784(The supplied user buffer is not valid for the requested operation.) encountered." ... 17 Nov 2008 03:34