title: Test Editor Visual Studio Codeslug: test-editor-visual-studio-codedescription: nullauthor: nulldate: ‘2022-01-15T22:23:09.626Z’lastmod: 2019-08-22T15:20:28.000Zdraft: truetags: []categories: []#

Test to use images

copy and paste

..

.

 1GO
 2CREATE OR ALTER PROCEDURE #checkLinkedServer
 3    @servername ntext
 4AS
 5BEGIN
 6    SET NOCOUNT ON;
 7    DECLARE @retval int = 0,
 8            @sysservername sysname;
 9    BEGIN TRY
10        SELECT  @sysservername = CONVERT(sysname, @servername);
11        EXEC @retval = sys.sp_testlinkedserver @sysservername;
12        SELECT 1;
13    END TRY
14    BEGIN CATCH
15        SELECT 0;
16    END CATCH;    
17END
18GO
19
20
21go
22exec #checkLinkedServer 'PIOLEDB'