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 |
|
hemghe
Starting Member
1 Post |
 Posted - 2011-06-08 : 06:33:04
|
| Hi,I am getting data conversion error while selecting from view in SQL Server 2008. i want to capture these error and need to put those records which are giving data conversion error into a error file. Can anybody help me? |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2011-06-08 : 08:08:01
|
| you need to look at the underlying SQL behind the view, break it into simple pieces and look at the data being returned. somewhere you have a data conversion function being invoked which is operting on improper data ....lie a date fucntion on non-date data. |
 |
|
|
|
|
|
Data conversion error