I finally found the solution by myself.

ScriptOptions.Creation Or ScriptOptions.IncludeAll Xor ScriptOptions.IncludeReplicationJobs

does the trick.

TransactionalPublication.Script(ScriptOptions.Creation Or ScriptOptions.IncludeAll Xor ScriptOptions.IncludeReplicationJobs)

generates the script. I was missing bitwise operators (Or /Xor).

Thanks everyone for your...

I finally found the solution by myself.

ScriptOptions.Creation Or ScriptOptions.IncludeAll Xor ScriptOptions.IncludeReplicationJobs

do the trick.

TransactionalPublication.Script(ScriptOptions.Creation Or ScriptOptions.IncludeAll Xor ScriptOptions.IncludeReplicationJobs)

generates the script. I was missing bitwise operators (Or /Xor).

Thanks everyone for your...

I treid all the options available in scriptoptions. Only EnableReplicationDB or Creation works. All others just return me a blank space. No where I could find a reference or example....

Thanks for a quick response.

I tried both TransactionalPublication.Load() and TransactionalPublication.LoadProperties. No luck.

I still couldn't figure out a easy way to do it.

Thanks

I have multiple publications some are Transactional and some are Merge replication. I could manually script from SQL Management Studio. But I want to automate the process because there are...

We been using it for the past 5 years. It works perfect. It is just like mirroring of your drives. Occasionnaly the process fails due to network issue etc but...

IF SQL Browser service not running on the server you might have some issues connection to named instance espeically if the TCP IP port is set to dynamic(default). Try connecting...

Nope.  I tried. Since BACKUP is not a DDL event no luck. Any kind of suggestion is really appreciated.

Nope.  I tried. Since BACKUP is not a DDL event no luck. Any kind of suggestion is really appreciated.

Thanks...that is exactly what I am looking for.

How can I remove access to all members including sysadmin to Decrypt the value opening the symmetric key. Is there a way I can deny access to sysadmin and give...

I think I didn't mention exactly what I am looking for. This is what I need to do.

I need to capture the time zone of the DB server and adjust...

Thanks a bunch..

Option 1 would be better than option 2.

Main reason. You will have Index for each table you create(split). And when you query the UNION ALL VIEW  only the index...

I am interested. Can you send me your contact details and more specs to me_balaji@yahoo.com.

Thanks