• Unable to open a SQL application on two different machines

    If someone in our office opens a SQL application, no one else is able to open it. We all receive the message: “Another application is using this file.” How can we solve this problem?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Why sqlcode error=100 comes ?

    sqlcode error=100 comes. The required fields are being populated in table. Still why i am getting this error ?

    NAVIN5 pointsBadges:
  • 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 a...

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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...

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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 Type:...

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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...

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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."?

    Dbs1379015 pointsBadges:
  • 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?

    SQL Server Ask the Experts2,585 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following