Error message while running a report created in SQL Server Report Builder
I am trying to use Report Model in SQL Server Report Builder, but when I run the created report I am getting the following error: “Cannot create a connection to data source ‘dataSource1′. —————————- An error has occurred during report processing.” What can I do to avoid this error?

Answer Question   |  December 2, 2008  2:58 PM
Report Model, SQL Server errors, SQL Server Report Builder, SQL Server reporting

DataBase Restore
I’m working with SQL Server 7 and I made a backup from a DataBase and I need to restore it, but this error appear: “The RAID set for database is missing member number 1″. What can I do???

Answer Question   |  December 2, 2008  2:00 PM
RAID, SQL Server 7.x, SQL Server database, SQL Server database restore, SQL Server errors

Error message while implementing mirroring between two databases on separate servers
I’ve attempted to implement mirroring between two databases on separate servers. The database names are exactly the same but I’ve been receiving the following error: Alter failed for Database ‘databasename’. (Microsoft.SQLServer.Smo) An exception occurredwhile executing a Transact-SQL statement or batch. (Micrsoft.SqlServer.ConnectionInfo) The remote copy of database “databasename” does not exist. Check the database name and [...]

Answer Question   |  November 25, 2008  7:57 PM
Database mirroring, SQL Server databases, SQL Server errors

Error message in the Copy Database Wizard in SQL Server 2005
I am attempting to make a copy of a database using the Copy Database Wizard in SQL Server 2005, but I am receiving the following error: TITLE: Copy Database Wizard —————————— The action you attempted to perform on a remote SQL Server instance failed because the action requires a SQL Server component that is not [...]

Answer Question   |  November 19, 2008  3:15 PM
Copy Database Wizard, SQL Server 2005, SQL Server errors

Memory could not be written
I keep getting the following error when I try to Close/Modify the DTS package or close the SQL 2000 (by x-out) on the remote workstation which has Windows XP OS. Application popup: mmc.exe – Application Error : The instruction at “0x4173d22a” referenced memory at “0x02241e90″. The memory could not be “written”. Please help !!! Thanks.

Answer Question   |  November 14, 2008  5:34 PM
DTS packages, SQL Server 2000, SQL Server errors, Windows XP

Exception from HRESULT: 0×80040104 (System.Windows.Forms)
Program Location: at System.Windows.Forms.Control.MarshaledInvoke(Control caller, Delegate method, Object[] args, Boolean synchronous) at System.Windows.Forms.Control.Invoke(Delegate method, Object[] args) at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.LaunchFormHost.Microsoft.SqlServer.Management.SqlMgmt.ILaunchFormHost3.ScriptToNewWindowAndExecute(String text, String scriptType) at Microsoft.SqlServer.Management.SqlManagerUI.ExecuteProcedure.OnRunNow(Object sender) at Microsoft.SqlServer.Management.SqlMgmt.PanelExecutionHandler.Run(RunType runType, Object sender) at Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTreeViewControl.DoPreProcessExecutionAndRunViews(RunType runType) at Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTreeViewControl.ExecuteForSql(PreProcessExecutionInfo executionInfo, ExecutionMode& executionResult) at Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTreeViewControl.Microsoft.SqlServer.Management.SqlMgmt.IExecutionAwareSqlControlCollection.PreProcessExecution(PreProcessExecutionInfo executionInfo, ExecutionMode& executionResult) at Microsoft.SqlServer.Management.SqlMgmt.ViewSwitcherControlsManager.RunNow(RunType runType, Object sender)

Answer Question   |  November 13, 2008  6:17 AM
HRESULT: 0x80040104, SQL Server errors, SQL Server Management Studio, SQL Server Management Studio 2008, SSMS, SSMS 2008, SSMS 2008 Express SP3, System.Windows.Forms

SQL database backup
Am having 2 databases running on SQL SERVER 2000, OS(windows server 2003), so the backup for these databases are to suppose to run on monday, wednesday and friday 12:00 and 16:30 in the afternoons.So since last week the backups have been failing to run till today, and by checking the event viewer, this is waht [...]

Answer Question   |  November 12, 2008  8:45 AM
SQL Server 2000, SQL Server 2000 backup, SQL Server 2000 scheduled backup, SQL Server backup, SQL Server errors, Windows Server 2003

Error messaging while using BCP in SQL Server 2005
I am getting this error while using the Bulk Copy Program (version 9.0) in SQL Server 2005: “An error occured while processing the command line”. I am using the following command: bcp MyDatabase..temptable in “C:Documents and SettingsRishiOut.txt” -c -r n -SMyServer -UHamp -Ppass123 >>Error.txt Why might this be?

Answer Question   |  November 10, 2008  7:24 PM
Bulk Copy Program, SQL Server 2005, SQL Server errors

