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.
| Author |
Topic |
|
jbates99
Constraint Violating Yak Guru
396 Posts |
 Posted - 2012-06-07 : 12:11:49
|
| Hi everyone,Sorry, this applies to SQL Server 2000, but that forum gets little attention.I have an older instance (2000) that I need to test a login for.So I cannot use the sqlcmd utility. How can I do this from the command line?Thanks, John |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-06-07 : 12:16:19
|
Use the osql utility: http://goo.gl/ygnX0quote:
Sorry, this applies to SQL Server 2000, but that forum gets little attention.
Not true, there are numerous responses over the past few days. All of the forums show up under the Active Topics page. |
 |
|
|
jbates99
Constraint Violating Yak Guru
396 Posts |
Posted - 2012-06-07 : 14:43:18
|
| Thanks, robvolk.And for anyone interested, this is the syntax I used:>osql -S EGNSOCWCOM09 -U CrewWebUpdater -P iluvxj -Q "select * from crewsked.dbo.UR_Users" |
|
|
|
|
|
|
How to Connect to SQL 2000 from Command Prompt