- what isolation level are you using?

- also, I am presuming your sure that this is an exclusive lock not an index lock?

- the optimizer will lock objects if it...

Hi Jeff and David,

Nice to know that I'm not "all by my-seellllllf"

your comments have been both thought and laughter (thanks Jeff 🙂 provoking.

Carlton..

Andys right, however this may result in you having to set up mirroring again.

a few q's:

1. whats status is the mirror DB in?

2. also how is your mirroring configured? do...

I disagree that sp_helpserver is "more correct".

sp_helpserver gives your more info but in this case we are only after the server name.

Carlton..

Are you sure that none of the conditions in the error message are true?

what happens if you set mirroring up with different login names?

Carlton..

FROM BOL:

------------------------------

Although the @@SERVERNAME function and the SERVERNAME property of SERVERPROPERTY function may return strings with similar formats, the information can be different. The SERVERNAME property automatically reports changes in...

I like it...except for the cursor 😉

Carlton..

Cool bananas...well except for the rest of the settings!

thanks again,

Carlton..

Hi Gail,

so DB_2 (Status = normal) that has autoclose set to on will have to complete recovery operations the next time it is accessed?

I know, it is a "vendor...

have a drink...then book a flight to the Cayman Islands

Distinct in my eyes is only good for analysing why/if there are duplicate records in your record set.

just like suquerys are only good for refactoring!

Carlton..

read the start of this discussion, its explained in one of the first posts.

Carlton..

with ansi nulls on: NULL is like a black hole that converts anything it comes into contact with to NULL as well. Kind of like a vampire, NULL bites other...

Full text is probably the way to go, but a soundex (in-built function) my be of some use to you.

Carlton..

I don't belive so, unless you use some sort of application trickery (some means outside of SQL server).

Is changing the connection string not an option?

Carlton..