Hello. What would be the best role assignment for a temporary consultant to
access one of our user created databases on our sql2k server to allow this
person to develop freely but only within this database and not any of our
other databases including the obvious system databases? Would it be ok to
give this consultant a windows domain login and assign it as a db_owner or
would assigning a combination of the other system roles within this db be
better?
RE: Moving SQL Server 2000 to a new machine ... In addition to all the CYA advise, you CAN move the system databases.... Once you've got the new server at SQL2K, SP2, and the physical paths to ... > Recently I was tasked to move our entire SQL Server 2000 to a new server. ... (microsoft.public.sqlserver.server)
Re: select from one db only ... No.He can see those system databases and sample databases because its common ... databases.You can however DENY permissions.For example, ..."Doug" wrote in message ... (microsoft.public.sqlserver.security)
Re: Move databases between servers ... I assume we can backup the system databases (including ... then restore the system databases. ... When you restore databases on your other server SQL Server adds ... (microsoft.public.sqlserver.setup)
Re: Server Rebuild - What to do? ... but as a backup procedure perform a full database backup for ... all databases including system databases before you do any thing. ... COpy the MDF and LDF to a safe location including system databases...Install SQL Server in same path ... (microsoft.public.sqlserver.setup)
Re: Server Rebuild - What to do? ... but as a backup procedure perform a full database backup for ... all databases including system databases before you do any thing. ... COpy the MDF and LDF to a safe location including system databases...Install SQL Server in same path ... (microsoft.public.sqlserver.setup)
