Sample scripts for SQLServer administration | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Sample scripts for SQLServer administration

Hi all, I am a SQLServer DBA and not a developer. I am trying to
create a dos script which automates the following tasks. 1. Login to the specific SQLServer in the network.
2. Create/reset/delete SQLServer (database level) userids.
3. Logs out of the SQLServer. The above task is basically to automate SQLServer userid
administration. Since I am not a developer myself, not
sure about the OS level syntax and where to start from. Can someone provide me with some sample scripts and good
online manuals to refer to ? Thanks

If you know about using OSQL & ISQL then you can start by referring to books online and for script examples search under,, (don’t know whether this site is still in operation), websites.
Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.