Viewing 15 posts - 1 through 15 (of 33 total)
Scott Duncan-251680 (1/7/2010)
Jeff Cook-476310 (1/7/2010)
and answered predicate (to the revised question), the site said:
Sorry - you...
Rick
townsends.ca
January 7, 2010 at 2:56 pm
If you add "Exception" and "User Error Message" to the trace, do they report the same useless exception information?
Rick
townsends.ca
November 5, 2009 at 2:31 pm
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...
Rick
townsends.ca
January 9, 2008 at 2:04 pm
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...
Rick
townsends.ca
December 5, 2007 at 2:10 pm
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...
Rick
townsends.ca
November 27, 2007 at 12:15 pm
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...
Rick
townsends.ca
November 26, 2007 at 4:49 pm
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...
Rick
townsends.ca
October 23, 2007 at 2:22 pm
"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...
Rick
townsends.ca
June 11, 2007 at 1:37 pm
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...
Rick
townsends.ca
June 7, 2007 at 6:09 pm
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...
Rick
townsends.ca
June 7, 2007 at 3:25 pm
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...
Rick
townsends.ca
June 4, 2007 at 4:24 pm
One of the biggest requests on SQL Server forums is how to aggregate string values. The answer was always "you can't", with the...
Rick
townsends.ca
May 31, 2007 at 5:18 pm
The explanation says "This returns a 5...", when in fact the rest of the explanation correctly states that it returns 7.
Rick
townsends.ca
April 19, 2007 at 10:25 pm
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...
Rick
townsends.ca
April 15, 2007 at 6:21 pm
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...
Rick
townsends.ca
April 12, 2007 at 4:35 pm
Viewing 15 posts - 1 through 15 (of 33 total)