• SQL Server Express 2005 freezes

    I have a server machine running Windows Server 2003 and SQL Server Express 2005 for a client-server application. All clients machines access the server through a router fine with good response time but if the internet connection fails suddenly the SQL Server freeze. Any SQL command takes a long...

    Navegante21225 pointsBadges:
  • Slow outer JOIN after delete rows

    Hi, I've tried this on two installations of SQL Server 2005 service pack 2. If I delete rows of a table, an outer join on the empty table is extremely slow...if I truncate it's ok, if I delete with the tablock hint it's ok. Any ideas why? The code to reproduce this follows, the outer join takes...

    dpaproskijr5 pointsBadges:
  • Error In SQL SERVER DataBase

    am trying to insert four varchar(50) values in a table which is with a primarykey column id_number. i didnt check : "True" to the null field . so it should not allow null values in table. but while am trying . it allows null values. including primary key column. how is possible ? pls help me. i am...

    SrimanBenivolent5 pointsBadges:
  • Memory could not be written

    I keep getting the following error when I try to Close/Modify the DTS package or close the SQL 2000 (by x-out) on the remote workstation which has Windows XP OS. Application popup: mmc.exe - Application Error : The instruction at "0x4173d22a" referenced memory at "0x02241e90". The memory could not...

    Bjet55 pointsBadges:
  • Invalid String or buffer length ERROR in SQL Server 2005

    I am trying to connect to SQL Server 2005 express edition using JDBCODBC bridge driver. I have succesfuly configured the data source but when I use DriverManager.getConnection("jdbc:odbc:sql")-->SQL is the data source name. I catch this Exception. Many thanks in advance.

    1023965 pointsBadges:
  • Failure to register an SPN in SQL Server

    Event Type: Information Event Source: MSSQLSERVER Event Category: (2) Event ID: 26037 Date: 07/07/2008 Time: 07:37:40 User: N/A Computer: Computer name Description: The SQL Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x2098,...

    Tiz5 pointsBadges:
  • SQL Server 7 database restore

    I'm working with SQL Server 7 and I made a backup from a Database and I need to restore it, but this error appear: "The RAID set for database is missing member number 1". What can I do?

    Claudiofuentes15 pointsBadges:
  • Catching an uncaptured error in SQL

    This is a batch of SQL code I’ve been using: BEGIN TRY begin BULK INSERT DBXMRPAS2.dbo.[STG_drive] FROM '\Wdmyitpxmdev1xmmsbcpcsvfile20080715drive.200807151100.extracting' WITH ( MAXERRORS =1000, FIELDTERMINATOR = '^', ROWTERMINATOR = '|n' ) end END TRY BEGIN CATCH SELECT 'Error Caught' SELECT...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Installing SP4 for SQL 2000 Error: 50042

    When I try to instal SP4 for SQL Server 200 with the Cyrillic Collation, the install crashes unexpectedly with no on screen errors. In the log it says "GetLastError returned: 50042" which I understand is related to the collation. Is there a way to fix this or perhaps a workaround?

    Ykhutch5 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 datatype numeric!). How can I find the exact point (command)...

    fbellos35 pointsBadges:
  • (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53

    Problem: SQL SERVER is up and the instance connect is running. All required ports on Firewall is open/ also try to disable Firewall but no success. TCP/IP protocol is ENABLE.  SQL SERVER port is by Default 1433. Also try this: The problem is the Instance name from the client is not resolved, to do...

    Safekom33330 pointsBadges:
  • Error when restoring a .bak file in SQL Server

    I’m having a problem restoring a .bak file in SQL Server. The .bak file is fine and good. But when I restore it, I get an error. It says " TITLE: Restore failed for Server <servername>(Microsoft.SqlServer.Smo) ------------------------------ ADDITIONAL INFORMATION:...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Instance specific error when connecting to SQL Server

    What is instance specific error? It is occuring while connecting to SQL Server  ... how can i fix this error?

    FAIZAHAFEEZ5 pointsBadges:
  • Trying to get rid of “divide by zero” error message using SQL Server 2008

    In SQL Server 2008, I keep receiving this error message: Msg 8134, Level 16, State 1, Line 1 Divide by zero error encountered. Now, this is more of a general question but what is the best way to write SQL code so this message will never appear again.

    ITKE352,420 pointsBadges:
  • Link Oracle 10g with SQL Server problem

    I have created a link between our Oracle DB and SQL server db It was successfully created and I was able to select data from oracle table using SQL Server. Then I have created a view in SQL Server using this link to read from Oracle, the view was created: create view dah_test as ( SELECT count(*)...

    Kmadani35 pointsBadges:
  • Errors while attempting the mirroring process in SQL Server 2005

    I am using SQL Server 2005 Enterprise Edition, and I’m having a problem beginning the mirroring process. I am receiving the error messages: “Alter failed for Database 'db_muthu'. (Microsoft.SqlServer.Smo)” “An exception occurred while executing a Transact-SQL statement or batch....

    SQL Server Ask the Experts2,585 pointsBadges:
  • Lacking a FQDN during database mirroring on SQL Server 2005

    I am trying to work with database mirroring on SQL Server 2005, and I keep receiving the error message, “One or more of the server network addresses lacks a fully qualified domain name (FQDN). Specify the FQDN for each server, and click Start Mirroring again.” I know that the syntax for a...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Installing SQL Server 2000 on Microsoft Windows XP

    I am attempting to install SQL Server 2000 on Microsoft Windows XP, but I keep receiving this error message: “Microsoft SQL Server 2000 Enterprise Edition server component is not supported on this operating system." What steps can I take to get rid of this message?

    SQL Server Ask the Experts2,585 pointsBadges:
  • On Error Resume Next SQL Server 2005

    Is there to achieve On Error Resume Next? insert into table1 select top 1000 columnname from table2 It should continue inserting the next record even if there is an error. It should not stop the execution. It should simply skip the errors. Thanks in advance.

    Jsql155 pointsBadges:
  • Upgrading from SQL Server 2000 SP3 to SQL Server 2000 SP4

    We have SQL Server 2000 SP3 running on Windows 2003 Server. Every week, after running our optimization and integrity checks on Sunday, we get this error: Time out occurred while waiting for buffer latch type 2... This happens several hours into the day every Monday. Would upgrading to SQL Server...

    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