I've reverse engineered a database using Visio for Enterprise Architects
(2003) and see that instead of using sp_bindrule or sp_binddefault it
actually attempts to create the rule or default on every colum to which it
should be bound. For instance, the following script was generated by Visio...

----------------------------------------------------
create table "FeedTransaction" (
    "ID" int identity not null,
    "BatchID" char(9) not null,
    "TransactionID" char(9) not null,
    "StatusCode" char(1) not null,
    "SystemTime" char(16) not null,
    "EmailProcessed" char(1) default CREATE DEFAULT df_No AS 'N' not null,
    "WelcomeProcessed" char(1) default CREATE DEFAULT df_No AS 'N' not null
    )
    ON 'FileGroup_FeedAndCheck' 

go

alter table "FeedTransaction"
    add constraint "pk_FeedTransaction" primary key clustered ("ID")  

go
----------------------------------------------------

Similar code that was output from an ERwin Data Modeler follows...

----------------------------------------------------
CREATE TABLE FeedTransaction (
       ID                   int IDENTITY,
       BatchID              char(9) NOT NULL,
       TransactionID        char(9) NOT NULL,
       StatusCode           char(1) NOT NULL,
       SystemTime           char(16) NOT NULL,
       EmailProcessed       char(1) NOT NULL,
       WelcomeProcessed     char(1) NOT NULL
)
  ON "FileGroup_FeedAndCheck"
go


ALTER TABLE FeedTransaction
       ADD CONSTRAINT pk_FeedTransaction PRIMARY KEY (ID)
go

exec sp_bindefault df_No, 'FeedTransaction.EmailProcessed'
exec sp_bindefault df_No, 'FeedTransaction.WelcomeProcessed'
go
----------------------------------------------------

Clearly the DDL output from Visio fails to run. Is there a way to configure
Visio to generate appropriate create statements for rules and defaults and
then bind them to the appropriate columns?

Thank you for your help.

Management Studio along side Management Studio Express
Resetting DB
Recovery Model Question.
HELP!!! --- From Job tasks to ASP
SQL 2005 SP1 Maintenance Plan "Include first level subfolders" checkbox doesn't appear