This script will create the necessary login and linked servers on a given availability replica. Please ensure that the script is executed on all the replicas.
2022-02-22 (first published: 2022-01-25)
7,471 reads
2015-03-26
2,043 reads
The job will send an HTML email with the latest error at specific job.
2012-03-15 (first published: 2012-03-05)
887 reads
It seems that the ownership of jobs is something that is often overlooked when articles explain
2009-11-19
8,985 reads
Be alerted or take custom actions when specified jobs are in the "Running" state for a length of time.
2009-09-25 (first published: 2009-09-15)
887 reads
This query states the execution status of the job i.e. Executing, idle etc. you also modify and search the jobs by changing the search condition.
2008-12-02
1,009 reads
By Vinay Thakur
As this is an Artificial Intelligence (AI) World, things are changing. We can see that...
In a containerized app, React and Chakra UI provide a robust and accessible user...
By Steve Jones
nachlophobia – n. the fear that your deepest connections with people are ultimately pretty...
hi, I have a table called Rules Create table Rules ( Id int ,...
I am currently upgrading a very old database running SQL Server 2008 to SQL...
Hi Team, I am planning to apply security updates for SQL Server 2016 on...
What is returned from this query?
SELECT
( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate >= '01/01/2011' AND soh.OrderDate < '01/01/2012') AS OrdersIn2011
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate >= '01/01/2012' AND soh.OrderDate < '01/01/2013') AS OrdersIn2012
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate >= '01/01/2013' AND soh.OrderDate < '01/01/2014') AS OrdersIn2013; See possible answers