Open the SQL Server Management Studio.

Open a New Query.

Copy, paste, and execute the following:

GO

...

Reset SQL SA Password in SQL Server Using SQL Server Management Studio

1. Connect to SQL Server Using SQL Server Management Studio 2. Expand Security -> Logins -> Right click sa...

Change SA Password in SQL Server Using SQL Server Management Studio

1.Connect to SQL Server Using SQL Server Management Studio 2. Expand Security -> Logins -> Right click sa to open...

Try and run this

DBCC CHECKDB (Database name) WITH NO_INFOMSGS, ALL_ERRORMSGS

The first, best solution if DBCC CHECKDB reports consistency errors is to restore from a known good backup. However, if you cannot restore from a backup, then CHECKDB provides a...

Here are few steps by which you can drive out your SQL database from recovery mode and perform action on it.

First step is to stop the SQL Services

Then change the...

If you persist error while attaching SQL MDF File that mean the MDF file is corrupted you need to restore it from full backup or use any SQL recovery application...

hi

As you know that DBCC CHECKDB Command's checks the logical and physical consistencies of the pages, clustered index etc. if he finds some some change or check fails then...

Hi

I also tried to search a right solution for successful login in SQL Server but there is no solution available then i try third party tool for sql password...

Go through SSMS to attach MDF file

1.Right click on Object explorer's Databases and select attach option

2. A window appears on the screen then click on ADD Button

3. Then you...

Go through this way

1.Right click on the database in SQL Server Management Studio, and hit Detach.

2.Select the Drop Connections checkbox only, and hit ok.

3.Then the database will disappear.

4.Right...

Using SSMS is the simplest way to attach MDF file without LDF file. I mentioned some steps in which you can execute this task.

Firstly open the SSMS and then choose...