Thank you Mr. Perry for your wonderful article.. I will ask question if any doubts...

Hi

Today user reported to me, there is summary report not generated and application side throwing deadlock victim error by using as below view in application side..

So I have...

Hi.. I am really sorry for late updating due to some another migration task.

Please find the attached these procedures definition which are raised deadlock.

Thanks for your valuable suggestion.

Hi,

Thanks to all for yours valuable points.

1. I have taken backup of that CSV_Details tables before doing delete operation

2. In First query got deleted total 676839 row(s) affected and took...

Identified that root cause issues, error log file not expanding in ssms due to SQL Native client 11.0 - client protocols - shared memory disabled, It is opened in ssms...

Error log file opened out side of ssms as below location. But not opening at SSMS and there is no error message in event viewer at application side.

2015-05-19 18:23:45.61 Server...

yes. this only just started happening then after sometime error message display.

Thank you inputs from Experts..

As per Error messages

Message

Error: 18470, Severity: 14, State: 1.

Message

Login failed for user 'sa'. Reason: The account is disabled. [CLIENT: <local machine>]

sa account has been...

Thanks Lowell, It is working now..

management also not recommend to start the browser service. so in this case need to mention new port number in ODBC connection or web.config file...

Thank you Perry,

management plan itself working and deleted old days backup files after adding account in backup folder and given modify privileges.

I have tried manually run that script but not deleted old files

declare @DeleteDate nvarchar(50)

declare @DeleteDateTime datetime

set @DeleteDateTime = DateAdd(hh, -48, GetDate())

set @DeleteDate = (Select Replace(Convert(nvarchar, @DeleteDateTime, 111), '/', '-') +...

Thanks for posting wonderful script for schema change monitoring,

How will altered your whole script for monitoring stand alone instance only.. I don't want capture other instance thru dblink features...

Thanks

Pl. suggest me, Is there way to find out what are the transaction using more space in tempdb? any links.

I will discuss with application team to send report for tempdb...

I have one doubts.

Temdb Database side space was shirked by using shrinks command but HDD disk space not released

generally it will be free up space from HDD Once complete the...

Frequently facing space issues on tempdb. it is using more than 162GB always.

I have checked at tempdb properties it showing initial size is 750 MB for data file and 2...