Ok Thanks for your help

Balavenkatesh

My question is, is there any query to find out the current status of the identity column. whether the identity_insert is on or off

Bala

Hi

It shows as list of tables and their identity columns.

My quentions is if i set the identity column as allow insert explicitly. After that how can i...

Hi One more clarifications

Is there any query to find what is the status of that identity column in the table whether it is identity_insert on / off status.

Regards,

Bala

Hi,

Now it is working. Thanks for your help

Regards,

S.balavenkatesh

I tried in SQL 2000 version. But it is not working.

Can you please send in sql 2000 version query.

Bala

How to find out how many tables were having identity column.

Is it simple query to find out all the table name

Regards,

S.Balavenkatesh

Thanks for your support

Balavenkatesh

Thanks Michael for your suggestion.

I'll try to convince the customers.

Regards

Bala

Thanks Jeff.

But i need to store them as well in the primary key column.

Thanks and Regards

Bala

I'm working in one migration from Oracle to SQL server and the Oracle has this feature and teh customer wants in SQL Server Also.

Any solution to this.

Yes. It should be separate item

Hi,

Thanks for your help. It works for ('Bala','BalA')

But it is failed on tailing white space on the values ('Bala ')

Regards,

S.balavenkatesh

Hi

Now i use SQL_Latin1_General_CP1_CI_AS collation settings.

It works for white space before the values. (Eg.' Bala')

It shows error on when i insert like this ('Bala...

Also I need to have "Axa" and "AxA" treated as two separate rows in the primary key