create index error

Hi
I am trying to create an index on a large database (~8GB). SQL Server comes
back with error: 3624, Level 20, State 1.
Can someone please decipher this error for me?
Many thanks in advance.
AkzI didn't find 3624 in the sysmessages table. What is the actual error messag
e?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Akz" <Akz@.discussions.microsoft.com> wrote in message
news:897FA05B-5963-4D71-9AEE-153F58D53C5D@.microsoft.com...
> Hi
> I am trying to create an index on a large database (~8GB). SQL Server com
es
> back with error: 3624, Level 20, State 1.
> Can someone please decipher this error for me?
> Many thanks in advance.
> Akz|||The 3624 is: "A system assertion check has failed. Check the SQL Server
error log for details."
You need to search your errorlog to find which assertion was fired. If you
could provide this assertion, then we probably will know better why index
creation failed.
Stephen Jiang [ MSFT]
Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Akz" <Akz@.discussions.microsoft.com> wrote in message
news:897FA05B-5963-4D71-9AEE-153F58D53C5D@.microsoft.com...
> Hi
> I am trying to create an index on a large database (~8GB). SQL Server
comes
> back with error: 3624, Level 20, State 1.
> Can someone please decipher this error for me?
> Many thanks in advance.
> Akz|||The error log show the following message:
Faild Assertion ='m_SizeRec>0 && m_SizeRec<=MAXDATAROW'
I forgot to mention that I have two files in the primary filegroup because
of the size of my db. Could this have anything to do with my error?
Many thanks
"Stephen Yuan Jiang [MSFT]" wrote:

> The 3624 is: "A system assertion check has failed. Check the SQL Server
> error log for details."
> You need to search your errorlog to find which assertion was fired. If yo
u
> could provide this assertion, then we probably will know better why index
> creation failed.
> Stephen Jiang [ MSFT]
> Microsoft SQL Server Storage Engine
> This posting is provided "AS IS" with no warranties, and confers no rights
.
>
>
> "Akz" <Akz@.discussions.microsoft.com> wrote in message
> news:897FA05B-5963-4D71-9AEE-153F58D53C5D@.microsoft.com...
> comes
>
>