I am trying to create a table with a column of type 'float(24)' in SQL Server 2000. When I do that via Enterprise Manager, the Precision field is grayed out, so I cannot change it from the default value of 53. I tried to create a table running a script like this:
CREATE TABLE [dbo].[MyTable] (
[X] [float(24)] NULL
) ON [PRIMARY]
but I am getting an error "Cannot find data type float(24).". So I have no idea, how the precision can be defined for this data type. Looks like a simple issue, and because of this it's even more frustrating. Can anybody enlighten me, please?