Create a publication in SQL Server 2005 Express

Hi,

is it possible to create a publication with SQL Server 2005 Express. I can′t seem to find it in Microsoft SQL Server Management Studio Express.

Do i have to install the full version? :(
Isn′t there any other option?

Thanks
SP

SQL Express can't serve as publisher or distributor for all types of replication. For more considerations for replication on SQL express. checkout this topic: http://msdn2.microsoft.com/en-us/library/ms165686.aspx in BOL.

You will need workgroup edition or above, although the workgroup has limitations on the number of subscriptions. For full detail, take a look at "Features Supported by the Editions of SQL Server 2005" (http://msdn2.microsoft.com/en-us/library/ms143761.aspx)

Peng

|||

No, it's not possible to create a publication in the Express edition. For express edition, your server can only use as subsriber in replication. You will need to use a regular SQL server as your publisher and distributor.

http://msdn2.microsoft.com/en-us/library/ms165616.aspx

Regards,

Gary

|||I′m installing the complete SQL Server 2005 and i have the following options:
sql server database services