SQL Server Performance Forum – Threads Archive
Sample scripts for SQLServer administrationHi 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 underhttp://www.databasejournal.com/scripts/,http://vyaskn.tripod.com/,http://www.swynk.com/sql/ (don’t know whether this site is still in operation),http://www.sqlteam.com websites.
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.