I am having the same issue. What is crazy, is that the linked server WAS working fine. Spent a few days on the phone with Microsoft a couple...

I have played with this before at a client's site and thought it was a pretty good tool to help track down overall performance issues.  Unfortunately, I don't think they...

No, both answers are wrong, so they are valid according to the question.   You CAN use a script, but you can ALSO use EM to do a point in time...

I don't have anything to add about 64-bit Windows, but I do about rainfall in Seattle

It's something of an urban legend that Seattle...

Yeah, me too.  Cube, not the database.....

Brandon

I think a more interesting question would be:

What would you get for the following (assuming same tables and data):

SELECT COUNT(col1) FROM one

SELECT COUNT(col2) FROM two

or simply

SELECT COUNT(col1), COUNT(col2) FROM...

<rant>

There is nothing wrong with the question or the answer.  You are throwing yourselves off by the plus (+) sign which, in this case, is only indicating that the integer...

I disagree with the answer.

Running the query below returns columns for tables/views and parameters for stored procedures and UDFs....

What am I missing?  Or more correctly, what is BOL missing?

select ob.name,...

Personally, I try to avoid bits in cases where there are several flags to be set, and opt for a single integer (or smaller).  I use each bit of the integer for individual...