Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: SQL change properties error

    Use sp_attach_db in Query Analyzer rather than using Enterprise Manager;

    EXEC sp_detach_db 'myDB'

    go

    EXEC sp_attach_db 'myDB'

    ,'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs.mdf'

    ,'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs_log.ldf'

    go

Viewing post 1 (of 1 total)