• You are right you can't set the Identity Property to true.

    You can set the identity property to false by simply going into design mode and set the property to false.

    I just wanted to know how to do it in T-SQL.

    I guess I could find out how to do so by setting up a trace.

    Thank you.

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/