Look at your code where you are unioning 2 select.

They are not mapped right.

In the first select 0 AS NONBILLABLE should come after TSC.TaskCategory AS Category.

Something like this will work. You have to validate this in your environment. That's whay people ask you to post code in case you need quick answers.

WITH DupCTE

(ROBumber,ROTime,Ranking)AS

(SELECT ROBumber,ROTime,...

I have given you all the steps in thred

http://www.sqlservercentral.com/Forums/Topic1447153-291-1.aspx#bm1447334

But again here it is.

•Set up Publication.

•Set transaction retention to 120 hours for distribution

•Disable the distribution clean up job on...

You have to specify N before literals to say that to SQL that this is unicode.

Like in the below example :-

insert into Test(str)values(N'gîte')-- this is word for house...

Yes you can create partition on date column.

refer to :-

http://msdn.microsoft.com/en-us/library/ms345146(v=sql.90).aspx

This is the strangest thing I have heard. I never have heard anything like that before. But I have 1 question is it 45mb or GB?

That's why I asked to read BOL on transaction log management.

Now you have got Gail's attention. You will have an answer.

Do a select on sys.sysdatabases to find if Db_test exists.

On the other note why you want to shrink log file? If mast always take regular backup of TLogs.

Read some BOL...

Use this.

if exists (select 1

from sys.databases

where is_published = 1 or is_subscribed = 1 or

is_merge_published = 1 or is_distributor = 1)

begin

--yourcode

...

I am not sure what is your question. But what I am trying to say that you do not need to create publication every time you want to add articles....

No. For the first time you can set up replication initiated from backup. Then use sp_addarticle for adding new tables.

Best thing is to start from here.

http://www.kimballgroup.com/

Use sp_addarticle on both publisher and subscriber because in P2P all servers are publishers AND subscribers.

You can create indexed view on the Publisher based on your filter criteria and publish that view.

With all the things you explained earlier I want to add that keep learning new features of the technology you are using.