as I said, it cannot be done until database is bought online.:w00t:

Two ways to do this, either:

ALTER DATABASE currentname MODIFY NAME = Newname (renames existing db)

to change file names

alter database yourdb set offline

alter database MODIFY FILE ( NAME =...

good for you, relax and enjoy!

the above mistake reminds me of my early days in cobol batch programming and the structured programming techniques we were taught. Above structure was called...

@ Gail.

Grrrrr. even with an edit you beat me to the punch. 🙂 I thought you were taking a break?

You have opened the cursor and then gone into a loop which you will never break out of because you are not fetching the next record in the cursor

try this

declare...

The search criteria on the where clause is used by SQL to determine optimum plan, not the select list.

Post your create table script, sample values and the execution plan.

Ahh, language settings, is that query 1st and 2nd May or 5th Jan to 5th Feb?

Former I presume. Same arguments still apply.

the table contains 500,000 rows? If your distribution of data was even as your description suggests it would be then I would expect your query to return about 40,000 rows...

MS already supply a script to do just this. google sp_help_revlogin

ours are on physical by design.

you won't be able to update it until the failover database comes online, so make it part of your failover procedure to correct the dbowner before the app is connected...

why not take orphaned users out of the equation and use sp_help_revlogin to synch the sids for the logins?

Run the following and then cut and paste the results into another window and run it

select 'alter database ['+name+'] set recovery full' from sys.sysdatabses where dbid > 4

No

If this is not possible, what is...

maybe the amount of data in your database is growing and therefore the backups are taking longer?

What do you call slow?