You can have it but having two distributors on the same server where the publisher is located will definitely have an impact on the performance of the system.

Cheers,

Satnam

Awesome. Wish there could have been more than 5 *

Cheers,

Satnam

Even, I have the same opinion.

Cheers,

Satnam

Is the folder shared and does the user have full control on the folder, i mean to say in Sharing and Security.

Satnam

http://www.sqlservercentral.com itself is a best place.

Satnam

SQL Server Migration Assistant.

If u want to know how to set up replication for eg transactional replication, then here is the link,

http://www.sql-server-performance.com/articles/per/transactional_replication_2008_r2_p1.aspx

If u want to setup alert emails, though u can...

There should be a job named Distribution Cleanup: Distribution which is responsible for clearing the commands from the distibution database on your server.

Distribution Cleanup: Distribution itself has a stored...

On the remote machine where u r thinking of keeping the distribution database first configure the distributor there and theen start setting up the transactional replication on the machine which...

I hope this helps,

http://www.mssqltips.com/tip.asp?tip=1564

Satnam

Just check whether u r able to connect to the server hosting your mail box using remote desktop connection or either. Ckeck whether u r able to ping that machine.A...

It should be in Recovery mode.

Satnam

Please refer the below link,

http://www.sqlservercentral.com/articles/Automating+SQL+Server+Health+Checks/68910/

I hope it helps.

Satnam

Sorry its numeric(21,10) and not numeric(21,0)

Satnam

alter table tablename

alter column columnname numeric(21,0)

execute this against the database which has that table whose column data type needs to be changed.

Satnam