Setting SEED value for a existing column

From: Soura (Soura_at_discussions.microsoft.com)
Date: 11/26/04

  • Next message: royHe: "Error 21085: The retention period" 
    Date: Fri, 26 Nov 2004 07:01:05 -0800

    hi,

    I need to set a new SEED value to an existing identity column through Query.
    I used the following
    DBCC CHECKIDENT (jobs, RESEED, 30)
    but Enterprise Manager still shows the old SEED value.
    Can u help me?

    Thanks
    Soura

  • Next message: royHe: "Error 21085: The retention period"

    Relevant Pages

    • Re: Putting a Cap on QZDASOINIT CPU % ?
      ... performance for the JDE users - particularly when the query is not ... couple of QZDASOINIT jobs to grab 25% CPU each. ... such a cpu consumption per job for an sql query; ...
      (comp.sys.ibm.as400.misc)
    • Re: Putting a Cap on QZDASOINIT CPU % ?
      ... performance for the JDE users - particularly when the query is not ... couple of QZDASOINIT jobs to grab 25% CPU each. ... such a cpu consumption per job for an sql query; ... senza sapere, senza potere, senza con amor volere" ...
      (comp.sys.ibm.as400.misc)
    • Re: The query is too complex or cant open anymore databases
      ... jobs per day. ... > record for each employee + each date of the current pay period, ... >> Perhaps I can do a union query to arrive at a normal table structure? ... >>> each week, but a much simpler set of calculations, and the issue of ...
      (microsoft.public.access.queries)
    • Re: Display Counts of records per day
      ... [Contract Jobs] ... Running your Query gave me what looked like correct totals. ... FROM Bookings ... FROM [Contract Jobs] ...
      (microsoft.public.access.queries)
    • Re: Source control integration with MSSQL 2000.
      ... I tested sqlXpress about a year or so ago. ... query plans, which was something I couldn't do without. ... > using both Query Analyzer and Enterprise Manager. ... > - Their website says "Replaces most features of Microsoft® Query Analyser ...
      (microsoft.public.sqlserver.server)
    • Quantcast