Questions tagged [automation]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
-5
votes
1answer
196 views

can anyone help me in generating a automated script to create a database

I need help in generating a automated script for database where I can give parameters for database name, size etc. I need automated script to create a database where in I can give parameters for ...
3
votes
3answers
700 views

Automated regular tests of your backups

I was doing some investigation on how other DBAs go about performing automated regular tests of their database backups to ensure recoverability in case of disaster and I'm quite disappointed at what ...
2
votes
3answers
6k views

Script to backup all databases

I'm working on automating backups of SQL Server databases on SQL 2008 R2 Express. These backups are initiated daily by the Windows Task Scheduler, which execute a batch file, which in turns executes a ...
-1
votes
1answer
736 views

How to write the bash scripts with automatic function in postgresql?

To save the bash as create_mysql.sh, we can create a database magento and a user magento_user with full privileges by password. mysqlword="xyzzy" mysql -u root -p$mysqlword -e"CREATE DATABASE magento;...
5
votes
3answers
39k views

script to show all the permissions for a table

inside my database I have a procedure called spGen2_tblIE_SchedProcess_Update. when I run this script select * from sys.objects where name = 'spGen2_tblIE_SchedProcess_Update' Inside the same ...
2
votes
1answer
149 views

Trace flag is running, but not message when deadlock happens

Trace flags are used to temporarily set specific server characteristics or to switch off a particular behavior More information on the trace flags are here DBCC TRACESTATUS this above, is the ...
0
votes
1answer
42 views

How can I inform myself that an automatic SQL Server process has worked?

I have a Windows batch file which extracts some data from a remote system and then imports it into an instance of MS SQL Server 2014. The batch file runs SQLCMD and uses SQL files to bulk insert from ...
3
votes
1answer
1k views

automatically change value on the table mysql

i have table invoice in my database that contain atributes 'due date', 'date' and 'status'. What i want is data on 'status' change automatically. Example, status (unpaid change to expired) when date ...
19
votes
2answers
9k views

Is there a cool way of performing CU updates for SQL Server on hundreds of machines?

My company has grown from 50 SQL Servers to over 200 overnight in a merger acquisition. HELP! My questions are: How can I perform CU updates on this many servers and still have a life and keep my ...
0
votes
1answer
1k views

View the role assigned to each user (Report Server)

Is there anyway I could list down the roles assigned to each user on the different folders on ReportServer Database and in that SQL statement I should be able to declare something like @User_Name ...
7
votes
3answers
11k views

Restore All Databases Script

I am migrating SQL Server DBs to a new instance. I have been told that it is possible to dynamically build a RESTORE script from available backups in the system catalog. Does anyone know of a sample ...

1
2