Open SSMS ( SQL SERVER MANAGEMENT STUDIO ) ==> Right click on the instance ==> New Query and paste the below code to find the Auto Shrink status
USE [master]
GO
CREATE DATABASE [Database Name] ON
( FILENAME = 'path\database.mdf'),
( FILENAME = 'path\database.ldf')
FOR ATTACH
GO
USE [master]
GO
CREATE DATABASE [Database Name] ON
( FILENAME = 'path\database.mdf'),
( FILENAME = 'path\database.ldf')
FOR ATTACH
GO
