February 10, 2006 at 6:47 am
I have used sql server to connect to remote db's and perform queries, but I have never set up a local db from scratch. Can someone give me (or point me to) directions on how to create the db, set the user and password etc? I am attempting to set up an ASP .NET application, and I need a local db to do testing on before I move to a production server.
Thanks
February 10, 2006 at 11:22 am
You could install sql server express 2005 http://msdn.microsoft.com/sql/express/
The documentation you can download at
With this tool you can manage the express database
if you need to test specific for sql server 2000, you can use sql server 2000 developer edition or perhaps your visual studio license.
*CREATE TABLE creates a table
*CREATE DATABASE creates a database
sp_grantdbaccess grants an user access to the database
GRANT SELECT on ... to user gives the user the permission
*sp_grantlogin /sp_addlogin add a login for the server
February 10, 2006 at 11:25 am
I already have SQL Server 2000 installed, and this is what I am limited to. I just need to know how to create the local db and users, assign permissions etc.
February 10, 2006 at 11:41 am
This site has a tutorial for sql server administration;
http://www.informit.com/guides/content.asp?g=sqlserver&seqNum=177
Do you plan to use a gui (SQL server enterprise manager) to manage the database/users or via T-SQL statements (query analyzer ...)
*adding users/roles
http://www.sqlservercentral.com/columnists/awarren/loginsusersandrolesgettingstarted.asp
*The books online are an excellent resource to look up a command, almost every topic has an example.
Just typing create database as keyword brings up 3 topics.
*for further intriguing articles
http://www.sqlservercentral.com/articles/articleList.asp?categoryid=24
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply