SQL Server 7

[tramirez]

Good Morning,
I am learning Sql server 7 and have recently set up a new account as public. I would like to create views, write sql statements and so on; however, public does not allow a whole lot of feasibility. I have the option of being the sa, but that's a little to scary (too much control). Could someone please tell me what type of account I need to set up in order to learn sql without getting into to much trouble.

Thanks in advance and have a wonderful day.

Thank you,
Tracy

[Cakkie]

I think you should add yourself to the dbo (database owner) role. This will give you the rights to create and manage databases, but will not let you do those crazy things the sa can do.

Tom Cannaerts
slisse@planetinternet.be

The best way to escape a problem, is to solve it.

[tramirez]

Thank you that is exactly what I was looking for. I knew there ought to be an account you could create that could do more than public and less than the sa. Now I can actually create somethings. Thanks again for you help. Have a great day.

Thank you,
Tracy