Click here to Skip to main content
15,908,674 members
Home / Discussions / Database
   

Database

 
GeneralIncorrect Reporting Service instance name during SQL server 2005 SP3 installation Pin
Vipul Mehta15-Jul-12 22:55
Vipul Mehta15-Jul-12 22:55 
Questionlogin page Pin
Dinesh kumar tomer15-Jul-12 18:44
Dinesh kumar tomer15-Jul-12 18:44 
AnswerRe: login page Pin
ManishaSCode15-Jul-12 19:25
ManishaSCode15-Jul-12 19:25 
AnswerRe: login page Pin
Paul Conrad16-Jul-12 10:55
professionalPaul Conrad16-Jul-12 10:55 
QuestionCan a SQL login have more than one user Pin
yousefshokati14-Jul-12 19:53
yousefshokati14-Jul-12 19:53 
AnswerRe: Can a SQL login have more than one user Pin
Mycroft Holmes14-Jul-12 20:27
professionalMycroft Holmes14-Jul-12 20:27 
GeneralRe: Can a SQL login have more than one user Pin
yousefshokati14-Jul-12 20:50
yousefshokati14-Jul-12 20:50 
GeneralRe: Can a SQL login have more than one user Pin
Mycroft Holmes14-Jul-12 22:28
professionalMycroft Holmes14-Jul-12 22:28 
Ah, more context...

Yes a user can have many connections, an example would be using SSMS each query window creates it's own connection using your credentials. If, in SSMS, you look at the activity monitor you will find multiple SID per login.

You terminology is difficult, what do you mean by a User. A database is only interested in a connection, each connection has credentials. A set of credentials (presumably your User) may login multiple times.
Never underestimate the power of human stupidity
RAH

AnswerRe: Can a SQL login have more than one user Pin
ManishaSCode15-Jul-12 3:34
ManishaSCode15-Jul-12 3:34 
GeneralRe: Can a SQL login have more than one user Pin
Jan Steyn16-Jul-12 0:34
Jan Steyn16-Jul-12 0:34 
AnswerRe: Can a SQL login have more than one user Pin
rimazuc17-Jul-12 0:07
rimazuc17-Jul-12 0:07 
QuestionSql query that sorts data by top quantity per category Pin
Hardz13-Jul-12 16:49
Hardz13-Jul-12 16:49 
GeneralRe: Sql query that sorts data by top quantity per category Pin
PIEBALDconsult13-Jul-12 19:00
mvePIEBALDconsult13-Jul-12 19:00 
AnswerRe: Sql query that sorts data by top quantity per category Pin
__TR__15-Jul-12 0:49
__TR__15-Jul-12 0:49 
GeneralRe: Sql query that sorts data by top quantity per category Pin
Hardz15-Jul-12 15:18
Hardz15-Jul-12 15:18 
GeneralRe: Sql query that sorts data by top quantity per category Pin
Luc Pattyn15-Jul-12 16:27
sitebuilderLuc Pattyn15-Jul-12 16:27 
GeneralRe: Sql query that sorts data by top quantity per category Pin
Hardz15-Jul-12 16:50
Hardz15-Jul-12 16:50 
Questionmake a databse with ADO.Net Pin
messages13-Jul-12 4:50
messages13-Jul-12 4:50 
AnswerRe: make a databse with ADO.Net Pin
Sandeep Mewara15-Jul-12 0:15
mveSandeep Mewara15-Jul-12 0:15 
Questionshould i Make new database after Financial year Pin
Varinder Raii11-Jul-12 20:57
Varinder Raii11-Jul-12 20:57 
AnswerRe: should i Make new database after Financial year Pin
Richard MacCutchan11-Jul-12 23:33
mveRichard MacCutchan11-Jul-12 23:33 
AnswerRe: should i Make new database after Financial year Pin
Eddy Vluggen11-Jul-12 23:39
professionalEddy Vluggen11-Jul-12 23:39 
AnswerRe: should i Make new database after Financial year Pin
PIEBALDconsult13-Jul-12 3:51
mvePIEBALDconsult13-Jul-12 3:51 
QuestionGenerate Excel From SQL Pin
vvashishta11-Jul-12 19:48
vvashishta11-Jul-12 19:48 
AnswerRe: Generate Excel From SQL Pin
PIEBALDconsult11-Jul-12 19:54
mvePIEBALDconsult11-Jul-12 19:54 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.