I want to disable the identity property on one of my column, can any one
tell me how I can do that from query analyzer, I can do that from Enterprise
Manager but I want to do through query analyzer?

Plz advice

Thanks

Enterprise Manager creates a new table. To, there's no magic involved. Press the "Save change
script" button and you will see what EM does behind your back.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"Rogers" <naissani (AT) hotmail (DOT) com> wrote

Check out SET IDENTITY_INSERT in BOL.

"Rogers" <naissani (AT) hotmail (DOT) com> wrote