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
826 reads
2002-06-06
474 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,672 reads
By Arun Sirpal
I always follow a contained user model when setting up users within my Azure...
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
When I do "select * from ... " from a large table, the result...
Comments posted to this topic are about the item Reading a Specific File from...
Comments posted to this topic are about the item Distributed SQL Databases
Ask SSC