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

    ITKE350,840 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:
  • Error installing the client tools for SQL Server 2000 onto an XP desktop

    When attempting to install the client tools for SQL Server 2000 onto an XP desktop, I get an error stating that “A previous program installation created pending file operations on the installation machine. You must restart the computer before running setup.” Rebooting only leads to the same...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Error message in the Copy Database Wizard in SQL Server 2005

    I am attempting to make a copy of a database using the Copy Database Wizard in SQL Server 2005, but I am receiving the following error: TITLE: Copy Database Wizard ------------------------------: The action you attempted to perform on a remote SQL Server instance failed because the action requires...

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server 2005 ‘alter user’

    Hello, I have been trying to run the following instruction in QA use database_name alter user db_user_name with login = [domain\login_name] but keep getting the error Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'login'. I know this method exist in SQL Server 2005, are any of you able...

    Db23290 pointsBadges:
  • Connecting to SQL Server 2005 after installing PowerBuilder

    I have installed PowerBuilder 11.1 and I am trying to access SQL Server 2005 from my system. I use SQL Native Client for connecting to SQL Server 2005, but I am receiving the error, "Could not connect to Data Source". However, I am able to connect to that server using ODBC and SQL Server Management...

    SQL Server Ask the Experts2,585 pointsBadges:
  • How do I write the code to connect an .aspx webform to a MS SQL server and database

    This was done in VS 2008 the web forms are registration and log in forms with aspx controls. I created the database and the tables ( but am having issues with the constraints for 3 columns). I am trying to find out how to connect the 2 and where would I put the code. I am not a programmer and I am...

    Twinkles rules5 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