Previlage
  Home FAQ Contact Sign in
 
Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...

found 3 articles for 0.000 sec
Re: Install SQL 2000 PE on XP Pro SP2     

Group: microsoft.public.sqlserver.setup · Group Profile · Search for Previlage in microsoft.public.sqlserver.setup
Author: Hari Prasad
Date: May 31, 2007 19:10

No, You need to be part of administaror group in local machine to install SQL Server. After thay you could configure a less previlage user with specific rights to SQL Server for the service startup account. Thanks Hari "KS Hawks" <KS Hawks@discussions.microsoft.com> wrote in message news:76350900-91A6-446D-A263-11F175E84B72@microsoft.com... Is there a way to install SQL 2000 PE ...
Show full article (0.64Kb) · Show article thread
Re: dbo.systypes     

Group: microsoft.public.sqlserver.setup · Group Profile · Search for Previlage in microsoft.public.sqlserver.setup
Author: Vicky
Date: Jan 14, 2007 09:08

...> For a database the owner will be one and we can designate multiple database owner role. This will give the users will DBO role to perform tasks coming under that role with out giving extra previlages. Use the below command to give DB_owner role to a db user. EXEC sp_addrolemember 'db_owner', 'DB_user' .IN SQL 2000 the maximum bytes a CHAR and NVARCHAR supports is 8000 bytes....
Show full article (1.58Kb)
Re: dbo.systypes     

Group: microsoft.public.sqlserver.setup · Group Profile · Search for Previlage in microsoft.public.sqlserver.setup
Author: Hari Prasad
Date: Jan 14, 2007 08:52

...For a database the owner will be one and we can designate multiple database owner role. This will give the users will DBO role to perform tasks coming under that role with out giving extra previlages. Use the below command to give DB_owner role to a db user. EXEC sp_addrolemember 'db_owner', 'DB_user' .IN SQL 2000 the maximum bytes a CHAR and NVARCHAR supports is 8000 bytes. The float...
Show full article (1.11Kb) · Show article thread