Thank you all for ur replies . The installed version is ssms 18.1 which debug is deprecated by microsoft. Not sure y they have done. So I uninstalled the SSMS...

Yes you are right. From the network path folder the files were not deleting.

I mentioned delete files older than 3 days.

Thank you very much for your replies.

while connecting the remote server ip in the management studio, in the options i selected TCP/IP and timeout period to '0'. Then it worked...

i changed the samesubnetthreshold value. 
$clust = Get-Cluster;$Clust.Samesubnetdelay=1000; $clust.SamesubnetThreshold = 40

Yes. This is sql 2014 and 12.0.5207.0 version.

sure i wil do that now. thanks.

Thank you very much for your reply. Fragmentation cleanup means index rebuild right.. 
I have taken log backup of that db.. So what do u want me to do with...

I am M getting as 'No active transactions'....:(

Gail Shaw,

I have executed dbcc opentran.

their is no open transactions .

And after configuing peer-peer topology,In replication monitor Publication is running in poor condition. And for other server its not...

No this is not an interview question.:)

This is my TL requirement.:(

Anyhow thanks for your reply.

Another way to get :

SELECT DISTINCT SPROC=SPECIFIC_NAME

FROM [msdb].[INFORMATION_SCHEMA].[ROUTINES]

CROSS JOIN msdb.dbo.sysjobsteps

WHERE Command like ('%'+SPECIFIC_NAME+'%')

Thanks for replying..:)

Got it.:)

Declare @sql nvarchar(MAX)

Set @sql = ''

Select @sql = @sql + 'USE ' + name + '

select '''+name+''' as DBName, p.name as...