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.
| Author |
Topic |
|
rajavias
Starting Member
15 Posts |
 Posted - 2008-09-17 : 21:43:41
|
| as a database administrator how to create a database in sql server 2005 for a new username, for a student? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-17 : 21:53:00
|
| Dup Post:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=110854 |
 |
|
|
lepeniotis
Yak Posting Veteran
75 Posts |
Posted - 2008-09-18 : 04:26:54
|
| 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).aspxI hope that this will help you.MSc Advanced Computing Science MSc Database ProfessionalSheffield Hallam UniversityMCP (70-229, 70-228)Industrial IT Engineer |
|
|
|
|
|
|
database creation for a new username