Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • RE: removing the identity property of a column

    In SQL 2000 you could do the following (wont work in SQL 2005)

    ---

    USE [DB_NAME]

    EXEC dbo.sp_configure @configname = 'allow update'

    , @configvalue = '1'

    RECONFIGURE WITH OVERRIDE

    UPDATE dbo.syscolumns

    SET colstat = 0

    WHERE id = object_id('[dbo].[TABLE_NAME]') 

    AND name...

  • RE: Error when changing startup account

    You need to use an account that is set to run as a service

    Best way to accomplish this is to set which account will be used to run the service...

Viewing 2 posts - 1 through 2 (of 2 total)