Recent IT Questions

1 - 10 of 10
<<PREVIOUS 1 NEXT>>

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


1 - 10 of 10
<<PREVIOUS 1 NEXT>>