Collections:
Verifying a User Name with SQLCMD Tool in SQL Server
How To Verify a User name with SQLCMD Tool in SQL Server?
✍: FYIcenter.com
The quickest way to verify a user name in a database is probably to use the SQLCMD tool. You can connect to the server, select the database, and check which user name is linked the current login name as shown below.
Start a command window and enter the following command:
C:\>SQLCMD -S LOCALHOST\SQLEXPRESS -U Fyi_Login -P IYF 1> USE FyiCenterData; 2> GO Changed database context to 'FyiCenterData'. 1> PRINT User_Name(); 2> GO Fyi_User
This shows user "Fyi_User" in database "FyiCenterData" is linked to login name "Fyi_Login".
⇒ "ALTER USER" - Changing the Name of a Database User in SQL Server
⇐ Finding the Login Name Linked to a Given User Name in SQL Server
2017-08-25, 4045🔥, 0💬
Popular Posts:
How to set the current database in SQL Server? Once you are connected to the SQL Server, you should ...
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...
What is test testing area for? The testing area is provided to allow visitors to post testing commen...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL? If you want ge...