swSQL Known Issues:

1. To assure proper operation, swSQL should not be installed in a folder with apostrophes in the name.
If you have installed in such a directory, uninstall the program and reinstall it to a new location.

2. On some systems you get an error message "Attempted to divide by zero" when connecting remotely.
	This is a documented bug in Microsoft's SMO and not a bug in the software.
	
	Workaround:
			A. Install Microsoft SQL Server Management Express.
			B. At the program's login window, click the Server Name dropdown.
			C. If the remote server is showing, select it, and skip to step G.
			Otherwise, click "browse for more"
			D. Click the Network Servers Tab. Wait a moment while the program serches.
			E. Click the database engine and select the remote server you want.
			F. The server name will now be in the dropdown box.
			G. Highlight the server name with the mouse or by double clicking.
			H. Press Ctrl & C to copy it.
			I. Open swSQL and check Remote Connection.
			J. Click ok on the error message.
			K. Paste the server name into the Server dropdown box. (Ctrl & V)
			L. Enter your user name and password.
			M. The Database dropdown will now have the database listed.
			N. Select the proper database and click ok.
			O. As long as you continue to check the Remote Connection checkbox,
			the program will remember the remote connection with each startup. You
			will still get the error, but it can be ignored. 

3. There is a possibility that the database was not properly installed. This can happen when the
drive letter of your main disk drive is not C: or if it is not installed in the default directory. 

	Workaround:
			A. Install Microsoft SQL Server Management Express.
			B. Login using Windows autentication.
			C. The database can be found on the left under Databases.
			D. The database has the name STUDIOWORKS.MDF preceeded by the full path.
			E. Right click and then delete.
			F. Click the File Menu and then Open/File.
			G. Browse to the swSQL directory and open CreateStudioWorks.sql
			H. You may be asked for login information again.
			I. The beggining of the script looks like this:
			
			USE [master]
			GO
			IF NOT EXISTS (SELECT name FROM sys.databases WHERE name = N'STUDIOWORKS.MDF')
			BEGIN
			CREATE DATABASE [STUDIOWORKS.MDF] ON  PRIMARY 
			( NAME = N'StudioWorks', FILENAME = N'C:\Program Files\M&M Studio\swSQL\StudioWorks.mdf' , SIZE = 1664KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
			 LOG ON 
			( NAME = N'StudioWorks_log', FILENAME = N'C:\Program Files\M&M Studio\swSQL\StudioWorks_log.LDF' , SIZE = 768KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
			END

			J. Change the path C:\Program Files\M&M Studio\swSQL (after each FILENAME =) to the path
			where you installed StudioWorks.
			K. Click Execute.

4. When creating a schedule entry that ends after 11:30 pm, some systems do not save the time correctly.
	This bug can't be duplicated on the development system and is rare. Possibly due to regional settings.

	Workaround:
		If a session lasts until midnight, simply add additional time on the following day.