MacSQL's support for MS SQL Server is provided by FreeTDS, an open source implementation of the TDS protocol used by Microsoft SQL Server. This version of MacSQL includes code from the FreeTDS CVS repository as of March 2003. We are working on updating our code to match the latest version of FreeTDS to provide better SQL Server support.
Inside MacSQL's frameworks folder is the FreeTDS.framework, which includes the FreeTDS code. A ReadMe file includes compilation instructions along with instructions to download the source used to build the framework.
MacSQL uses a slightly different terminology for database objects than Microsoft.
What MacSQL refers to as a database is called a schema in SQL Server. There is no way to represent a SQL Server database in MacSQL after a connection is open.
However, when you open a connection to SQL Server, you can specify the initial database that you would like to work with. If you do not specify one (or specify a database that does not exist or that you do not have permission to access), you will instead work with the default database assigned to you by your database administrator.
You can also switch which database is being used via the SQL Server menu.