Viewing 15 posts - 6,151 through 6,165 (of 9,722 total)
GilaMonster (3/30/2011)
For your amusement, this (attached) was part of a project plan I received today, specifically the test plan....
Our Testing Manager would die of laughter. Before she strung the offender...
March 31, 2011 at 5:19 am
Bumping back to page 1...
Beef (or Ham) rollups
1 pkg Budding Beef (which is dried beef) or Ham. If you don't have the Budding brand, anything thinly sliced will work.
1 pkg...
March 30, 2011 at 10:45 am
Well, gosh darned it! Apparently I missed my "Hall of Fame" to "Carpal Tunnel" moment.
I got promoted! @=) (Ow! My poor SQL wrists!)
March 30, 2011 at 10:37 am
Start here:
Enable SSL Encryption for SQL Server Instance
MSDN Blog on Encrypted Connections
You can also google "sql 2005 encrypted connection" (without the quotes) for more articles.
March 30, 2011 at 9:10 am
Using PC Anywhere doesn't necessarily mean there's a VPN or SSL tunnel set up. You might want to check on that to make sure connections really are already encrypted.
The...
March 30, 2011 at 6:13 am
Perry,
I appreciate the help you're trying to give me, but you're giving advice based on incorrect assumptions about my setup. This might be because I'm not stating it correctly. So,...
March 30, 2011 at 6:03 am
ALZDBA (3/29/2011)
Did you try dtcping and dtctester?
Hadn't heard of those tools until you told me about them. I'll check into them. Thanks for the link.
Did someone alter DNS settings, firewall...
March 30, 2011 at 5:47 am
Sorry it took so long. Had fires to put out.
SELECT srsf.DTConID, srsf.CNum,
CASE WHEN srsf.TransactionDate >= srsf.CycleStartDate AND srsf.TransactionDate <= srsf.CycleEndDate
AND pr1.DTConID IS NULL AND srsf.Status NOT...
March 30, 2011 at 5:00 am
Thanks, Perry, but MSDTC is running as a clustered resource (I thought I mentioned that in my first post, but upon re-reading, I apparently phrased the sentence in vague terms)....
March 29, 2011 at 12:46 pm
Alzdba, Thanks for the links. I've seen a few of them before, but the one on tracing is new and I might just have to do that.
March 29, 2011 at 12:03 pm
Perry Whittle (3/29/2011)
March 29, 2011 at 11:46 am
Rhox (3/29/2011)
Why should you use this command for?
Honestly, I wouldn't use this command. I can't think of one good reason why I would need it in any production environment I...
March 29, 2011 at 11:41 am
Further information (which just goes to prove that even informational messages in the logs can be helpful):
Application Log Informational Message
Event Source:MSSQL$ACP1
Event Category:(2)
Event ID:8562
Date:3/28/2011
Time:8:51:33 PM
User:N/A
Computer:XXXXXXXXXXXXXX
Description:
The connection has been lost with...
March 29, 2011 at 9:18 am
GilaMonster (3/29/2011)
Brandie Tarvin (3/29/2011)
The command being discussed has the effect of turning the database (temporarily) to SIMPLE mode because it throws out the transaction log backup
No it doesn't. It...
March 29, 2011 at 8:25 am
Viewing 15 posts - 6,151 through 6,165 (of 9,722 total)