• I am using SQL Server 2005 and the following error keeps being reported in the Domain Controller Logs:”There are multiple accounts with name MSSQLSvc/…..”

    I am using SQL Server 2005 and the following error keeps being reported in the Domain Controller Logs: "There are multiple accounts with name MSSQLSvc/....."

    Tizi30 pointsBadges:
  • SQL2000 linked to SQL2005 doesn’t allow TRAN selects

    Hi all, I have a SQL2000 machine that has a linked server that runs SQL2005 (before this was a SQL2000) When the systems were both SQL2000 from ServerA it was possible to run: BEGIN TRAN SELECT * FROM MYSVR.MYBD.DBO.MYTABLE COMMIT TRAN After the ServerB has been upgraded to SQl2005 the code above...

    alessandro.panzetta9,725 pointsBadges:
  • 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.

    ITKE413,620 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:

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.

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

Following