Forum Replies Created

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

  • RE: Move sqlserver to another server

    Try this :

    Install SQLServer B

    launch Query Analyser on server A

    execute the storedproc sp_detach_db <DB_NAME>

    Copy your DB(s) to the new server (not the systems DB)

    launch query analyser on server B

    execute the...

  • RE: installing sql

    Hi,

    It seems that you (the logged account) can't edit the registry.

    Try to install the MSSQL client tools with an account that can edit the registry (such as administrator or...

  • RE: identity column

    You can use TRUNCATE <tablename> to delete all records.

    The identity column value is reset to 1 for the next insertion.

    Claude

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