Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Testing a Login From Command Line

Author  Topic 

jbates99
Constraint Violating Yak Guru

396 Posts

Posted - 2012-06-12 : 15:14:55
I'm trying to test a login whose password is "supposedly" blank.

This is the syntax I used from a command prompt:

osql -S EGNSOCWCOM09 -U XJNETMASTER -P -Q "select * crewsked.dbo.UR_Users"

Do I have the password part coded correctly for a blank password?

Thanks, John

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-06-12 : 15:17:17
I can't remember, but you can easily verify if that's the password by testing it with SSMS.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -