enable remote connection on sql server 2008

http://www.linglom.com/2009/03/28/enable-remote-connection-on-sql-server-2008-express/

the trick is to enable tcp/ip protocol:

- On the left window, expand SQL Server Network Configuration -> Protocols for SQLEXPRESS. You see that TCP/IP protocol status is disabled.

- Right-click on TCP/IP and select Enable to enable the protocol.

sql server 2008 - database publishing

http://blog.sqlauthority.com/2009/07/29/sql-server-2008-copy-database-with-data-generate-t-sql-for-inserting-data-from-one-table-to-another-table/