Home » Posts tagged 'SQLCMD'

Tag Archives: SQLCMD

How to get list of all available parameter of .EXE file ?


Today, We discuss How to get list of all available parameter of .EXE file OR How to find list of SQL Server setup parameters ?

Major problem is of all available parameter details. Sometime, We need to pass parameter to .EXE file to get some different & superior functionality.

We can get details of available parameters by passing “/?” to any .EXE file in windows cmd.

Example 1 : Check parameter of SQL Server Setup

List of parameters

Example 2 : Check parameter of Procmon.exe (other than SQL Server)

List of parameters

If you liked this post, do like on Facebook at http://www.facebook.com/mssqlfun

Reference : Rohit Garg (http://mssqlfun.com/)

Microsoft SQL Server License Helpline


Microsoft SQL Server license has lots of flavors in terms of user based \ CAL or processor based license, license based on versions or license based on environment (physical or virtual).

Although, Microsoft release license guidelines for each & every SQL server version. But there are more complex scenarios for licensing then we think.

Best person to answer your all queries over licensing is MICROSOFT itself.

You can call Microsoft Licensing at 1-800-426-9400, Monday to Friday, 6:00 A.M. to 6:00 P.M. (Pacific Time) to speak directly to a Microsoft licensing specialist.

If you liked this post, do like on Facebook at https://www.facebook.com/mssqlfun

Reference : Rohit Garg (http://mssqlfun.com/)

SQL Server Reserve 1 user connection for DAC (Dedicated Administrator Connection)……want to confirm ?


Sometime before, I was giving training on basics of SQL Server. One of attendee is having doubt & want to confirm that SQL Server really Reserve 1 user connection for DAC (Dedicated Administrator Connection).

So I decide to show a demo for the same. I have changed the no. of User Connections to 1 & then try to login. So below is the PROOF.

Steps Performed for Demo

1. User Connections Current settings

2. User Connections New settings. You need to restart SQL Services after this.

3. I Try to Login to SQL Server by SSMS & got Error. But Why ?

4. I Try to Login to SQL Server by SQLCMD & got Error. But Why ?

5. Reason of getting error at step 3 & 4 is DAC (Dedicated Administrator Connection). SQL Server reserve one user connection for DAC.

6. Rollback the changes using DAC & come back to previous settings. You need to restart SQL Services after this.

7. User Connections After Rollback

If you liked this post, do like on Facebook at https://www.facebook.com/mssqlfun

Reference : Rohit Garg (http://mssqlfun.com/)

Follow

Get every new post delivered to your Inbox.

Join 217 other followers