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, 3599🔥, 0💬
Popular Posts:
What Is SQL*Plus in Oracle? SQL*Plus is an interactive and batch query tool that is installed with e...
Collections: Interview Questions MySQL Tutorials MySQL Functions Oracle Tutorials SQL Server Tutoria...
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...
What is test testing area for? The testing area is provided to allow visitors to post testing commen...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...