Forum Replies Created

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

  • RE: How to backup,copy and restore?

    You can also combine step 2 and 3.

    You then will get something like this

    declare @lastbackupID char(10)

    declare @backupname char(255)

    -- Find the latest backup of [Production database]

    set @lastbackupID = (select max(media_set_id) as...

  • RE: Can we change the collation in SQL 2005..?

    You can find this in the books online section "How to: Install SQL Server 2005 from the Command Prompt "

    You can only change the server collation settings if you do...

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