Question : When trying to mirror a database using the following command ALTER AVAILABILITY GROUP SQLAlwaysonGroup ADD DATABASE test0916aj8CJ I […]
Tag: alter-database
How do I add multiple users to a role in one statement?
Question : I simply want to add multiple users that I have created to a created role then grant all […]
Altering Tables using Tablenames from other Table
Question : I have a database with several tables and i have a table which contains all tablenames which I […]
Where are my files?
Question : The DBA run a file relocation script to move the physical Database file from where it was running […]
Does the scope for ‘Alter Any Database’ operate similar to ‘Create Any Database’?
Question : Does the scope for ‘Alter Any Database’ operate similar to ‘Create Any Database’, as in, only those databases […]
User cannot create schema in PostgresSQL database
Question : I’m trying to setup a “deployment” user which can create and alter tables on an existing database in […]
User cannot create schema in PostgresSQL database
Question : I’m trying to setup a “deployment” user which can create and alter tables on an existing database in […]
Does the scope for ‘Alter Any Database’ operate similar to ‘Create Any Database’?
Question : Does the scope for ‘Alter Any Database’ operate similar to ‘Create Any Database’, as in, only those databases […]
ALTER DATABASE ARITHABORT configuration minimum privilege needed
Question : What is the minimum privilege needed to execute ALTER DATABASE {db_name} SET ARITHABORT ON? I found that the […]
Can’t change _log database physical location in SQL Server
Question : I just installed Microsoft ServiceBus and it created 5 databases. Now I want to move them to some […]
- 1
- 2