Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 create unique clustered index gives msg 3624

Author  Topic 

SudhirBhatnagar
Starting Member

2 Posts

Posted - 2009-05-12 : 17:18:34
All,
I get the following message when trying to create unique clustered index . Any ideas why!! Any help would be greatly appreciated.

Thanks.

Location: sobuild.c:3209

Expression: CompareRow ( rightRec, *m_pSEBindings, keyCnt, *(m_schemaAccess.GetHoBtAccess ()), PAGE_LEAF_LEVEL)

SPID: 177

Process ID: 6160

Msg 3624, Level 20, State 1, Line 110

A system assertion check has failed. Check the SQL Server error log for details. Typically, an assertion failure is caused by a software bug or data corruption. To check for database corruption, consider running DBCC CHECKDB. If you agreed to send dumps to Microsoft during setup, a mini dump will be sent to Microsoft. An update might be available from Microsoft in the latest Service Pack or in a QFE from Technical Support.

Msg 0, Level 20, State 0, Line 0

A severe error occurred on the current command. The results, if any, should be discarded.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-05-12 : 17:35:47
So did you run DBCC CHECKDB?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page

SudhirBhatnagar
Starting Member

2 Posts

Posted - 2009-05-12 : 18:55:32
quote:
Originally posted by tkizer

So did you run DBCC CHECKDB?
No. I will have the customer do that.
Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Thanks very much for you rreply.
I am not able to reproduce this on my instance of SQL Server 2005.

"Let's begin with the premise that everything you've done up until this point is wrong."

Go to Top of Page
   

- Advertisement -