Error messages in Business Intelligence Development Studio on SQL Server Integration Sevices
I am new to SQL Server Integration Services (SSIS). When I went into Business Intelligence Development Studio (BIDS) and tried to create a new project, I received this error message:"Could not load or assembly 'Microsoft.DataTransformationServices.Wizards' or one of its dependencies. The system...
Answer Question
| Jul 1 2008 3:35 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server, SSIS, Business Intelligence
xp_fileexist workd in Query window but doesnt in stored procedure
Hello,I am running on SQL server on my local PC . I am singed onto the PC using a network user.This probelm happens if the SQL server service runs as either Local system or network service.In the server management studio if I go to a query window and enterDeclare @result intexec xp_fileexist...
Answer Question
| Jun 26 2008 1:59 PM GMT
| asked by
Kendo
MS SQL, Stored procedures, SQL error messages
Consistent error occuring in SQL Server 2005
I have five servers in my network. On one member server, I have SQL 2005 Standard ver.9.00.1399.00 running on MS Server 2003 R2 SP2. In my event log on this server, I am receiving an error every couple minutes. They show up in the SQL error log as well as the event viewer. The error is:Event...
View Answer
| Jun 18 2008 5:29 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server 2005, Windows Server 2003, SQL error messages
Finding the appropriate settings for copying tables within databases
I have a table in a database that has 104456 records. I would like to copy the data to another table within that database. When I execute the command “insert into ChangeInsuranceTxnHistory select * from ChangeInsuranceTxn”, the following error occurs:"Could not allocate space for object...
View Answer
| Jun 18 2008 5:14 PM GMT
| asked by
SQL Server Ask the Experts
SQL, Database issues, Copy error
Trouble opening an inaccessible table in SQL Server 2005
A client of ours is running SQL Server 2005 with PS2 on Windows Server. His database size is about 5 GB. Every now and then something happens and one table (the most important) becomes inaccessible. When we try to open the table, it gives a “SQL time out” error. This sometimes happens twice...
View Answer
| Jun 18 2008 3:10 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server 2005, DBCC, SQL error messages
How to use partitioning in SQL Server database to avoid ‘timeout’ errors
We have over 300 stores, and with each store having 30gb+ databases, each server is being upgraded to at least 6gb+ memory which is being forced allocated to SQL Server. I want to start to partition the existing SQL Server database by date. How do I go about doing it, because I have absolutely no...
View Answer
| Apr 30 2008 6:01 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server performance tuning, SQL error messages, Timeout
Critical error in event logs
Why do I get this message; "SQLVDI: Loc=CVDS::Cleanup. Desc=Release(ClientAliveMutex). ErrorCode=(288)Attempt to release mutex not owned by caller."?
View Answer
| Apr 28 2008 2:24 PM GMT
| asked by
Dbs13790
SQL, SQL Express, SBS 2003
How to rectify the overflow error occured?
Hi..i appended 4 to 5 records, after that overflow error had occured while executing the sql query in vb....Pl guide me how to solve this?Sree...
Answer Question
| Apr 24 2008 4:20 PM GMT
| asked by
Sreegans
SQL error messages, VB, Visual Basic
Upgrade to SQL Server 2005 resulted in 100% CPU utilization and application timeout error
My server is DL580 running on Intel Xeon Dual core Dual CPU. I have recently migrated from SQL Server 2000 to SQL Server 2005. The server is dying and showing 100% CPU utilization and applications are getting Server Timeout expired error. What can I do?
View Answer
| Apr 4 2008 1:46 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server upgrade, SQL error messages, SQL Server performance
CCSID in AS400
Hi, i am trying to update a DBCS data defined through ODW BPCS version 6 to DB400 and i run into error SQL-332.I do not whether the problem is with the host variable.I find all the definition of variable being handled properly.Thanks,karthick
Answer Question
| Nov 29 2007 5:20 AM GMT
| asked by
Karthick083
AS/400, CCSID, SQL error messages
