I have an extended stored procedure which converts two integers into a
float. It works on one server but it will not work on another. It
always returns null when I run it on one server and it works fine on
the other.
Any ideas as to what might cause this?Wild guess:
Regional settings for the SQL Server service account?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<david.blunkell@.zeacom.com> wrote in message
news:53dd2195-d333-4182-934a-dd15a3404c5f@.a35g2000prf.googlegroups.com...
>I have an extended stored procedure which converts two integers into a
> float. It works on one server but it will not work on another. It
> always returns null when I run it on one server and it works fine on
> the other.
> Any ideas as to what might cause this?
Showing posts with label converts. Show all posts
Showing posts with label converts. Show all posts
Monday, March 19, 2012
Extended stored procedure doesn't work (SQL Server 2005)
I have an extended stored procedure which converts two integers into a
float. It works on one server but it will not work on another. It
always returns null when I run it on one server and it works fine on
the other.
Any ideas as to what might cause this?Wild guess:
Regional settings for the SQL Server service account?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<david.blunkell@.zeacom.com> wrote in message
news:53dd2195-d333-4182-934a-dd15a3404c5f@.a35g2000prf.googlegroups.com...
>I have an extended stored procedure which converts two integers into a
> float. It works on one server but it will not work on another. It
> always returns null when I run it on one server and it works fine on
> the other.
> Any ideas as to what might cause this?
float. It works on one server but it will not work on another. It
always returns null when I run it on one server and it works fine on
the other.
Any ideas as to what might cause this?Wild guess:
Regional settings for the SQL Server service account?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<david.blunkell@.zeacom.com> wrote in message
news:53dd2195-d333-4182-934a-dd15a3404c5f@.a35g2000prf.googlegroups.com...
>I have an extended stored procedure which converts two integers into a
> float. It works on one server but it will not work on another. It
> always returns null when I run it on one server and it works fine on
> the other.
> Any ideas as to what might cause this?
Subscribe to:
Posts (Atom)