Hi,

Get SQL server information in OS registry levels.

Irrespective of the version of SQL Server, information is saved in the registry. Only the location changes for various versions. The path in...

Hi,

We know that restarting of SQL server agent is an simple tasks how ever I just want to share the below info....

Always try to gather the below information ,Before restarting...

Hi,

It is always good practice before revoking DBO role,identify what user has the permission on database level &it's Objects.

Once in Handy ->You can perform through the GUI i,e if that...

Hi Pradeep,

I beleive in my case it is different and I was tracking the same during that time.

let me Await for that type of situation once again and I will...

Yes I will add it ;-), But I went through some articles and someone's answers it was an totaly different Answers --Like delete Maintenance plan and recreate it...etc..

Thanks &Regards,

RamaUdaya.K

Hi,

Thnx for your Script, yes we can find out topn usuage by the queries and also script also the GUI, But How can I anaylaze in what basis...

Thnx once again....

Regards,

RamaUdaya.K

Hi,

Please check your autogrowth of your data files if you have many either you need work with the Autogrowth settings accroding to your conveninence some time you may get an...