RE: VS2005 DB Tools can't set Identity prop for Primary Key columns?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hello,

I tried your steps with a SQL server 2005 database instance, after create
such a table and save it, I can expand the Identity Specification and set
property "Is Identity" to true. Did you also connect to a SQL server 2005
database or others?

Luke

.

Relevant Pages

  • Re: VS2005 DB Tools cant set Identity prop for Primary Key columns?
    ... I connected to a SQL Server 2000 Standard Edition instance on the local ... > I tried your steps with a SQL server 2005 database instance, ... > such a table and save it, I can expand the Identity Specification and set ...
    (microsoft.public.vsnet.ide)
  • Re: List availalbe SQL Servers?
    ... and definitely with 2008 in future) to be able to create and connect to a new database using a selectable database instance. ... This document specifies the SQL Server Resolution Protocol, ...
    (borland.public.delphi.database.ado)
  • Re: multiple instances behind a firewall
    ... the other database instance, but how would I create a SQL Server registration ... "Wayne Snyder" wrote: ... > Wayne Snyder, MCDBA, SQL Server MVP ... My firewall software designates an instance on one ...
    (microsoft.public.sqlserver.server)
  • SQL Server 2005 Installation Procedures wSQL Server 2000
    ... I have a SQL Server 2000 database instance that was set up with the Standard ... install a new SQL Server 2005 no-default instance on the server. ...
    (microsoft.public.sqlserver.server)
  • Migrating the WSUS database from a Windows Internal Database instance to a SQL Server 2005 instance
    ... I am planning to migrate the WSUS database from a Windows Internal ... Database instance to a SQL Server 2005 instance on a remote server. ... The FE machine account should be listed as a login on the sql server ...
    (microsoft.public.sqlserver.security)