Question : I’m trying to setup a “deployment” user which can create and alter tables on an existing database in […]
Tag: alter-database
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 […]
Best approach for moving tempdb .ndf files
Question : During a SQL Server installation, I “thought” I specified location of tempdb on ‘F:’ and not ‘C:’, but […]