Forum Discussion

Copper Contributor

Jul 12, 2024

SQL job keeps failing!

I have a SQL where jobs keep failing due to index being already present. [SQLSTATE 01000] (Message 50000) Creating CRM_CreateChangeCompany [SQLSTATE 01000] (Message 50000) if not exists (select *...

olafhelper

Bronze Contributor

Jul 15, 2024

[SQLSTATE 01000] (Message 50000)

adityakumar1176 , error 50000 and above are user code raised error, so review your code.

See RAISERROR (Transact-SQL) - SQL Server | Microsoft Learn => msg_id = 50000