• SQL Server Error while creating db from DUMP

    Hi, We get the following error while trying to create a new db from a dump which contains the MDF and LDF files. Appreciate if anyone could let me know on what could be the reason for this error. The operating system returned error 38(Reached the end of the file.) to SQL Server during a read at...

    Vidukarth25 pointsBadges:
  • Error message when connecting SQL Server database to ASP.NET

    I’ve been getting the following message when connecting my SQL Server database to the ASP.NET application: "Login failed because, under default settings, SQL Server 2000 does not allow remote connections." What might this mean?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Error message during database mirroring on SQL Server 2005

    I am trying to begin database mirroring in SQL Server 2005. I have Service Pack 2 installed, and I have three instances running. When I attempt to start mirroring, I receive the error message, “One or more of the server network addresses lacks a fully qualified domain name.” My network...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Error message in Reporting Services on SQL Server

    I am trying to post a report on Reporting Services on SQL Server, but I keep receiving this error message (“salesexpo1” is the name of the table): An error has occurred during report processing. Query execution failed for data set 'rSellingEP_AV'. Invalid object name 'Saleexpo1'. What might...

    SQL Server Ask the Experts2,585 pointsBadges:
  • sql server 2005 slow

    Several times during the day SQL Server 2005 Express is becoming very very slow (actually freezes), even if there was no activitry at all. After restart it is normal again for a couple of hours, then freezes again.

    Vad20 pointsBadges:
  • Error message in Query Analyzer on SQL Server 2005

    I am trying to run the following command in Query Analyzer on SQL Server 2005: use temp alter user [MY-LP79EFIWXO93login_a] with login = [MY-LP79EFIWXO93login_b] However, I keep receiving this error: Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'login'. Why might this be?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Database tables interrupted…..

    Any input at all would be greatly appreciated - All I know is that a companywe provide IT Support to had 4 databases running when the SQL services were shut down on the server. Now the fellow cannot see any of his tables – nothing shows up when he opens SQL, or in his ODBC network connections....

    AndreaF8,000 pointsBadges:
  • Receiving an error in Quality Assurance on SQL Server 2005

    I am trying to run the following command in Quality Assurance on SQL Server 2005: use temp alter user [MY-LP79EFIWXO93login_a] with login = [MY-LP79EFIWXO93login_b] However, I keep receiving this error: Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'login'. Do you have...

    SQL Server Ask the Experts2,585 pointsBadges:
  • problem with sys.endpoints

    Hi, I have ms sql database created in 7.0; I had shift all the data files to a different server where ms sql 2005 is installed. I was able to start sql server from the 7.0 database by specifying the startup parameters. But when I try to connect thru sql mgmt. studio I am getting the "object not...

    Vsskmk5 pointsBadges:
  • db backup

    why does sql bu returns a time out

    Stanja10 pointsBadges:
  • Problems replicating SQL Server 2000 table

    I'm having problems replicating a table that is full text enabled using SQL Server 2000 sp4. When I start the distribution agent I get the following error: Cannot use a CONTAINS or FREETEXT predicate on table 'dbo.proposals' because it is not full-text indexed. I have run sp_fulltext_database...

    Systems Channel ATE15 pointsBadges:
  • Receiving an error consistently in SQL

    I receive the following error constantly in SQL: "Notice: Use of deprecated function sql_query in /var/www/html/includes/sql_layer.php on line 43 Notice: Use of deprecated function sql_fetch_array in /var/www/html/includes/sql_layer.php on line 64" It repeats over and over, and I am not sure how to...

    SQL Server Ask the Experts2,585 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:
  • sp_OACreate is missing

    Hi I'm trying to create a stored procedure to send mail, and 1 line in my SP states: EXEC @hr = sp_OACreate 'CDONTS.NewMail', @MailID OUT But I get an error that sp_OACreate is missing. How it happened I don't know. But how do I fix the problem? Is it possible to recreate sp_OACreate manually?...

    Kowalski5 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'...

    SQL Server Ask the Experts2,585 pointsBadges:
  • failure to register an SPN

    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:
  • Dealing with a hyperactive SQL Server

    On occassion, our SQL Server goes hyper - 100% disk activity with I/O queues. It happens only once a year, lasts for a couple of days and then stops. We have our database administration staff look at it, but we have no real idea what the cause is. Can you suggest a direction or idea?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Managing a sytem with both SQL Server 2000 and SQL Server 2005

    I am the systems administrator on a system that has both SQL Server 2000 and SQL Server 2005 running on it. When they are starting up, the system works fine, but when we reboot the server, the 2 SQL Servers appear to fight each other for resources and the system crashes. This does not occur every...

    SQL Server Ask the Experts2,585 pointsBadges:
  • I am using SQL Server 2005, I keep receiving the following error message:The following error keeps occurring every 30 minutes in error logs. “The specified user account has expired”.

    I am using SQL Server 2005, I keep receiving the following error message: The following error keeps occurring every 30 minutes in error logs. "The specified user account has expired". Has anyone ever come across this error message?

    Tizi30 pointsBadges:
  • 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:

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