Auto List Members

In SSMS I have "Auto List Members" and "Parameter Information" turned on for the text editor/all lanuguages but it does not work in the text editor when connected to a SQL Server 2000 DB. Any suggestion would be appreciates.SSMS does not support intellisense for the SQL Editor/TSQL. (as of this time) :)

auto increment

HOW TO GIVE DATATYPE "AUTO INCREMENT" IN SQL SERVER?Add an identity column to your table.|||

Hi Kru,

Select the column whose datatype you want to be auto - increment. In the properties pane, find the IsIdentity property and set it to "Yes". optionally you can also select the Increment Seed i.e. Column value should be incremented by 1 or 2 or so on.

Jay Ho.