Posted by raylopez99 on 03/29/07 10:43

On Mar 28, 3:45 pm, Erland Sommarskog <esq...@sommarskog.se> wrote:
> raylopez99 (raylope...@yahoo.com) writes:

> WHen you connect with some other Windows user, no get no such extra
> thrills, but you need to grant that login rights to do things. For instance
>
> GRANT CREATE DATABASE TO DOMAIN\PowerUser
>
> You can also add that user a role which has the privileges you want,
> for instance to the sysadmin role.
>
> --
> Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
>

Erland Sommarskog-- thanks.

At the risk of looking even more stupid, if you know of how to "also
add that user a role which has the privileges you want, for instance
to the sysadmin role" within Visual Studio 2005 and/or Windows XP (for
the program SQL Server 2005 Express Edition), please feel free to let
me know. I just want to add the Power User to have Administrator
access for the Visual Studio 2005, when working on ADO.NET (SQL Server
2005), not for all programs, if possible. For now I will simply
program while logged in as an Administrator, which seems to be a good
workaround to my problem.

I've also ordered some books on ADO.NET and SQL SERVER from O'Reilly
and Microsoft Press; if you have any favorites for a C#/C++ programmer
hobbiest, let me know.

RL

[Back to original message]