If EXISTS (SELECT 1 from sysobjects where id = Object_id ('fgetsstatus') And ObjectProperty (ID, 'isinlineFunction') = 0) DROP Function FgetsStatusgo
Create Function FgetsStatus (@servername varchar (50) - server name, @ userid varchar (50) = 'sa' - username, if it is a NT authentication method, it is empty, @password varchar (50) = '- -password
Returns var, @re var, @ Ire int - return statly @srvid int - define servers, database set ID Declare @err int, @ src varchar (255), @Desc varchar ( 255) - Error handling variable
- Create a sqldmo object EXEC @ Err = sp_oacreate 'sqldmo.sqlser', @ srvid output if @err <> 0 goto lberr
- Connecting server if isnull (@Userid, '') = '' - if it is NT authentication method begin exec @ err = sp_oasetproperty @ srvid, 'loginsecure', 1 if @err <> 0 goto lberr
Exec @ Err = SP_OAMETHOD @ SRVID, 'Connect', NULL, @ ServerName Else Exec @ Err = SP_OAMETHOD @ SRVID, 'Connect', Null, @ ServerName, @ UserId, @ Password
IF @err <> 0 goto lberr
