SQL Server error

Question

I am getting a fatal error on following code.

exec [sp_ExternalApp_UPDATEUSER] 'ZZZ', XXXXX','DDDDD','DDDFFDD','EREE', 'EREWWWWW',1,1,'[email protected]','DEFF','XXXX','DDDD'

Following error occurred:

Location: memilb.cpp:1624
Expression: pilb->m_cRef == 0
SPID: 79
Process ID: 2256

Msg 3624, Level 20, State 1, Procedure sp_ExternalApp_UPDATEUSER, Line 32 A system assertion check has failed. Check the SQL Server error log for details Msg 0, Level 20, State 0, Line 0 A severe error occurred on the current command. The results, if any, should be discarded.

Answer 1

Like the message said, check your error log, there might be more detail in there..what does this proc do does it use *sp_OACreate* or calls *xp_cmdshell*? Post the proc code

Answer 2

You might want to check the database for corruption. Try

DBCC CHECKDB

(before doing so, read the documentation on that command! See http://msdn.microsoft.com/en-us/library/ms176064.aspx )

Answer 3

Thank you

I got the solution. I have used UPPER() function. As I removed that function, my problem solved