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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-01-02 : 08:29:45
|
| umasankar writes "i installed sqlserver2000 software in my system, it having a database server with name local, and i want create one more database server. How to create the server and how to add database, logins etc.," |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-01-02 : 23:54:52
|
| To create the server you need to install from the cd. This will prompt you for an instance name for the new server if it's on the same m/c as an existing instance.To create a new database see create database in bol.For logins see sp_grantlogin and sp_addlogin.seehttp://www.nigelrivett.net/SQLServerReleaseControl.htm==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
create a new server