Viewing 2 posts - 1 through 3 (of 3 total)
A neat function that I have used is Coalesce.
SELECT COALESCE(NULL,0) AS [Result] (where NULL=field of choice)
September 3, 2004 at 1:22 am
#521590
The permissions are being permenantly lost, not temporarily. Until I manually go back into the subscribing database and update the permissions no-one can get access,
June 11, 2003 at 12:45 am
#460700