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.
Author |
Topic |
edyl
Starting Member
35 Posts |
Posted - 2011-06-20 : 17:17:43
|
Hello everyone,There are stored procedure jobs which are scheduled to run every hour. These always send out status emails with a brief description. From the last couple of runs the job is failing with only this error in the email:"Error converting data type varchar to float."Since it only says there is data conversion issue but it doesn't say where, eyeballing through lines of codes on the store procs or running the sql query in the proc one by one is simply not feasible because of the sheer number stored procs I would have to go through. Is there any place where the SQL Server logs these information in some internal log files? Thus i can view it and possibly figure out what column of what table that may be producting that conversion issue. Going just by what's been thrown in the email, it would be like looking for a "needle in the haystack".We are using SQL Server 2008. Any suggestions will be greatly appreciated.Thanks in advance. |
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2011-06-21 : 02:16:27
|
did you try executing the same procedure in query window?? |
|
|
edyl
Starting Member
35 Posts |
Posted - 2011-06-21 : 09:22:11
|
The procedure does a bunch of inserts and it shouldn't happen at any other time than its regular schedule. Down side is that we don't have a Dev env. so that I can run it in that. I was hoping that even thought only part of the message shows up in the email, perhaps the SQL server itself logged the detail error message somewhere. |
|
|
|
|
|