Hi,

Thanks for the reply.

Can you elaborate what exactly the restore will do internally.(Internal process)

Regards,

Sandhya

Hi,

Thanks for the reply.

Is there any way to reduce the size of the temdb now ?

HI Experts,

I would like to add one more point here.

No information is logged in the sql server error logs at the time of the failure of the SP

Regards,

Sandhya

HI All,

As per the article I have created the AUDITLOG table and also created the trigger.

But when executed some DDl commands the AUDITLOG table is not working as expected.

CREATE...

Hi Ratheesh,

Can you please give me the code that solved your issue.

Iam also looking for the same query and conditions.

Thanks,

Sandhya.

Hi All,

Thanks for the reply.

We have single publisher to single subscriber replication.

I checked and found that the disributor agent job is scheduled to run once in every 15 mins and...

Hi All,

Iam also getting the same error. But the strange thing is that for only one particular employeeid we are getting the error.

For all employeeid's(while generating the report) we are...

Hi to all,

Thanks for the prompt response.

In my select query no linked servers are there and we are using the NOLOck options also.

Below is sample example of my query.

SELECT ...

Thanks to All.

Suppose if i want to copy a table from one server to another server

what is the best approach to do this task.

Thanks,

Sandhya

As per the down stream requirements we need to stop the repliaction and let their job to run.

After completing their job we have to start the replication.

Kindly suggest...

hi,

I don't want to remove the replication permanently.

For temporary purpose (just for 2-3 days)

and again how to start the replication

Thanks,

sandhya

Yes.

You can script the logins on source server then apply script on target server

Hi I don't know how to scipt the logins.Could you kindly tell me how to script the...

Thanks for your answer.

I want to know whether log A and log B has the same transactions or not

Thanks for all of you for your good answers.

Now iam able to uinderstand what happens exactly.

But i have a small doubt.

Index rebuild means it will drops the existing one and...