Steve, I'm newbee. Not sure what is PSS? 

John,

I run:

DBCC CHECKDB ('Server01', NOINDEX)

DBCC CHECKDB ('Server01', REPAIR_FAST)

DBCC CHECKDB ('Server01', REPAIR_REBUILD)

have several errors on certain tables.

Yes, I went to SP2 ReadMe file.  But It won't apply to my case.

Because my Distributor and Subscribers  are running in SQL Server 2005.

And my Publisher is running in SQL...

Additional error: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SQLServer.Rmo)

Have you seen these errors!!

I went over the Summary.txt file and I did not see and find any errors.

So, SP2 installation is okay.   However, the SQL Server 2005 was running replication process. 

I saw...

I applied to two SQL Server 2005.  One of them is working okay.

The SQL Server 2005 run replication was having issues.

Where can I find the log file?

TJ

Hi Mohammed,

Yes, I awared on this options on publications properties.

My goals are to setup this table with 360columns into 3 different tables.

How to divide a big table into 3 small...

Hi Rudy,

I try to answer your questions:

1. It's the productions database.

2.No application software installed on SQL Server 2005.

3. I believed no IIS installed.  What is the best method to check...

The Window Server 2003 is already setup with single C drive.

They won't allow me to re-install the O/S and create partition C, E, and F.

What is the best option  to...

Hi Room,

I found an article from Microsoft sites. The SQL Server 2000 cannot replicate a table with more than 254 columns. It is behavior of SQL Server 2000 by design....

Rudy,

What is the secure and correct method to create database?

Since my Windows Server 2003 was already setup and

it did not partitions to E, D, F drive.

Please advise. Thank a lottttt....

Hello Mohammed,

Actually, I am looking a good sample db creation scripts.

Thanks!!

TJ

Hi MohammedU,

I was setup transactional replication.  The snapshoot went completed.

The current log size 819200 KB and maxsize 819200 KB.

The disk still have plenty of spaces.

The growth size 102400 KB.

How do I...

Hi Addict,

That's correct.  I am getting the errors when the distribution agent applies the snapshoot at the subscriber.

Thanks

TJ

In SQL Server 2005, I create the alias in SQL Native Client Configuration.

And, in SQL Server 2000, I create the alias in  SQL Server Client Network Utility.

Both servers can communications.

Thanks

TJ...