🙁 :crazy: :angry: :blink: :crying:

There are rumours of fuller support for this sort of requirement in the next major release of SQL Server.

(R2 is not a major release).

honza.mf (4/7/2010)

---

Be aware! This setting is per connection, not per server. And SP keep the setting of the connection they are created in. Remarked by a person that lives...

Please bear me in mind for any future opportunities that might arise :w00t: 😀

Something like the following might point you in the right direction...

SELECT [schema_name] = SCHEMA_NAME(SFK.[schema_id]),

current_name = SFK.name,

...

You need help, Mr Morris...:laugh:

I think your mind has been warped by the dense and opposing gravitational...

Well done on hitting the 14,000, David 🙂

14K next up in 336 posts...

Seriously? Have you tried many other QotDs? Or are you just claiming to be super-intelligent? 😛

Tom.Thomson (4/7/2010)

---

Nice clear question, correct answer, nice clear explanation.

The success rate is amazing. When I read the question I thought there would be a large majority getting it right...

Less than 50% pass rate so far :w00t:

I'm not that interested - just...

Not...

Berm.

47% getting my QotD correct today so far (361 attempts).

Any Threadizens going to help push it over 50%?

It will be interesting to see how the success rate changes once the...

I have never come across one. Apart from the bizarre rules illustrated by the question, ANSI_NULLS OFF...