What are the issues you are having with replication distribution server?

Please note that clustering is a high availability solution. Not a high performance solution.

If the issues are related performance, clustering...

Schema changes to the tables are automatically replicated in transaction replication of SQL Server 2005 version. There is no need to recreate or rebuild the publication.

Congratulations 🙂

Does column debnr exist in cicmpy table (or view)?

dmoldovan (1/18/2010)

---

Is there any way to change the default size and autogrow of the tempdb?

I can alter the tempdb size using ALTER DATABASE, however the tempdb will be created...

Did you try to alter the table using T-SQL command or GUI?

If it was GUI, try T-SQL. It may work.

Add the user to db_datareader database role only.

If you don't have the date column...

ksvchowdary (1/22/2010)

---

We have the database ex: ABC and 187 tables.

In this database we have 12450 Customers Data.If I want to take the backup of ABC database I can take the...

row/page compression supports tables and indexes.

Sample:

CREATE TABLE T2

(c1 int, c2 nvarchar(50) )

WITH (DATA_COMPRESSION = PAGE);

GO

For more information please see BOL.

Please don't cross post.

Duplicate post:

http://www.sqlservercentral.com/Forums/Topic851802-146-1.aspx

Replicate with filter to another database. Then backup that database.

Yes it is possible.

SQL Server 2008 has row/page compression option. You can utilize it.

Compressed drive for SQL Server database is to be used only if you don't have any other...

Check Show all columns

Check HostName column

Set filter on HostName column.

Steve Cullen (1/20/2010)

---

This can be caused by partially removed publications that leave metadata behind in the distribution sys tables. You can search for removed publications in the MSpublications, MSsnapshot_agents,...