Avatar of T-Virus
Flag for Netherlands

asked on 

Error Tracking in Management Studio

Hi all,

Basically I would like to understand a bit more about how to track and interpret
Error messages in SQL Management Studio.

Specially in this case&
Ran a sql query which worked day by day perfectly fine
Mysteriously since yesterday I am facing this error message

Msg 8114, Level 16, State 5, Line 1
Error converting data type nvarchar to numeric.

So there is a converting issue which werent there a view hours ago.
I have 80 columns in the sql query how can I easily find out which one it is and
What the reason for these change was?

Thanks for your Help!
Microsoft SQL Server 2005

Avatar of undefined
Last Comment

8/22/2022 - Mon