How do you connect to SQL server instance and disconnect from SQL server instance?
Experience Level: Junior
Tags: DatabasesQuality Assurance (QA)
Answer
There are two types of SQL server instances.
- Default instance
- Named instance
For connecting to Default instance, you specify only the server name. Example: SERVERNAME
For connecting to Named instance, you specify server name and instance name. Example: SERVERNAME\MYINSTANCE
Related Databases job interview questions
What is localhost?
DatabasesQuality Assurance (QA) JuniorWhat is Microsoft SQL Server instance?
DatabasesQuality Assurance (QA) MediorHow would you install Microsoft SQL Server Management Studio?
DatabasesQuality Assurance (QA) JuniorHow would you run SSMS (Microsoft SQL Server Management Studio)?
DatabasesQuality Assurance (QA) JuniorWhat is SSMS?
DatabasesQuality Assurance (QA) Junior
Chat
Oh, the operator is not available. Leave us your comments. We will answer all your questions as soon as possible.
Anonymous
Καλησπέρα.
Καλησπέρα.
Anonymous
the infinteis -3/15 so 1triition / infinet
the infinteis -3/15 so 1triition / infinet
Anonymous
e
e
Anonymous
<a href="https://inspirum.pl "
<a href="https://inspirum.pl "
Anonymous
[url]https://inspirum.pl[/url]
[url]https://inspirum.pl[/url]
LaceJaguar65
e
e
LaceJaguar65
e
e
LaceJaguar65
e
e
LaceJaguar65
e
e
LaceJaguar65
e
e
LaceJaguar65
e
e
LaceJaguar65
e
e
LaceJaguar65
e
e
LaceJaguar65
e
e
LaceJaguar65
e
e
LaceJaguar65
e
e
LaceJaguar65
e
e
LaceJaguar65
e
e
LaceJaguar65
e
e
LaceJaguar65
e
e
LaceJaguar65
e
e
LaceJaguar65
e
e
LaceJaguar65
e
e
LaceJaguar65
e
e
LaceJaguar65
e
e