You may be interested in reading one of my posts, which explores the use of EXECUTE...AT clause for executing queries against linked servers: http://beyondrelational.com/blogs/nakul/archive/2011/01/10/executing-queries-against-linked-servers.aspx

I like it too! 🙂

I disagree with the answers (2nd time in the same week). Here's why:

3. A hint overrides a SET option

4. A database option overrides an instance option and a SET option...

The way I interpreted the question, it was all about whether or not computed column definitions can contain references to columns of other tables. The answer, according to Books On...

It's pen & paper for me. I carry a notebook/diary that lists the day's tasks and on the adjacent page, I note down my own time log. During meetings, notes...

Good question (it's often a challenge to achieve both - space & performance), but it looks like the mapping of the options and the answers is incorrect.

The correct answer is...

Thank-you! Everything seems to be in order based on the screenshots you provided.

I came across this Connect case (http://connect.microsoft.com/SQLServer/feedback/details/351315/books-on-line-succesfully-installed-are-not-accessible), wherein the issue was resolved by uninstalling and reinstalling the client...

You may want to go to SSMS -> Tools->Options->Help and verify that you are using the correct settings against a working environment.

This was a good one! Thank-you, Paul. Great start to the year.

Have a Happy & Prosperous New Year 2012, everyone!

Very well written article. Thank-you very much for the same.

It's difficult to keep cool and look for the root cause when such problems arise. I therefore, appreciate your dedication to...

Well, I cheated too! 🙂 I knew about Rudolph, Vixen and Cupid,...

Get well soon, Brad!

This is a good, useful QotD. Thank-you!

One of the things that I find missing these days is patience. It seems nobody takes the time out to think and plan out the code that they are going...

Good article, Craig! Learnt a few new things today with respect to troubleshooting memory pressure on the server.

Thank-you for taking the time out to compile your findings and write the...