SP3 may solve this issue for you when it's released. Since it's still in beta, I don't think we're allowed to speak as to why until it goes public. Unless,...

In MySQL's defense, it does have a rather nice web-based interface already built for it (PHP, as mentioned). Me being a command-line junkie and having a shell account means I...

True, if they are both not on the same subnet, then a broadcast won't resolve a NetBIOS based name. Hence the need for WINS. However, if DNS is set up...

MySQL is extremely fast at retrieving queries until load starts getting high. Then MySQL drops like a rock. It's not enterprise ready... yet. But it's getting there in a hurry.

There...

If it's an error I know is going to terminate the batch, I'll test for it before-hand if at possible. Otherwise, I'll check @@ERROR and take appropriate action, including rolling...

SELECT TOP is new as of SQL Server 7.0. It doesn't exist in SQL Server 6.5. You have to use SET ROWCOUNT prior to the query. Testable by setting a...

Known = Crypto algorithms that have been tested and so far have been shown to be relatively secure. DES, 3DES, DESX, RSA (probably won't use this one because it's public...

I'm going to be researching connecting to SQL Server via DBI on Linux in the near term... part of the series on connecting to SQL Server from Perl I've started....

Agreed, in that triggers can be poorly written and really harm performance. Techniques such as checking to see if a row was updated or verifying if any rows were modified...

Hrm. That shouldn't be the only solution because in AD you are supposed to work to try and get away from WINS altogether.

What versions of OS and SQL Server? If...

Please don't cross-post. Most forum readers check all topics. As a result, this thread has been locked. Look for replies here:

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=8499&FORUM_ID=23&CAT_ID=2&Topic_Title=Number+expressed+as+words&Forum_Title=General

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server...

Name resolution shouldn't matter in this case, so long as to the servers can identify each other. The only other KB article (if there aren't firewalls and the like in...

I believe that Word does handle Unicode, but I honestly have no way of testing. However, yes, if it does, specifying .doc would eliminate the issue for those who have...

The problem that you're likely to run into is the client computer will determine what application is associated with a given file extension. For instance, .txt is associated with Notepad...

We have three clustered servers with their own external storage arrays as well as a clustered SQL Server install where the drives are part of our SAN. The SAN-based one...