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....
|