enable database Service broker in sql server 2005 -2008

Enabling Sevice broker in sql server

Step 1.  Go to Sql server management studio & open Database properties >> options>>  Broker enabled set to true

OR

STEP 2 :

Exeute query >> alter database [your database name] set enable_broker


Alter Database column change size

Query >>ALTER TABLE MyTable ALTER COLUMN NullCOl NVARCHAR(20) NOT NULL;