Thanks

From the sp_who2

the status of the select statement is in suspended.

Is suspend & sleeping spids also causes the blocking?

Yes. Has the access also the job never failed.

First backup then cleanup the files older than 3 days Extension is bak

Does enabling the TCP\IP protocal requires restarting the sql server

I tried using nvarchar(max) and imported. But when I tried to open I am getting error out of memory exception.

I tried changing extension from xml to txt and opened using...

Thank you

I am not getting the info from the other team.

They said that is automated process (job). I am not sure how can I import that to SQL Server.

When I use...

No. I didn't increase the time because I am not getting any more error message now

I see the default db is already Master.

is this possible to have link with protocols?

Thank you

Both of them are MicrosoftSqlServer 2014.

I selected the management studio from the Microsoft SQL Server 2014 folder in both machines.

Hi,

Here is what I am seeing.

I have SQL Non-Cluster 12.0.2254, which I can able to select top 1000 from msdb using GUI.

And I have SQL Server Cluster 12.0.4213, which I...

It is in sleeping mode. I didn't see that SPID from exec_requests but when I tried to alter it causing bloking

There are no other spids except the SQL Agent Refresher which is running the command

EXECUTE msdb.dbo.sp_sqlagent_refresh_job @job_id = 0x50577E0073C2FF47BA806DB7AB740641.

What it will trying to do? Assuming, if I stop the SQL...

How do you know you are running a large transaction that required more log space?

Is there anyway that we can figure out how much log space it require for a...