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 stop it. Do you have any advice?

Answer Question   |  July 28, 2008  3:46 PM
SQL, SQL Server errors

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 [...]

Answer Question   |  July 28, 2008  9:41 AM
Database programming, NULL values, Primary keys, SQL Server errors, VARCHAR, Visual Studio, Visual Studio 2008

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? (Note [...]

Answer Question   |  July 23, 2008  11:24 AM
sp_OACreate, SQL Server 2000, SQL Server errors, SQL stored procedures, Stored Procedures, Windows XP

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 error, and I have tried a different PC [...]

Answer Question   |  July 22, 2008  8:10 PM
SQL Server 2000, SQL Server errors, SQL Server installation, Windows XP

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 2000 SP4 resolve this issue?

Answer Question   |  July 31, 2008  7:58 PM
SQL Server 2000, SQL Server 2000 SP3, SQL Server 2000 SP4, SQL Server errors, SQL Server upgrades

SQL Server 2000 error in log: WARNING: EC 5c3320c0, 9 waited 300 sec. on latch 44173b2c. Not a BUF latch.
I am seeing this error weekly in the sql server log with associated performance hit: WARNING: EC 5c3320c0, 9 waited 300 sec. on latch 44173b2c. Not a BUF latch. Has anyone resolved this error?

Answer Question   |  November 4, 2008  9:02 PM
SQL Server 2000, SQL Server errors, SQL Server logs, SQL Server performance

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 [...]

Answer Question   |  July 17, 2008  1:47 PM
Server errorlog, SQL Server 2005, SQL Server errors, VS 2008

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 ERROR_MESSAGE(), ERROR_NUMBER() END CATCH Why would an error from this statement not be captured by the catch [...]

Answer Question   |  July 16, 2008  6:52 PM
CSV, SQL, SQL Server errors

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: 0×2098, state: 15. Failure to register an SPN may cause integrated authentication to fall [...]

Answer Question   |  July 15, 2008  11:50 AM
SPN, SQL Server errors

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 [...]

Answer Question   |  September 9, 2008  1:50 PM
SQL Server 2005, SQL Server errors

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?

Answer Question   |  July 2, 2008  7:31 PM
SQL Server, SQL Server errors, SQL Server performance

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 [...]

Answer Question   |  June 30, 2008  6:42 PM
SQL Server 2000, SQL Server 2005, SQL Server errors, SQL Server synchronization

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/…..”

Answer Question   |  June 22, 2008  2:44 PM
SQL Server 2005, SQL Server errors

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?

Answer Question   |  June 23, 2008  2:42 PM
SQL Server 2005, SQL Server errors

Restoring SQL Server 2000 database
I want to restore a database in SQL Server 2000, using a specific name. I tried restoring it using Enterprise Manager, but kept getting the error ‘You must select a backup set to restore’. Why is this and how do I resolve it?

Answer Question   |  June 5, 2008  10:09 AM
SQL Server 2000, SQL Server backup, SQL Server Enterprise Manager, SQL Server errors

Index Tuning Wizard shows error occurred while executing SQL statement but I can’t find the problem
I am facing a strange problem while using the Index Tuning Wizard (ITW) in SQL Server 2000. It shows error occurred while executing a SQL statement. I’ve checked every thing like trace is okay, as they show no problem with SQL Server 2005. Kindly give me some solution, URGENT.

Answer Question   |  September 28, 2008  3:36 AM
Index Performance, Index Tuning Wizard, ITW, SQL, SQL Server errors, SQL Server performance tuning

Error when trying to restore SQL Server database backup file
We have a SQL Server database backup file with the extension .bak. In the new server we created a database with the same name. We are trying to restore the database with the backup file, but we’re unable to do that. When we try to add the backup file, SQL Server raises error that we [...]

Answer Question   |  August 10, 2010  2:55 AM
SQL Server backup and restore, SQL Server errors

SQL Server error message ‘Could not find the index entry for RID ’1628000000a412030044160000869a0000040000′ in the database
I’m getting the error ‘Could not find the index entry for RID ’1628000000a412030044160000869a0000040000′ in the database. The table is a very big table and lots of transactions are happening every minute. Please let me know what would be the possible cause and solution for this problem.

Answer Question   |  May 7, 2008  4:21 PM
Index, SQL Server, SQL Server errors

Error when upgrading SQL Server 2000 to SQL Server 2005
I am upgrading SQL Server from 2000 to 2005. While upgrading I have received the below mentioned error. Kindly review and advise me on this. By the way, I have sufficient disk space on my server. “TITLE: Microsoft SQL Server 2005 Setup SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]Database ‘msdb’ [...]

Answer Question   |  May 7, 2008  3:29 PM
SQL Server errors, SQL Server upgrades, Upgrades

Query error when using application role with ADO connection
I am developing an application with an ADO connection. I need to run a query on two different databases on the same server using an application role. When I run the query I get an error domainusername does not have a logon on database (referring to the second database). Is there any way around it? [...]

Answer Question   |  May 7, 2008  3:23 PM
ADO, Application development, Domain, SQL Server development, SQL Server errors