JaedenRuiner
Well-known member
- Joined
- Aug 13, 2007
- Messages
- 340
- Programming Experience
- 10+
Okay,
I've got all the user stuff and the mixed mode login but i'm having issue with the management studio reverting to a singular database: master.
Basically, I've tried setting the "default database" for the user account, and for my Windows Authentication account, I've tried on the connect "options" screen to define which database i'm logging into with the Manager Studio, but once i'm logged in, and I run
I keep getting "master" as the current database. The Win Auth account i'm using i have flaged as "sysadmin" in the server roles, but i'm trying to tell it to log into "MyDb" so that when I run Select Into ro Create Table statements I don't have to always prefix them with:
MyDb.Dbo all the time. Otherwise they defaultly create or manipulate the Master database.
thanks
Jaeden "Sifo Dyas" al'Raec Ruiner
I've got all the user stuff and the mixed mode login but i'm having issue with the management studio reverting to a singular database: master.
Basically, I've tried setting the "default database" for the user account, and for my Windows Authentication account, I've tried on the connect "options" screen to define which database i'm logging into with the Manager Studio, but once i'm logged in, and I run
VB.NET:
select DB_NAME() as [CurDB];
I keep getting "master" as the current database. The Win Auth account i'm using i have flaged as "sysadmin" in the server roles, but i'm trying to tell it to log into "MyDb" so that when I run Select Into ro Create Table statements I don't have to always prefix them with:
MyDb.Dbo all the time. Otherwise they defaultly create or manipulate the Master database.
thanks
Jaeden "Sifo Dyas" al'Raec Ruiner