Creating publication hangs server

What are the actions performed by SQL Server when it creates a new publication or alters a previously created publication?

The reason I ask is because when I perform the above actions on a specific production database the server completely hangs. The tables are not large, maybe 5000 rows. I cannot delete the subscriptions either as this hangs the server too. Using any of the supplied stored procedures also has the same effect.

As this is a production environment I really don't want to do this too often.

Thanks

GavinMy dear friend. I have same problem on a clustered production system. Try this for start. When Creating publication, choose only one or two small tables at a time to create articles. Start snap shot and generate and apply changes to replicated server. Once ok. Start the same thing for other tables. If this works then u are good to go...


Originally posted by gmb72
What are the actions performed by SQL Server when it creates a new publication or alters a previously created publication?

The reason I ask is because when I perform the above actions on a specific production database the server completely hangs. The tables are not large, maybe 5000 rows. I cannot delete the subscriptions either as this hangs the server too. Using any of the supplied stored procedures also has the same effect.

As this is a production environment I really don't want to do this too often.

Thanks

Gavin

creating flat file and SQL Server 2005 hangs...

i m using the hands-on labs for SQL server 2005.

Step 6 age 14 i went thro and it make my SQL server 2005 hangs when i try to use the flat file destination.

You'll have to provide more info. The flat file destination doesn't use SQL Server in any way shape or form.

What does your dataflow do?

What colour are all the components in there (assuming you are running this in BIDS).

Do you get an error message?

-Jamie