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
 SQL Server 2000 Forums
 Transact-SQL (2000)
 OPENQUERY Not Failing on Overflow error

Author  Topic 

dba723
Starting Member

1 Post

Posted - 2009-05-06 : 07:16:44
I've got an OPENQUERY query that I'm running. Part of its syntax is to convert a string field to INT. There is one string when converted is actually BIGINT. If I run the query locally on that server I get the "overflow" error. If I run it as OPENQUERY I'm getting no errors.

What the heck is up with that?

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-05-07 : 02:00:53
What are the differences in SET options?



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page
   

- Advertisement -