Question : I am using oracle 11gR2 database in which I was trying to wrap my scripts. I read the […]
Tag: scripting
How to script all the service broker elements for each database it is on, in the current server?
Question : I have service broker running on different servers. Just recently I had to rebuild one of the test […]
Scripting out database user level permissions [duplicate]
Question : This question already has answers here: Copying Db permission between same instance (3 answers) Closed 4 years ago. […]
Scripting an application role with a hashed password
Question : I need to script an application role with a hashed password, so I can copy it from one […]
SQL Server – backup / restore schema only
Question : We have a DB on over 100 servers of which we want to backup / restore the structure […]
how to script server side permissions – specifically EXECUTE ON SYS.XP_PROP_OLEDB_PROVIDER?
Question : I could not script the following server side permissions: GRANT VIEW DEFINITION ON LOGIN::[site_helpdesk] TO [Radhe] but thanks […]
Restoring multiple files to multiple database with pg_restore
Question : I have multiple dump files and want to restore them with single command. something like this pg_restore -h […]
Is it possible to allow write-through computed columns for legacy code that expects a column to be read/write?
Question : I have this existing table for IP storage: CREATE TABLE [dbo].[IPAddresses]( [ID] [int] IDENTITY(1,1) NOT NULL, [IPv4Address] [varchar](15) […]
List of role permissions including other roles – how can I find out the roles that belong to other roles?
Question : I can see the permissions of a role in a database using the scripts in List all permissions […]
PostgreSQL everyday trigger?
Question : I want to add a function like trigger to my Postgres database. The problem is that this function […]