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.

Check to see if the account which is trying to access the database has enough permission to access DB/ create mirror or Database autogrowth is on.

Mirror will become the Primary.

what value SET @subscriber = $(Client Name) is returning ? Do you know subscriber name, so you can pass directly?

When you want to setup replication from back up, you do not have to run snapshot agent, because you are already doing the work of snap shot agent by restoring...