Last time one of my friend asked me to how can i change the own password in SQL Server? Why
Continue readingCategory: SQL Server -DBA
SQL Server -DBA, SQL Server Services, who dropped or altered tables,procedures or databases in SQL Server, What in SQL Server
How to find out the SQL Server Properties?
You can execute below query to get SQL Server Properties:- create table #server(ID int, Name sysname null, Internal_Value int null,
Continue readingHow to check the database Properties in SQL Server?
You can execute the below query to get the database property information:- select sysDB.database_id, sysDB.Name as ‘Database Name’, syslogin.Name as
Continue readingHow to find that when was the last time SA account property or password changed ?
We can find out last modification date of SA account through below query:- USE Master GO SELECT [name], sid, create_date,
Continue readingWhy SQL Server service is not starting?what are common reasons for failures?
These are common reasons for failures:- SQL Service account password has been changed but not updated at SQL Server Services
Continue readingHow to Find and Fix Orphaned Users in SQL Server
After the migration of SQL Server databases we have to find the orphan users In SQL Server & need to
Continue readingHow to make faster DBCC check db execution process?
Below query enforces an exclusive lock on database, which increase the execution faster of DBCC command:- DBCC CHECKDB (‘Prod1DB’) WITH
Continue readingHow to recover lost or forget administrator SA Password In SQL Server?
I am going to show you how to recover Sysadmin Password through SSMS:- Kindly follow the below Steps: 1. Stop
Continue readingWhat is Resource Database in SQL Server ?
Resource Database Read-only hidden database that contains all the system information Can’t back up the Resource database Must copy paste
Continue readingHow to find When was your database last used or accessed ?
Use < your_DatabaseName> GO SELECT DB_NAME() as DatabaseName,s1.sql_handle,(SELECT TOP 1 SUBSTRING(s2.text,statement_start_offset / 2+1 ,( (CASE WHEN statement_end_offset = -1THEN (LEN(CONVERT(nvarchar(max),s2.text)) * 2)ELSE statement_end_offset END) – statement_start_offset) /
Continue reading