Creating a new Subscription with RMO objects

Hi Gang,
Does anyone know how to createa a new subscription using RMO on SQL Server
2005. I'm using the beta version (Sep CTP) but SQL books online has bad
links on the doc's for doing this.
Any help will be greately appreciated,
Thanks,
--Ader.
The following link should hoperfully work better...
http://msdn2.microsoft.com/en-us/library/ms146863
HTH
-Raymond
"gonzalez" wrote:

> Hi Gang,
> Does anyone know how to createa a new subscription using RMO on SQL Server
> 2005. I'm using the beta version (Sep CTP) but SQL books online has bad
> links on the doc's for doing this.
> Any help will be greately appreciated,
> Thanks,
> --Ader.
>
>

Createa table like a existing table?

Hai all

I am new to SLQ server. Can anyone tell me how to create a table that
should look like a existing table fields...

thanxSSG (ssg14j@.gmail.com) writes:
> I am new to SLQ server. Can anyone tell me how to create a table that
> should look like a existing table fields...

You can do "SELECT * INTO newtbl FROM tbl WHERE 1 = 0". Beware though
that constraints, indexes and triggers are not copied. If you want that
you are better off scripting the table, which you can do by right-clicking
the table in the Object Broswer in Query Analyzer. Even better, have all
your source code under version control. Then copying is even easier.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||On Tue, 27 Dec 2005 08:13:25 +0000 (UTC), Erland Sommarskog
<esquel@.sommarskog.se> wrote:

>SSG (ssg14j@.gmail.com) writes:
>> I am new to SLQ server. Can anyone tell me how to create a table that
>> should look like a existing table fields...
>You can do "SELECT * INTO newtbl FROM tbl WHERE 1 = 0". Beware though
>that constraints, indexes and triggers are not copied. If you want that
>you are better off scripting the table, which you can do by right-clicking
>the table in the Object Broswer in Query Analyzer. Even better, have all
>your source code under version control. Then copying is even easier.

Also note that in most cases where you would want to copy a table's design
within the same database, you'd probably be better off doing more
normalization instead.