You can configure the mirror for databases on Server A

But you cannot do the mirror for databases on Server B.

there is no any relation to database recovery mode

you can use profiler on third server to Monitor the sql statements which cause the CPU high.

or

get the sql statements from the DMV.

No. SSMS is not same as configuration manager.

if it is sql server 2008 or 2008 r2, you can type sqlservermanager10.msc

if 2012,please type sqlservermanager11.msc

Btw,there is no any operation system whose number...

you can firstly create the DBLink using GUI, and then generate the script.

then you can some interesting parameters.

BTW, why you use DBLink when configuring updated transnational replication

Actually, I do not know what you want to do.

migration or upgradation ?

If you have another server for migration and the server has the same or better hardware, you can do the side by side migration. and then you can control the...

No, this is no any way to match your requirement.

firstly, you should check how long will your sp runs.

then find whether can optimize it.

For example, it ran for 10 minutes one time. if you can optimize it(reduce the running...

I have found...

actually, we use receive top 1 in the interface sp.

i think what you need to do is:

1. increase the max_queue_readers parameter in the queue definition. the default is 1. you...

jacksonandrew321 (8/23/2014)

You can...

USE [master]

GO

EXEC master.dbo.sp_serveroption @server=N'YourServerName', @optname=N'data access', @optvalue=N'true'

GO

you can use this script to add the data access permission in the linked server

Hi, in your post, you can find the data in the [Log Record] of fn_DBLog feedback.

but the string is too long.

/**

create table c (name char(5))

insert into c select 'wison'

**/

the [Log...

It is SQLServer 2008 R2 RTM, Enterprise Edition(X64) on both sides of the mirror