Re: Column...

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: José Araujo (josea_at_mcrinc.com)
Date: 08/18/04 

Date: Wed, 18 Aug 2004 17:25:30 -0400

Well... I consider that "logically impossible" is not correct.

SQL Server could "scan" the column to look for the max value... it could
just use the identity seed you proposed and let you live with the
consequences.

It might be not possible, but not because it is not logically possible, just
because SQL server doesn't have it implemented (so, it is, indeed,
impossible IN the current SQL version).

BTW: if I knew where in the system tables that information is storage I
would do it...

Thanks, José.

"Anith Sen" <anith@bizdatasolutions.com> wrote in message
news:ekobPYWhEHA.1768@TK2MSFTNGP10.phx.gbl...
> This is logically impossible since SQL Server has no way of knowing if the
> existing values in the column matches the proposed identity seed and/or
> increment.
>
> --
> Anith
>
>

Relevant Pages

  • Re: Migrating from access to sql server 2005
    ... That's too risky, too increment it selve. ... SELECT TOP 1 MyIdCol FROM MyTable ORDER BY MyIdCol DESC ... i have migrated from access to sql server 2005. ... NOT have been converted to IDENTITY columns properly. ...
    (microsoft.public.sqlserver.msde)
  • Re: Column...
    ... This is logically impossible since SQL Server has no way of knowing if the ... existing values in the column matches the proposed identity seed and/or ... increment. ...
    (microsoft.public.sqlserver.programming)
  • Re: AutoIncrement Fields
    ... See IDENTITY property in SQL Server books online. ... Usage is ... CREATE TABLE TESTTABLE(i int IDENTITY(1,1), Name Varchar) ... So the value for i start with 1 and increment by 1 ...
    (microsoft.public.sqlserver.msde)
  • RE: When I use indexed on db1.create index resets
    ... "SQL Server CE allows you to modify the seed and increment values at the ... Subscriber by using the ALTER TABLE table_name ALTER COLUMN column_name ... AutoIdentityRange property at the Publisher is TRUE, you should not modify ...
    (microsoft.public.sqlserver.ce)
  • Re: Tempdb problem
    ... How can I add the SQL Server service account to the "Perform Volume Maintenance Tasks" security policy. ... :-) If you don't have instant file initialization on I would go with maybe 1GB fixed increment. ... Since I need to create a lot of indexes and populate some tables with 60GB of data then I was setting the TempDB to 100GB, ... ALTER DATABASE TempDB MODIFY FILE ...
    (microsoft.public.sqlserver.programming)