Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 sending mail + running batch files + really tough question

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-09-07 : 10:01:07
Miodrag Jankovic writes "1. I want to send mail from an sql server stored procedure. Sending mail using mapi client will do the job, but i was wandering if there is a more efficient and elegant solution. without usage of anything that is not included in sql server or w2000 instalaton
2. realy tough one:
can i add users ( or delete, change pass etc.) on w2000 system from SQL server.
my first idea is to make tiny scripts eg.:

user name pass /add (this line adds user from dos prompt on w2000)

and then execute them from sql server. but how can i run such a script from sql server?

Tough enough?

Thank you"
   

- Advertisement -