Tweet
To prevent SQL injection which hits database,one may change status of database to read only.
Follow the below mentioned steps to change status of SQL Server Database to Read-Only:
1.Precaution: Take a backup of database before making any changes
2.Login to SQL Server management studio
3.Run following query
ALTER DATABASE [DBNAME] SET READ_ONLY WITH NO_WAIT
(Here DBNAME is your database name)
4.With your object explorer, you will find database in read only status
Park B
Accuwebhosting.com
Follow the below mentioned steps to change status of SQL Server Database to Read-Only:
1.Precaution: Take a backup of database before making any changes
2.Login to SQL Server management studio
3.Run following query
ALTER DATABASE [DBNAME] SET READ_ONLY WITH NO_WAIT
(Here DBNAME is your database name)
4.With your object explorer, you will find database in read only status
Park B
Accuwebhosting.com
