Configuring SQL

hi all,

i want to develop some script to configure sql externally, can anyone
tell me how can i do so?? and wether this is possible or not??

the type of configurations that i need, setting sa password, deleting
guest account,Remove sample databases, Audit Login events, Restrict
CmdExec rights to SysAdmins,...

i want to develop a script to enforce the configurations above by
executing this script

any ideas???Have you considered using the Script-Task in the SSIS-package? AFAIK you
can access all functions there and write your Script in VB.NET code.

--
Benedikt Ries
----------------------
Benedikt Ries's Profile: http://www.dbtalk.net/m1098
View this thread: http://www.dbtalk.net/t345220|||Thanx Benedikt :),
plz note i'm using SQL server 2000

any other ideas??

Benedikt Ries wrote:

Quote:

Originally Posted by

Have you considered using the Script-Task in the SSIS-package? AFAIK you
can access all functions there and write your Script in VB.NET code.
>
>
--
Benedikt Ries
----------------------
Benedikt Ries's Profile: http://www.dbtalk.net/m1098
View this thread: http://www.dbtalk.net/t345220

|||Create a batch file that will use OSQL or ISQL, and run all script you
want.
something like :

SET SERVERNAME=XYZ
SET DBNAME=ABC
SET USERNAME=ABC
SET PSW=ABC

ISQLW -U%USERNAME% -P%PSW% -S%SERVERNAME% -d%DBNAME%
-ic:\temp\script1.SQL -oLOGFILE.LOG -FA -n
TYPE LOGFILE.LOG >FULLLOG.LOG

ISQLW -U%USERNAME% -P%PSW% -S%SERVERNAME% -d%DBNAME%
-ic:\temp\script3.SQL -oLOGFILE.LOG -FA -n
TYPE LOGFILE.LOG >FULLLOG.LOG

Eng.Rana@.gmail.com wrote:

Quote:

Originally Posted by

Thanx Benedikt :),
plz note i'm using SQL server 2000
>
any other ideas??
>
>
Benedikt Ries wrote:

Quote:

Originally Posted by

Have you considered using the Script-Task in the SSIS-package? AFAIK you
can access all functions there and write your Script in VB.NET code.

--
Benedikt Ries
----------------------
Benedikt Ries's Profile: http://www.dbtalk.net/m1098
View this thread: http://www.dbtalk.net/t345220