SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 SS_DATA_TYPE and Integer Fields
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Ask SQLTeam Question

0 Posts

Posted - 03/02/2005 :  07:46:14  Show Profile  Visit AskSQLTeam's Homepage  Reply with Quote
Corey writes "I have SQL Server 2000 installed on two different servers. I assume they were both installed the same way but I can't guarantee that.

On one server if I create an integer field in a table and look at the field definition using sp_columns the SS_DATA_TYPE is 38. On the other server if I do the same thing the new interger field shows up with a SS_DATA_TYPE value of 56.

I am using Hyperion Intelligence (fromerly Brio) to connect to this data and the values with the SS_DATA_TYPE value 38 get interpreted incorrectly.

Is the SS_DATA_TYPE a varable that can be set somewhere? I need to have it default to 56 for new integer fields.


Most Valuable Yak

15731 Posts

Posted - 03/02/2005 :  07:48:23  Show Profile  Visit robvolk's Homepage  Reply with Quote
Interestingly enough, I cannot find a type value of 38 in the SQL Server systypes table, which leads me to believe it could be a user-defined type. Regardless, this value cannot be changed, and if it were it would cause problems with SQL Server.

I'd suggest contacting Hyperion to see if they have a new driver, and to make them aware of the issue.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000