Skip to main content

Featured post

How to Insert line break in Text component in React Native

Hi, I was developing an application in react native.I have to handle lots of text data in this small react native application.I have used  Text component in react native many times. While working on this application,i had a requirement to display some text content with line breaks.I will explain it clearly with an example.I want to display a text as shown below  Welcome Please subscribe my channel I wrote react native code as shown below <View> <Text> Welcome Please subscribe my channel </Text> <View> When i run these lines of code,It will display text as shown below Welcome Please subscribe my channel   - instead of displaying in two lines with line break,it displays in a single line.So i have to find a solution to insert line break in Text component in React Native.After lots of research,i found a clean solution as shown below <View> <Text> Welcome{"\n"} Please subscribe my channel </Text> <View> Here ...
Read more
Labels

How To Set SQL Database Read Only Using SQL Server Management Studio and using SQL Query explained

Hi,


Today i will explain How to make a database Read only in MS SQL Server.In our work environment,may be there will be a requirement to set database status as read only.It can be because of many reasons.But making read only status is very critical decision. So i suggest to do  it only after serious discussions with your team memebers.

  • How To Set SQL Database Read Only  Using SQL Server Management Studio
  • How To Set SQL Database Read Only   using SQL Query


How To Set SQL Database Read Only  Using SQL Server Management Studio

For your better understanding,i will explain each step of making a database as ready only in SSMS step by step with proper images 


Open Database Properties Window

Our database is upsumdiary.We first open its properties window in order to set it as Read only mode

Database Read-Only Properties

As shown in above picture make Database Read-only status as True.Now let us check upsumdiary database in SSMS left panel


Database with Read-Only Mode


Now let us do the same with SQL Scripts

How To Set SQL Database Read Only   using SQL Query

SQL query for Read Only Mode





Thanks

Labels: