Adbrite

Friday, December 28, 2007

Problem to create an index on a BIT (data type) column (SQL server 2000)

When we try to create on an index to Bit data type column using previous versions (SQL Server 2000) of SQL server it doesn’t display the bit data type columns.











And when we type columns name manually it show the message box “Do you want to delete this index?” then how we create index to bit data type column using SQL server 2000?bit when you notice, to create index using manage indexes property (all task > manage indexes) we can create index to bit data type columns with out any problem.



















And also Good new is SQL server 2005 version you can create an index to bit data type column with out any problem.