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.

 All Forums
 Site Related Forums
 Article Discussion
 Data conversion error

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.
Go to Top of Page
   

- Advertisement -