Assuming we have the following table (that stores hierarchical data) :CREATE TABLE [staff] ( [employee] [int] NOT NULL , [employee_name] [varchar] (10) NULL , [supervisor] [int] NULL , PRIMARY KEY CLUSTERED ( [employee] ) ON [PRIMARY] , FOREIGN KEY ( [supervisor] ) REFERENCES [staff] ( [employee] ))I ‘ll built a […]
2002-08-23
825 reads
2002-06-06
472 reads
--Implement an Alert Which Trigger when Specified Disks--free space exceeds a specified alert level--Steps to implement:--1) Define a Custom Error Message with messsage text (The ---drive free space is bellow alert level. Details: %s)--2) Define an Alert linked to CEM defined at step 1--3) Implement a Job which execute the following step in a recurring […]
2002-06-04
2,658 reads
By Steve Jones
I downloaded SSMS 18.5, as there were a lot of fixes in here and...
By Steve Jones
I was excited to try the Jupyter Book feature in the March Azure Data...
I will be presenting a session to the Adelaide SQL Server User Group on...
Can i configure a 2 Node AG Availability group in the same data(local site) ...
We received error when testing the DBmail The mail could not be sent to...
i have a table A where the data looks like ID Name Phone CODE...
Ask SSC