run following script and will remove all unwanted publishers from subscribers which were created when Publishing DB was restored on Subscriber. It works for me,

DECLARE @subscriptionDB AS sysname

SET @subscriptionDB =...

Fo Example

CREATE TABLE dbo.Table1

(

<columns_in_primary_key, , c1> <column1_datatype, , int> <column1_nullability,, NOT NULL>,

<column2_name, sysname, c2> <column2_datatype, , char(10)> <column2_nullability,, NULL>,

<column3_name, sysname, c3> <column3_datatype, , datetime> <column3_nullability,, NULL>,

...

Simple steps

1. Create new file group say "Secondary" obviously

2. Create New file under this file group

3. If you have big objects, then create new object with some suffix with "SECONDARY"...

just now I've replied with simple query isntead of this long code

Select ',', [column_Name] from information_schema.columns where table_name like '' order by ordinal_position

Sushil

Sorry the query should be like this

Select ',', [column_Name] from information_schema.columns where table_name like '' order by ordinal_position

Sushil

You can simply write a query instead of doing all the copy paste and use of excel

Select ',', [Name] from information_schema.columns where table_name like '

' order by ordinal_position

Copy the resultset...