--------------------------------------------------

Error : Server: Msg 170, Level 15, State 1, Line 17

Line 17: Incorrect syntax near '.'.

Thanks,

CH&HU

Not a big problem for budget but it must suits for BEST.

Only single application with 6 databases will be loaded on the server. Applicatio runs under SharePoint 2003 / 2007

Thanks,

CH&HU.

Can anyone have a look into this and help me ???

Its OLTP Application.

We do plan for Replication or Log shipping.

Concurrent users will be 300 everytime.

DB Size is of 30 GB initially and we are going to load other data as...

Thanks much for the reply...

Is there any other way to find the udpates or trasactions done on a publisher in replication, as i need to monitor and check if how...

Hi Kaushal,

Yes it will done by using reporting services. there we can subscribe the reports to mail address. Iam working on the same to subscribe the reports of performance dashboard.

Hi,

Thanks for your reply. I have recreated the procedure and scheduled for toninght. i will update u the improvements tomorow.

Thanks,

CH&HU.

Hi I have seen and checked the SQL Server error logs. There i can see the log reports of of 3/1/2009 and after 3/2/2009 and finalyy 3/10/2009...

I am wonder to...

Thanks Much Tarvin,

Let me try this way...

I have already created one script but it mailed like hell as .... Pls check the below script created...

------------------------------------------------------------------------------------------------------------------------

USE TEST;

GO

IF OBJECT_ID...

Thanks for the reply Tarvin,

Please find the post early today.

Thanks,

CH&HU.

Thanks Jack,

For your reply. I mean when ever a tables are exported and imported.

I treid DDL triggers but, here there is a lot of hell like mails delivered for each...

Hi,

It compreesed to 35 - 40 % , and the trasfer time is of 1hr .

Dear All,

Thanks for your inputs. I tried using WinRAR it worked fine.

Regards,

CH&HU.

Iam thakful for your efforts on my Procedure...

As i have a bit knowledge on SPs but now i came to learn into dept.....

Kindly let me know if anything else can...

it is Express edition.

Think it is disabled for Express Edition.