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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Database Creation for a new User

Author  Topic 

rajavias
Starting Member

15 Posts

Posted - 2008-09-17 : 21:40:18
can anyone of you help to create a database in sql server 2005 for a new username?

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-09-17 : 21:52:03
What you mean by new user?
See "Create Database in books online"
Go to Top of Page

lepeniotis
Yak Posting Veteran

75 Posts

Posted - 2008-09-18 : 04:27:22
I cant understand what excactly do you mean. The syntax create database for a new username doesn't really privide guidance. Do you mean that you want to create a login or a user in an alreday existed database?? And this user is a student?? Or you want to create a database and in this database you want to add a only one user which is student? For the second assumption you can see the http://msdn.microsoft.com/en-us/library/aa258257.aspx or you can do it grafically by right click on the database folder on the object explorer. For the first assumption you can see this http://msdn.microsoft.com/en-us/library/dhw780c4(VS.80).aspx

I hope that this will help you.

MSc Advanced Computing Science
MSc Database Professional
Sheffield Hallam University
MCP (70-229, 70-228)
Industrial IT Engineer
Go to Top of Page
   

- Advertisement -