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

Database

 
GeneralRe: SQL Server Management Studio Express Problem Pin
Vipin.d14-Oct-07 1:11
Vipin.d14-Oct-07 1:11 
QuestionInserting Only Distinct Items Pin
Ian Uy13-Oct-07 9:55
Ian Uy13-Oct-07 9:55 
AnswerRe: Inserting Only Distinct Items Pin
Giorgi Dalakishvili13-Oct-07 10:18
mentorGiorgi Dalakishvili13-Oct-07 10:18 
GeneralRe: Inserting Only Distinct Items Pin
Ian Uy13-Oct-07 18:18
Ian Uy13-Oct-07 18:18 
QuestionMS SQL Express Edition Username/Password Pin
Ian Uy13-Oct-07 9:52
Ian Uy13-Oct-07 9:52 
AnswerRe: MS SQL Express Edition Username/Password Pin
pmarfleet13-Oct-07 10:13
pmarfleet13-Oct-07 10:13 
GeneralRe: MS SQL Express Edition Username/Password Pin
Ian Uy13-Oct-07 10:15
Ian Uy13-Oct-07 10:15 
GeneralRe: MS SQL Express Edition Username/Password Pin
pmarfleet13-Oct-07 10:48
pmarfleet13-Oct-07 10:48 
Use the CREATE LOGIN[^] and CREATE USER[^] statements to create a new SQL login and grant it access to a database.

For example:

USE master
GO

-- Create database login
CREATE LOGIN Paul WITH PASSWORD='p@ssw0rd1'

USE myDB
GO
-- Assign login rights to access myDB
CREATE USER Paul FOR LOGIN Paul


You can do the same thing through the Management Studio UI.

Hope this helps.

Paul Marfleet

GeneralRe: MS SQL Express Edition Username/Password Pin
Ian Uy13-Oct-07 18:19
Ian Uy13-Oct-07 18:19 
QuestionLogin - User - Credentials Pin
DotNetWWW13-Oct-07 5:42
DotNetWWW13-Oct-07 5:42 
AnswerRe: Login - User - Credentials Pin
Hesham Amin13-Oct-07 22:56
Hesham Amin13-Oct-07 22:56 
QuestionCPU Utilisation Goes to 100% [modified] Pin
Bad Programmer13-Oct-07 5:30
Bad Programmer13-Oct-07 5:30 
AnswerRe: CPU Utilisation Goes to 100% Pin
Bad Programmer22-Oct-07 10:01
Bad Programmer22-Oct-07 10:01 
QuestionSQL QUERY Pin
Trustapple13-Oct-07 0:17
Trustapple13-Oct-07 0:17 
AnswerRe: SQL QUERY Pin
Blue_Boy13-Oct-07 1:50
Blue_Boy13-Oct-07 1:50 
GeneralRe: SQL QUERY Pin
Trustapple13-Oct-07 4:55
Trustapple13-Oct-07 4:55 
GeneralRe: SQL QUERY [modified] Pin
Blue_Boy13-Oct-07 5:17
Blue_Boy13-Oct-07 5:17 
GeneralRe: SQL QUERY Pin
Trustapple14-Oct-07 17:51
Trustapple14-Oct-07 17:51 
GeneralRe: SQL QUERY Pin
Blue_Boy15-Oct-07 11:32
Blue_Boy15-Oct-07 11:32 
QuestionSetting PRIMARY KEY using Alter Table Pin
Widgets13-Oct-07 0:02
Widgets13-Oct-07 0:02 
AnswerRe: Setting PRIMARY KEY using Alter Table Pin
GuyThiebaut13-Oct-07 0:40
professionalGuyThiebaut13-Oct-07 0:40 
AnswerRe: Setting PRIMARY KEY using Alter Table Pin
Mike Dimmick13-Oct-07 2:24
Mike Dimmick13-Oct-07 2:24 
GeneralRe: Setting PRIMARY KEY using Alter Table Pin
Widgets21-Oct-07 0:03
Widgets21-Oct-07 0:03 
QuestionDataGridView Filter Pin
udikantz12-Oct-07 22:13
udikantz12-Oct-07 22:13 
AnswerRe: DataGridView Filter Pin
GuyThiebaut12-Oct-07 22:35
professionalGuyThiebaut12-Oct-07 22:35 

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.