What is the name of the data source when we use SQL Server Express Edition?

 Posted by Ddd on 3/24/2011 | Category: ADO.NET Interview questions | Views: 3304 | Points: 40

It is specified in the connection string.
The complete connection is like this:

Data Source=.\SQLEXPRESS;AttachDbFileName=c:\abc.mdf;Integrated Security=True;
User Instance=True

It is presumed that abc.mdf file exists in c drive. abc.ldf must also be there.
Integrated Security is used to authenticate SQL Server Express Edition.
User Instance=true. It starts SQL Server Express Edition using the current user's

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response