Scott Duncan-251680 (1/7/2010)

---

Jeff Cook-476310 (1/7/2010)

---

I'm not sure what is going on but when I went to http://www.sqlservercentral.com/questions/T-SQL/68500/

and answered predicate (to the revised question), the site said:

Sorry - you...

If you add "Exception" and "User Error Message" to the trace, do they report the same useless exception information?

I am new to the database field so the term 'schema' being used to mean the 'design' of the table and not the 'container' the object resides in confused me.

You're...

That's good news - I've always thought MS would do better letting people buy individual components rather than massive bundles. That way if I only want Word and Excel...

Ah, yes, I see. From your first post, it seemed like you wanted the parameterized string, not the result.

I don't think you can get the result string in SQL...

Do you need to do this programmatically? If not, you could just change your query results to Text mode for easy printing, then run:

SELECT description FROM sysmessages where msglangid...

I think we agree it was a poorly worded question, and the explanation wasn't much better (it was just copied word-for-word from BOL.) Perhaps a better question would have...

"You don't want A to become primary again, because of longer downtime, clients who are connected to B may experience connection problems if their transaction are pending as they...

I didn't realize we can use SQL Server Express for a witness, that's quite good to know!

If your primary goes offline from both your mirror and your witness, doesn't that...

There are three simple ways you could solve the stated problem.

The first one is to have the witness at a third location.  I realize that the reason for putting it...

I got this question right, but it would be good if the answer indicated the fact that the 60 second sweep time is only the default configuration.  Even the referenced...

One of the biggest requests on SQL Server forums is how to aggregate string values.  The answer was always "you can't", with the...

The explanation says "This returns a 5...", when in fact the rest of the explanation correctly states that it returns 7.

Well, BETWEEN would require an index scan at least - seeks only get specific values.  Are your statistics up to date?  SQL Server might not know an index scan would...

If you're an admin, the best way is to run a simple trace.  Trace Stored Proc start and stop, and TSQL Statement start and stop events.  If your app connects...