Viewing 15 posts - 5,491 through 5,505 (of 6,105 total)
There is an issue with MDAC 2.6 connecting to SQL Server 7:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q300519
This wasn't the article I was thinking about, but it did stand out. I'll keep looking.
K. Brian Kelley
April 2, 2002 at 11:42 am
Ken Henderson in his book Guru's Guide to Transact-SQL actually takes a look at Soundex and makes a few modifications. You may want to have a look there.
K. Brian...
April 2, 2002 at 11:38 am
I believe they altered:
KeepAliveInterval
KeepAliveTime
SessionKeepAlive
K. Brian Kelley
April 2, 2002 at 11:37 am
Is Windows Script Host installed on your SQL Server? If not, that explains the failure because the object Wscript is part of WSH 1.0 and higher. The parse...
April 1, 2002 at 10:03 pm
I remember seeing a Knowledge Base article on this, but I'll have to search for it. Hopefully someone will find it before I do, but if not, I'll take...
April 1, 2002 at 9:54 pm
Your options are rather limited, then. What you may have to end up doing is extracting the data, encrypting it, sending it, and decrypting it. Another possibility is...
April 1, 2002 at 9:34 pm
Another DBA I work with remarked that he saw this problem with Citrix Metaframe 1.8 at a previous place of employment. There would be sessions still open at 3...
April 1, 2002 at 9:19 pm
We do this without issue as well where multiple .MDF files go into a single .BAK file. We've not had a failure, though we do test periodically, as Antares...
April 1, 2002 at 9:13 pm
A quick bullet list of some of the things Enterprise Edition supports that Standard does not:
April 1, 2002 at 9:11 pm
Thanks for the follow-up. That really is odd behavior, because no match is found so I'd have thought they would have coded nothing to happen and the original string...
March 31, 2002 at 5:31 pm
EOM is possibly end of message. TDS isn't well documented. Some guys have reverse engineered TDS under Sybase, but Microsoft has continually expanded upon it, and SQL Server...
March 31, 2002 at 5:25 pm
Taking ownership can be tracked, but so can logins to SQL Server which tells you if someone is going in who normally shouldn't be. There's also nothing stopping a...
March 31, 2002 at 5:20 pm
From the Q article (Q243586):
quote:
Recompilations Due to Certain SET Statements Executed in Stored ProcedureThe following five SET options are set to ON...
March 22, 2002 at 2:05 pm
That I don't know. BOL doesn't specify and I haven't had the time to find out.
K. Brian Kelley
March 21, 2002 at 2:27 pm
There is a counter under SQL Server:Database statistics in Performance Monitor/System Monitor. Within SQL Server there is a system table called sysperfinfo for both SQL Server 7 and 2000...
March 21, 2002 at 1:55 pm
Viewing 15 posts - 5,491 through 5,505 (of 6,105 total)