A backup can work as one option. It depends on what you need
it for. You can also script out the database (no data) from
Enterprise Manager. Right click on the database, select
Generate SQL Script. In the window that comes up for
generating the script, you can go to the option tab and
select Script Database to script all database settings. You
can script Users, Roles and object permissions. On the
General tab, you can select the option to script all
objects. You have other scripting options from here as well.
-Sue
On Tue, 30 Aug 2005 06:41:02 -0700, "Marc"
[quoted text, click to view] <Marc@discussions.microsoft.com> wrote:
>hello,
>i m new to sql and i need to export all the settings of a base in sql 2000,
>security users ..., is it possible? do i just need to backup the database and
>all the settings will be saved?
>
>THX
hi Marc,
[quoted text, click to view] Marc wrote:
> hello,
> i m new to sql and i need to export all the settings of a base in sql
> 2000, security users ..., is it possible? do i just need to backup
> the database and all the settings will be saved?
each database contains it's full set of database users and related
permissions, so, backing up a database you will automatically include
them...
you only miss all server's login, and this is the reason you should backup
the system databases too...
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply
Another option is to use SQL-DMO. You can use the
GenerateSQL or Script method to script out a database. There
are other options as well. Books online has more information
on SQL-DMO and these methods.
You can execute the scripts from a job or another
application such as VB, C++
-Sue
On Wed, 31 Aug 2005 00:23:02 -0700, "Marc"
[quoted text, click to view] <Marc@discussions.microsoft.com> wrote:
>Hi, thanks for the answer.
>
>Now i would like to know if it is possible to generate this script
>automatically by another script or else?
>
>
Don't see what you're looking for? Try a search.
