MS-access has problems with non-nullable bit columns so you can either use (tiny)int columns or make them nullable but have a default value

ALTER PROC tools.find_nullable_columns_without_default_bit_only
as
BEGIN
-------------------------------------------------------------------------------
-- Finds all NULL-able columns that have no DEFAULT constraint. Also emits the
-- ALTER TABLE statements needed to add the DEFAULT constraints
-------------------------------------------------------------------------------
-- Copyright 2009 Larry Leonard, Definitive Solutions Inc.
-- http://www.DefinitiveSolutions.com
--
-- Copying and distribution of this file, with or without modification, are
-- permitted in any medium without royalty provided the copyright notice and
-- this notice are preserved. This file is offered as-is, without any warranty.
-------------------------------------------------------------------------------

-------------------------------------------------------------------------------
-- MUST be set as shown to support indexes on computed columns, indexed views.
SET ANSI_NULLS ON -- Deprecated: leave set ON.
SET ANSI_PADDING ON -- Deprecated: leave set ON.
SET ANSI_WARNINGS ON -- No trailing blanks saved.
SET ARITHABORT ON -- Math failure not ignored.
SET CONCAT_NULL_YIELDS_NULL ON -- NULL plus string is NULL.
SET NUMERIC_ROUNDABORT OFF -- Allows loss of precision.
SET QUOTED_IDENTIFIER ON -- Allows reserved keywords.

-- These are not strictly speaking, required, but are generally good practice.
SET NOCOUNT ON -- Minimize network traffic.
SET ROWCOUNT 0 -- Reset in case it got set.
SET XACT_ABORT ON -- Make transactions behave.
-------------------------------------------------------------------------------

DECLARE @sTableName sysname SET @sTableName = ''
DECLARE @sColumnName sysname SET @sColumnName = ''
DECLARE @sColumnType sysname SET @sColumnType = ''
DECLARE @sSQL NVARCHAR(4000) SET @sSQL = ''

DECLARE TheCursor CURSOR FOR
SELECT OBJECT_NAME(c.object_id) AS 'Table Name',
c.name AS 'Column Name',
ty.name AS 'Column Type'
FROM sys.columns c
JOIN sys.tables t
ON c.object_id = t.object_id
JOIN sys.types ty
ON c.user_type_id = ty.user_type_id
WHERE c.is_nullable = 1
AND c.is_identity = 0
AND t.type_desc = 'USER_TABLE'
AND t.is_ms_shipped = 0
AND ISNULL(c.default_object_id, 0) = 0
and ty.name in ('bit')

OPEN TheCursor

FETCH NEXT FROM TheCursor
INTO @sTableName, @sColumnName, @sColumnType

WHILE @@FETCH_STATUS = 0
BEGIN

SET @sSQL =
'ALTER TABLE dbo.' + QUOTENAME(@sTableName)
+ ' ADD CONSTRAINT ' + QUOTENAME('DF_'+ @sTableName + '_' + @sColumnName)
+ ' DEFAULT ('
+
CASE @sColumnType

WHEN 'char' THEN ''''''
WHEN 'nchar' THEN ''''''
WHEN 'varchar' THEN ''''''
WHEN 'nvarchar' THEN ''''''
WHEN 'sysname' THEN ''''''
WHEN 'xml' THEN ''''''
WHEN 'udtUserID' THEN ''''''
WHEN 'text' THEN ''
WHEN 'ntext' THEN ''

WHEN 'bigint' THEN '0'
WHEN 'int' THEN '0'
WHEN 'smallint' THEN '0'
WHEN 'tinyint' THEN '0'
WHEN 'bit' THEN '0'

WHEN 'real' THEN '0.0'
WHEN 'money' THEN '0.0'
WHEN 'smallmoney' THEN '0.0'
WHEN 'float' THEN '0.0'
WHEN 'decimal' THEN '0.0'
WHEN 'numeric' THEN '0.0'

WHEN 'image' THEN '0x0'
WHEN 'binary' THEN 0x0
WHEN 'varbinary' THEN 0x0

WHEN 'uniqueidentifier' THEN '0x0'
WHEN 'sql_variant' THEN '0'
WHEN 'hierarchyid' THEN '0'
WHEN 'geometry' THEN '0'
WHEN 'geography' THEN '0'

WHEN 'datetime' THEN 'GETDATE()'
WHEN 'date' THEN 'GETDATE()'
WHEN 'time' THEN 'GETDATE()'
WHEN 'datetime2' THEN 'GETDATE()'
WHEN 'datetimeoffset' THEN 'GETDATE()'
WHEN 'smalldatetime' THEN 'GETDATE()'
WHEN 'timestamp' THEN 'GETDATE()'
ELSE '-1'
END

+ ')'
+ ' FOR ' + QUOTENAME(@sColumnName)

PRINT @sSQL

FETCH NEXT FROM TheCursor
INTO @sTableName, @sColumnName, @sColumnType
END

CLOSE TheCursor
DEALLOCATE TheCursor
END
GO

It appears that there is an issue in SSMS (I am on SQL 2012 RTM, US English) that prevents you from copying text out of the SQL Test Messages window unless all SQL editor windows are saved to disk. For example, if you run some tests, then highlight the text in the SQL Test Messages window, and do either CTRL+C or Edit... Copy, SSMS will give you a scary error message if you haven't actually saved all of your query windows to disk files: "Unsaved documents cannot be cut or copied to the clipboard from the Miscellaneous Files project. You must save the unsaved document(s) before cutting or copying them.". Granted, this appears to be a bug in SQL Server Management Studio, but it would be great to have a workaround button called "Copy Messages" in the header to the SQL Test window as a workaround.