Thanks Perrry for your replay...

Can always On setup by using standalone SQL instance with local HD, In this scenario, Does it require to meets pre -requisites on both the nodes?...

1. We are not using shared storage for current setup of always On availability group due to budgets constraints.. can be able to configure without SAN shard storage?

2. My requirement...

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...