Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

QSQL command and default database

Status
Not open for further replies.
steveot

steveot

IS-IT--Management
Joined
Oct 27, 2003
Messages
1,635
Location
US
Anybody know a OSQL command to

1) Query a user and determine the users default database
2) Change the user default database using OSQL

Using NT authenication
 
Sort by date Sort by votes
I'm not sure about getting the current default database, but you can change it with this...

Code: 
osql -s[!]ServerName[/!] -E -Q"sp_defaultdb '[!]LoginName[/!]','[!]DefaultDatabase[/!]'"

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom
 
Upvote 0 Downvote
Would the loginname be domain\username format?
 
Upvote 0 Downvote
yes


-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

peac3
  • Locked
  • Question Question
Gaps and islands
Replies
8
Views
918
Chris Miller
Chris Miller
leifoet
  • Locked
  • Question Question
How can I update the input of a form (rows and columns) to the database in one query ?
Replies
1
Views
535
Chris Miller
Chris Miller
peac3
  • Locked
  • Question Question
Derive staus date time by aligning start and end datetime
Replies
7
Views
919
Andrzejek
Andrzejek
grnzbra
  • Locked
  • Question Question
Adding Text to and XML Field
Replies
2
Views
438
grnzbra
grnzbra
TheBugSlayer
  • Locked
  • Question Question
Transaction with SELECT and UPDATE with XLOCK causing deadlocks
Replies
10
Views
1K
gmmastros
gmmastros

Part and Inventory Search

Sponsor

Back
Top