• SQL Server error 7125: Updated driver to get around?

    I have used Microsoft ODBC SQL Server Driver to create a link to an SQL table using Microsoft Access. The table stores Word documents. However Access will not save records once large pictures are added to the Word document (thus increasing the size of the document). The following error occurs:...

    Health2u5 pointsBadges:
  • Error during SQL Server 2000 installation

    When I attempt to install SQL Server 2000 using Windows XP Service Pack 2 for IT Professionals and Developers, I encounter the following error: "Microsoft SQL Server 2000 Enterprise Edition server component is not supported on this operating system. Only client components will be available for...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Error Message when restoring a SQL server DB in SQL Server Express 2008 R2

    This error received and cannot determine resolution: System.data.Sqlclient.Sqlerror:Create Database or Alter Database failed because the resulting cumulative database size would exceed your licensed limit of 10240MB per database. The DB.bak file is 1.67MB

    Trackster209515 pointsBadges:
  • Microsoft Retail Management System and SQL Server “Write” error

    I am running Microsoft Dynamics Retail Management System POS 2.0 on Microsoft XP platform.  Store Operations Administrator and Manager are working with no problems.  I know I am networked properly.  When I open the POS I get the following:  "Open-Incorrect Function", I can click OK and sign on...

    Cls5 pointsBadges:
  • Error when trying to restore SQL Server database backup file

    We have a SQL Server database backup file with the extension .bak. In the new server we created a database with the same name. We are trying to restore the database with the backup file, but we’re unable to do that. When we try to add the backup file, SQL Server raises error that we have no...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Sudden SQL errors keep Business Contact Manager from loadingHELP – Sudden SQL errors keep Business Contact Manager from loading

    Dessteele5 pointsBadges:
  • Msg 102, level 15, State 1, Line 102

    I get this with an 'Incorrect syntax' messasge when I run a stored procedure. if I run the 'offending' code in isolation it works fine. If I tidy the code (e.g. remove line feeds etc), the error 'moves' to a different location. HELP!

    TonyDyer5 pointsBadges:
  • SQL Server 2005 error log, could not read information for this log entry

    Hi, There is a SQL Server error log entry in the SQL Server 2005 production box with the following.   "Log Viewer could not read information for this log entry. Cause: Data is Null. This method or property cannot be called on Null values.. Content:"   Has anyone seen anything similar? Does anyone...

    Db23290 pointsBadges:
  • SQL Server 2005 Error Registering database

    I try to copy SQL Server 2005 Database to VISUAL Jobshop (ERP INFOR) get message when VJS DB Wizard of Jobshop tries to create catalogue tables "Error registering database - operation is not allowed when object is closed" Thanks for help where I have to look to solve that problem.

    ITKE352,565 pointsBadges:
  • Composite foreign Key in SQL Server

    I have a composite foreign key that has to be part of the primary key of the new table... but an error appears in SQL server... CREATE TABLE Se_paga_con (IDpel INT NOT NULL, IDvta INT NOT NULL, IDnota INT NOT NULL, CantidadPeliculas INT, PRIMARY KEY (IDpel,IDvta,IDnota), FOREIGN KEY (IDpel, IDvta)...

    GabyCostilla5 pointsBadges:
  • FULL BACKUP taken by SQLExecDirect function works, but backup is not taken why?

    I try to backup SQL server database using ODBC native client apis. One weird error occurs. When I run, SQLExecDirect(stmt, "BACKUP DATABASE dbname TO DISK='C:TESTBK.BAK' WITH FORMAT ", sql_nts ) There are no errors during runtime, and message shows backup taken . But it is not seen innthe specified...

    ITKE352,565 pointsBadges:
  • SQL Server 2005 distribution agent failed

    Getting this error message

    ITKE352,565 pointsBadges:
  • sqlserver2005 on windows vista home premium(32 bit)

    i have sqlserver2005 wid service pack 2 installed,it gives server names as-'user-pcsqlexpress'&'user-pc'. But wen using visualstudio2008,if i give this as the server name during database connectivity it does not recognise and the error msg says that d server doesnt exists.Please give me a solution

    Rishabhshukla5 pointsBadges:
  • SQL Server Errors

    Your SQL server installation is either corrupt or has been tampered with (could not open SQLEVN70.RLL0 Please uninstall then re run set up to correct this problem. This question appears in many web pages, but none offers a straighforward method to answer this problem. Reg cure is not the answer, as...

    Tadders5 pointsBadges:
  • Deadlock issue in SQL Server 2005

    I have encountered a deadlock issue in <A href="http://searchsqlserver.techtarget.com/topics/0,295493,sid87_tax301323,00.html”>SQL Server 2005</a>. According to the trace flag 1204 report, the following two queries are causing the deadlock: 1. Simple insert statement INSERT INTO...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Crystal Reports in vb.net

    iam getting error while making connetion to sql server by OLEDB provider. The error is Sql server does not exit or access is denied ,sqlstate 08001

    Shaz255 pointsBadges:
  • SQL Server error: Cannot find log file

    I am receiving the error, "cannot find log file." I detach the database and I am unable to reattach it because of the error. I created a new database and copied the MDF. When I restarted the SQL Server, I am told the database is suspect. What can I do to fix this error?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Substract two fields SmallDateTime at SQL Server

    Hii.. IT Professional Helper, may i asked 1 question and hope IT Professional Helper can help me to answer my question? The Question is : Cm.CommandText = "Update Reminder Set IsDatang = 0, IsValid = 1 Where TglReminder - TglDatangKembali > 7" Cm.Execute If i get the error : Arithmetic overflow...

    Suryanto5 pointsBadges:
  • sql2005 with share point 2007

    I installed sql server2005 and sharpoint 2007 for two times in two seprate windows server2003 but i give same error when i want to start share point : failed to start the database service MSSQL$Officeservers.repair this product by selecting it from the add/remove programs menu. now how can i do?...

    4425195915 pointsBadges:
  • Error using SQL Server reports in a web application

    I have used SQL Server reports in my web application, and I can see it on the same server but we are getting a "Server Not Found" error on my user's machine.

    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