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

I also test with a SQL server 2000 database and got same result. So, my
question is, can you set the identity property when you create it in
designer or you just cannot change the identity property after you save
the whole table? Is your account a DBO on the database?


Luke

.

Relevant Pages

  • Re: archieving and deleting SQL 2000 table
    ... you don't need IDENTITY property on the database you are archiving into. ... Vyas, MVP (SQL Server) ...
    (microsoft.public.sqlserver.security)
  • VS2005 DB Tools cant set Identity prop for Primary Key columns?
    ... Instead of opening up SQL Enterprise Tools, ... just used the VS2005 database tools and created a new table. ... "The identity property can be set only for a column that disallows null ...
    (microsoft.public.vsnet.ide)
  • Re: SqlServer 2005: Importing Data: Idenitity fields getting made into non-identities
    ... SqlServer database into another the identity fields get switched off ... Seems like the way to go is to click Edit SQL and add the IDENTITY ... I hope not all of them are using the IDENTITY property, ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Re: Primary key in MSDE has to be a random number??!
    ... >middle of the database. ... >> Maybe you are looking for the identity property which is ... >> typically used to generate unique identification numbers. ... >> You can find more information in books online under the ...
    (microsoft.public.sqlserver.setup)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
Quantcast