home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
moodle.waes.ac.uk
/
moodle.waes.ac.uk.zip
/
moodle.waes.ac.uk
/
TMG
/
SP1-TMG-KB981324-AMD64-ENU.msp
/
PCW_CAB_SHFx2
/
F2143_msfpcui.dll
/
BINARY
/
25011
< prev
next >
Wrap
Text File
|
2010-06-15
|
487b
|
18 lines
CREATE FUNCTION [dbo].[fnGetLogsServerName]
(
)
RETURNS nvarchar(32)
AS
BEGIN
DECLARE @LogServerName nvarchar(32)
SET @LogServerName = '-'
IF OBJECT_ID ('FWS_LOGS', 'view') IS NOT NULL
SET @LogServerName = (SELECT TOP 1 [servername] FROM FWS_LOGS);
ELSE IF OBJECT_ID ('WEB_LOGS', 'view') IS NOT NULL
SET @LogServerName = (SELECT TOP 1 [servername] FROM WEB_LOGS);
-- Return the result of the function
RETURN @LogServerName
END