SQL-Articles >> Generate Users and Roles Script

[SQL-Articles]

SQL-Articles >> Generate Users and Roles Script

---

Generate Users and Roles Script Posted: 27 Jul 2013 07:34 PM PDT Couple of weeks back I wrote a script for generate object level permission in the database. People started requesting me to write a script which should script all the users and roles in a database. I came up with this script which will script roles and users in a database and it will also associate [...]

T-SQL Script to find the names of the StoredProcedure that has used dynamic SQL Posted: 27 Jul 2013 12:51 AM PDT This article has the script that will be useful to find the names of the  Stored procedure that has used dynamic sql within the definition of the Stored procedure . In this post , I am creating a sample database with four stored procedures to show an example on how the script works :  Step [...]

You are subscribed to email updates from SQL-Articles To stop receiving these emails, you may unsubscribe now.	Email delivery powered by Google
Google Inc., 20 West Kinzie, Chicago IL USA 60610