Failed to update database because the database is read-only | Failed to update database "XXXXXX\APP_DATA\DBSQAFTP.MDF" because the database is read-only in iis

Introduction:

Here I will explain how to solve the problem Failed to update database "XXXXXX\APP_DATA\DBSQAFTP.MDF" because the database is read-only during the time of publish application using asp.net.

Description:

I deployed one of my website in IIS and trying to test the application during that time I got error like this

What are the Differences between ASP.NET 3.5 and ASP.NET 4.0 | What are new features in Asp.net 4.0

Introduction

Here I will explain about differences between Asp.net 3.5 and Asp.net 4.0. 

Description

In previous post I explained differences between asp.net 1.0 and asp.net 2.0 and in another post I explained differences between asp.net 2.0 and asp.net 3.5 . Now I will explain about differences between asp.net 3.5 and asp.net 4.0.

What are the Differences between asp.net 1.0, asp.net 1.1 and asp.net 2.0

Here I will explain about differences between asp.net 1.0, 1.1 and 2.0 versions. 

Asp.net 1.0 & 1.1 version

In these Asp.net versions IIS should be installed by user.  

Asp.net 2.0 version

In this version IIS comes along with dotnet installation no need to install separately and in Asp.net 2.0 many new features has came into picture like partial classes, master pages, skins and themes, roles and membership profiles, Generics and many new controls etc. I will explain each feature clearly. Main purpose of Asp.net 2.0 is used to increase productivity, use same controls for all types of devices, faster and better web application.

what are the Difference between ASP.NET 2.0 and ASP.NET 3.5 | Multi Targeting in asp.net | what are the Asp.net 3.5 features

Here I will explain about differences between asp.net 2.0/3.0/3.5. Generally we will see the questions like difference between Asp.net 2.0, 3.0 and 3.5 but there is no Asp.net 3.0 version. We have a version of 3.0 .NET Framework.

Asp.net create watermark text for textbox in javascript

Introduction

In this article I will explain how to create or set watermark text for textbox using JavaScript.

Description:

One day I got requirement like showing watermark text in textbox to achieve this requirement I used JavaScript functionality for that first Design your aspx page like this 

Interview Questions Part-7 | What is a deadlock in SQL Server | What are “GRANT” and “REVOKE’ statements in SQL | How do you find the Second highest Salary in SQL Server

What is a deadlock in SQL Server?

Deadlock is a situation when two processes, each having a lock on one piece of data, attempt to acquire a lock on the other’s piece. Each process would wait indefinitely for the other to release the lock, unless one of the user processes is terminated.

Interview Questions Part-6 | What is @@ROWCOUNT in SQL | What is Difference between Commit and Rollback in SQL | What is Candidate key, alternate key and composite key in SQL | What are Isolation Levels in SQL | What is Lock Escalation in SQL Server

What is the Use of @@ROWCOUNT?

Returns the number of rows affected by the Query.

Ex:

UPDATE authors SET au_lname = 'Jones'

WHERE au_id = '999-888-7777'

IF @@ROWCOUNT = 0

print 'Warning: No rows were updated'

Interview Questions Part-5 | What is PRIMARY KEY Constraint in SQL Server | What is UNIQUE KEY Constraint | What is FOREIGN KEY Constraint | What is CHECK Constraint | What is NOT NULL Constraint in SQL Server ?

What is PRIMARY KEY Constraint in SQL Server?

Primary key constraint is used to uniquely identify each record in database table. It won’t allow repetition or duplication of data. Each table is having only one primary key constraint and it contains only unique values. Primary key constraint doesn’t accept null values (Read more Here)

Interview Questions Part-4 | What is the Difference between a HAVING clause and a WHERE clause in SQL Server | What is Connection Pooling and why it is used | What are the Authentication Modes in SQL Server | What is the difference between UNION and UNION ALL | What is Identity in SQL Server

What is the Difference between a HAVING clause and a WHERE clause in SQL Server? 

They specify a search condition for a group or an aggregate. But the difference is that HAVING can be used only with the SELECT statement. HAVING is typically used in a GROUP BY clause. When GROUP BY is not used, HAVING behaves like a WHERE clause. Having Clause is basically used only with the GROUP BY function in a query, whereas WHERE Clause is applied to each row before they are part of the GROUP BY function in a query

Interview Questions Part-3 | What is an Index in SQL Server | What is the Difference between Clustered and a Non-clustered Index in SQL Server | What is Collation | What are Primary Keys and Foreign Keys in SQL Server | What’s the Difference between a Primary Key and a Unique Key in SQL Server

What is an Index in SQL Server?

An index is a physical structure containing pointers to the data. Indexes are created in an existing table to locate the data more efficiently and quickly (Read more Here)