Disable Identity

From: "Rogers" <naissani@xxxxxxxxxxx>
Date: Fri, 14 Sep 2007 17:54:51 -0400

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

.

Follow-Ups:
- Re: Disable Identity
  - From: Mike C#

Prev by Date: Re: Why do I have to enable File and Printer sharing to connect through the XP firewall?
Next by Date: Re: Why do I have to enable File and Printer sharing to connect through the XP firewall?
Previous by thread: Why do I have to enable File and Printer sharing to connect through the XP firewall?
Next by thread: Re: Disable Identity
Index(es):
- Date
- Thread

Relevant Pages

Re: Cannot edit table data using Enterprise Manager
... The point of using Query Analyzer is that you write the ... they could have had the SQL written and been done with it! ... change or insert some words to data string using Replace function is ... Manager wasn't designed to be a data entry tool. ...
(microsoft.public.sqlserver.tools)
Re: Error Trying to VIew data in table
... I tried this and I am able to retrieve data via the Query Analyzer. ... know it is Enterprise manager? ... > Manager, or more deeply rooted. ... >> When I try to view the data in a table on my SQL SErver 2000 Enterprise ...
(microsoft.public.sqlserver.server)
Re: Row count of large table
... Pro SQL Server 2000 Database Design ... >> Doing this through Query Analyzer if you do select count, ... > way OTHER than Enterprise manager? ...
(microsoft.public.sqlserver.programming)
User Log
... (both via applicationd, query analyzer and enterprise ...
(microsoft.public.sqlserver.security)
How to grant read/write permission to a user using query analyzer
... permission using query analyzer and not through enterprise ... manager. ...
(microsoft.public.sqlserver.server)