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...
Answer Question
| Jul 24 2008 9:41 AM GMT
| asked by
SrimanBenivolent
VARCHAR, NULL values, Primary keys
sp_OACreate is missing
HiI'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...
View Answer
| Jul 23 2008 11:24 AM GMT
| asked by
Kowalski
sp_OACreate, Stored procedures, SQL Server errors
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...
View Answer
| Jul 22 2008 8:10 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server 2000, SQL Server installation, SQL Server errors
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...
View Answer
| Jul 22 2008 7:58 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server 2000, SQL Server 2000 SP4, 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?
View Answer
| Jul 18 2008 9:02 PM GMT
| asked by
Ftornoe
SQL Server 2000, SQL Server errors, SQL Server logs
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...
View Answer
| Jul 17 2008 1:47 PM GMT
| asked by
Twinkles rules
Server errorlog, SQL Server errors, VS 2008
Catching an uncaptured error in SQL
This is a batch of SQL code I’ve been using:BEGIN TRYbeginBULK INSERT DBXMRPAS2.dbo.[STG_drive] FROM '\Wdmyitpxmdev1xmmsbcpcsvfile20080715drive.200807151100.extracting' WITH ( MAXERRORS =1000, FIELDTERMINATOR = '^', ROWTERMINATOR = '|n' )endEND TRYBEGIN CATCH ...
View Answer
| Jul 15 2008 6:52 PM GMT
| asked by
SQL Server Ask the Experts
SQL, CSV, SQL Server errors
failure to register an SPN
Event Type: InformationEvent Source: MSSQLSERVEREvent Category: (2)Event ID: 26037Date: 07/07/2008Time: 07:37:40User: N/AComputer: Computer nameDescription:The SQL Network Interface library could not register the Service Principal Name(SPN) for the SQL Server service. Error: 0x2098, state: 15....
View Answer
| Jul 15 2008 11:50 AM GMT
| asked by
Tiz
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 join takes...
Answer Question
| Jul 10 2008 1:50 PM GMT
| asked by
Dpaproskijr
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?
View Answer
| Jun 30 2008 7:31 PM GMT
| asked by
SQL Server Ask the Experts
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 every...
View Answer
| Jun 27 2008 6:42 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server 2000, SQL Server 2005, SQL Server errors
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/....."
View Answer
| Jun 20 2008 2:44 PM GMT
| asked by
Tizi
SQL Server errors, SQL Server 2005
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?
View Answer
| Jun 20 2008 2:42 PM GMT
| asked by
Tizi
SQL Server errors, SQL Server 2005
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?
View Answer
| Jun 5 2008 10:09 AM GMT
| asked by
Gini 2
SQL Server 2000, SQL Server backup, SQL Server Enterprise Manager
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
| May 14 2008 3:36 AM GMT
| asked by
SQL Server Ask the Experts
SQL Server performance tuning, Index Performance, SQL
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 have no access...
View Answer
| May 14 2008 2:55 AM GMT
| asked by
SQL Server Ask the Experts
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.
View Answer
| May 7 2008 4:21 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server, Index, SQL Server errors
Can’t Install SQL Server 2000 on Window XP SP2
I try to install SQL Server 2000 on Window XP SP2, but there is an error message mean "OS not support.". What should I do? How can I install SQL Server 2000 on Window XP SP2? Please, give me the best and detail answer. Thanks.
View Answer
| May 2 2008 4:29 AM GMT
| asked by
Yoyo
SQL Server 2000, SQL Server errors, Windows XP
New user permission to SQL server
Hi all,I have created a new local user on the sql server. Now when i access the sql enterprise server, it fails and gives error as " login failed to user, check SQL registration properties.Thank you.
View Answer
| Apr 13 2008 6:34 AM GMT
| asked by
Mutallib
SQL Server, SQL Server errors, SQL registration properties
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...
View Answer
| Apr 10 2008 2:12 AM GMT
| asked by
SQL Server Ask the Experts
SQL Server errors, Backup & recovery, SQL Server backup
