Hi Parkin,

Thanks, Can you please explain the CDC Concepts? I am new to this CDC Concept. Thanks in advance

Regards,

Ram

Hi Parkin,

Consider the source data has to copied to destination with in 3 Minutes.

Regards,

Ram

Thanks

Is there any workaround to make the agent to run?

The Error Message is :

The service cannot be started, either because it is disabled or because it has no...

Thanks Gianluca Sartori..!

We have tried with Bulk Insert opertions from UI,but the system performance becomes slow. Sometimes , server session is timed out so we couldn't able to import...

Hello,

We have configured transactional reliplication, mistakenly our users entered the data in subscriber instead of publisher.Thanks for your understanding.

Awaiting for your reply.

Thanks,

Ram

Thanks for sending the articles,now we have the stored procedures for send mail.

We wanted to schedule or creating the task for that stored procedure(send mail).Can anyone help us on it.

Thanks,

Ram.

Thanks for the reply,we have subscriber schema so we don't want to replicate the schema to scbscriber database.we want to replicate only publisher data to subscriber which is already existing...

Thanks for your suggestion,henforth i will follow the correct way to post my queries.

Thanks for sending reply,is it possible to export and import the encrypted data values or copy and paste the encrypted values.

Can you guys,please send me an script to backup and...

Hi,

Thanks for your answer,but we need powerpoint presentation to migrate the sqlserver 2000 and sqlserver 2005 to sharepoint database.

Thanks in advance,

Ram

Thanx for your valubable answer,can you give me step by step snapshots to configure the TCP/IP net libraries

Hi,

I want to access my local database through internet.

Moreover i want to connect my database out of lan network

ALTER TRIGGER [dbo].[Tg_Update_Service]

ON [dbo].[Table_name]

AFTER UPDATE

AS

BEGIN

-- SET NOCOUNT ON added to prevent extra result sets from

-- interfering with SELECT statements.

SET NOCOUNT ON;

DECLARE @ServiceLogID NVARCHAR(50)

DECLARE @ServiceID NVARCHAR(30)

DECLARE @Name NVARCHAR(100)

DECLARE...

Thank you for your valuable answer,

How can we change the article properties,If we change the article properties whether it will affect the exiisting replication process.

What about the replication performance if...

Hi Robert,

Sorry! My question is want to check the column names for a single table.

I got the answer for my question.

The answer is sp_columns 'table name'

Thanks for...