• 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.

    ITKE344,900 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...

    ITKE344,900 pointsBadges:
  • SQL Server 2005 distribution agent failed

    Getting this error message

    ITKE344,900 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:
  • 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:
  • Find exact point where SQL Server 2000 job fails

    I am running an SQL Server Job, that executes a stored procedure with about 900 commands (mostly insert commands). The job was working OK, but suddenly fails, due to erroneous data (error message : overflow in converting numeric data to dadatype numeric !!). How can I find the exact point (command)...

    fbellos35 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:
  • SQL Server 2000 error message involving ASP

    We are getting a scripting engine exception on the ASP page, but it is actually updating the data to SQL Server 2000. Could the error be due to a SQL Server connection problem?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Installing SQL Server 2005 Enterprise Manager in Windows XP Pro

    how to install SQL 2005 enterprise manager in XP professional.. When I am trying to install it, it is giving me IIS errors

    Advancedjava25 pointsBadges:
  • Error message when finding a database on SQL Server 2008

    I have installed the Small Business Edition of SQL Server 2008, and I have created a Microsoft Dynamics NAV database on this SQL Server. However, when trying to locate the server from a pc in the office, it does not find the database. The error message is: "The 192.168.0.7" server cannot be found."...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Error when updating SQL Server 2000 from SQL Server 2005

    Hi, I am using sqlServer 2005 and sqlServer 2000. When i update on sqlServer2000 from sqlServer2005 then following error was occured. Msg 682, Level 22, State 148, Line 1 Internal error. Buffer provided to read column value is too small. Run DBCC CHECKDB to check for any corruption.

    Nileshpatkar825 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