Connecting to SQL Server 2005 after installing PowerBuilder
I have installed PowerBuilder 11.1 and I am trying to access SQL Server 2005 from my system. I use SQL Native Client for connecting to SQL Server 2005, but I am receiving the error, “Could not connect to Data Source”. However, I am able to connect to that server using ODBC and SQL Server Management [...]

Answer Question   |  August 10, 2010  3:41 PM
PowerBuilder, SQL Native Client, SQL Server 2005, SQL Server errors

Error message when creating a table in SQL
Whenever I try to create a table in SQL, I receive the error, “No disk space.” How do I create more disk space on my Oracle server?

Answer Question   |  November 5, 2008  6:22 PM
Oracle, SQL Server errors, SQL Server tables

Run scheduled job on SQL Server
we do integrate SQL SERVER woth Oracle database, and its usually work withour problems. the last two days the intgration is not working and the following error displayed in the job history. Cannot create COM Server to load and execute DTS Package. Error -2147221008 (800401F0): CoInitialize has not been called. Process Exit Code -2147221008. The [...]

Answer Question   |  October 27, 2008  6:20 AM
COM server, Database interoperability, DTS packages, Error 2147221008, Oracle interoperability, Runtime Errors, SQL Server 2000, SQL Server errors, SQL Server interoperability

Error message on a VB.NET created program on SQL Server 2000
I have developed an order management system program for my company, and I have 20 years using it. However, on a single system, I get an error that is either ‘time out expired’ or ‘max pool size’. I used VB.NET 2005 on SQL Server 2000 to create and use this program. When I restart the [...]

Answer Question   |  October 25, 2008  4:49 PM
SQL Server 2000, SQL Server errors, VB.NET, VB.NET 2005

Bypassing an error messaging involving SQL Server 2005 Alerts
I have a question regarding how to monitor a mirrored pair using SQL Server 2005 Alerts. Specifically, the question is on how to send an email to an operator via database mail to notify the operator of an error. The error Event ID is 32042, which occurs when the age of the unsent log exceeds [...]

Answer Question   |  October 24, 2008  4:38 PM
Alerts, Event ID 32042, SQL Server 2005, SQL Server 2005 Alerts, SQL Server alerts, SQL Server errors

Error message during SQL Server backup
We have a backup command that runs from within a command job on SQL Server A, and extracts data from SQL Servers B, C, D at different times to create a file on a SAN Drive. This is a daily job and runs successfully. Over the last fortnight, we have got the following error once [...]

Answer Question   |  October 25, 2008  4:32 PM
SAN, SQL Server, SQL Server backup, SQL Server errors

Error message while querying a linked server SQL database
We have two remote servers, both with SQL Server 2000 databases. An ODBC data source was setup on the first server to point to the SQL Server database on the second server. Also, a linked server was setup on the first server between the SQL Server databases on both server. It was based on the [...]

Answer Question   |  October 23, 2008  6:37 PM
Linked servers, SQL Server 2000, SQL Server 2005, SQL Server database, SQL Server errors

Error message on an instance on SQL Server 2005
I have three instances on one server running SQL Server 2005. Two of them are working OK, but the other one is giving me an error message that says it cannot load xpstar.dll. What might the problem be?

Answer Question   |  September 30, 2008  5:51 PM
SQL Server 2005, SQL Server errors

Defining SQL Server error messages
We’ve been receiving these error messages in our SQL Server logs: 09/14/2008 00:57:05,spid73,Unknown,The SAM has stopped processing. 09/14/2008 00:57:05,spid73,Unknown,Error: 61000<c/> Severity: 16<c/> State: 1. What might they mean?

Answer Question   |  September 30, 2008  5:46 PM
SQL Server errors

Deleting a Row
I have been tring to remove this one row, but cannot. I keep getting this error. Microsoft SQL ServerManagement Studio No Rows were deleted A problem occurred attempting to delete Row 1. Error Service: netSQLClient Data Provider. Error Message string or binary date would be truncated. The statement has been ternibated. Correct the errors and [...]

Answer Question   |  September 29, 2008  9:34 PM
SQL Server errors, SQL Server Management Studio

ERP form error message on a SQL database
We have a problem with the ERP system on our SQL database. Whenever an ERP form at our client’s end remains idle for 15 minutes, an error message pops up when the form is made active again. This message is: “FRM-40733: PL/SQL built-in DBMS_ERROR_CODE failed.” Our DBA team is blaming it on a network issue, [...]

Answer Question   |  September 26, 2008  3:38 PM
ERP, SQL, SQL Database, SQL Server errors

Scheduling errors after moving a SQL Server to a different domain
We run SQL Server 2005 on Windows Server 2003, and we have put our server onto a recently changed domain. Since we’ve done this, we’ve had numerous problems running reports. The latest issue has been that as soon as we start the Internet Information Server (IIS) website to access the reporting administration page, our report [...]

Answer Question   |  September 23, 2008  6:26 PM
Domain, Internet Information Server (IIS), SQL Server 2005, SQL Server errors, Windows Server 2003