Yes, Replication was dropped and now it is being recreated. It is on two servers. It is transactional replication. No articles have been added to publication recently but we did...

Thanks Lowell, thats exactly what I was looking for.

Thanks everybody for all of your suggestions. I'll check into each of them.

Just for my own information. I'm new to T-SQL and have been using alters to change columns etc. Have been told sometimes you might want to drop and recreate a...

Thanks everybody. NoelD, that script worked fine. I appreciate it. ned.

I'll give the EM table modifications a try.

I'm not sure how many characters the nvarchar will be so I put in 50. I just know that a change will be needed...

I need to change this by script.

Thanks Farrell, thats exactly what I needed. Don't worry I'm working on a local test database. Thanks, Ned.

Hello, In my temporary table there are two columns one is the table_name column the other is the column_name column. All the tables and the columns I want to change...

Nah, no default definition. Its datetime, 8, Allows NULLS. Another table is inserting into the table with Status_Date bya trigger. I tried putting NULL...

Forget it. Reason I couldn't remove red X's were because replicated table was missing a column. It's all good now.

Thanks Greg, Got it working perfectly. Thanks for your help.

Thanks, Racosta. Thats exactly what I needed. I appreciate your help.

I'm realatively new to SQL. How would I script the Subscription to see all the stored procedures?

I found out the problem was with security. My server only allowed Windows security and it should have allowed SQL Server and Windows logins.