Post reply

systemote tables access

  • July 16, 2012 at 8:23 am

    #263852

    When i run following query select GRANTOR from [master].[dbo].[SYSREMOTE_COLUMN_PRIVILEGES] on sql server 2000 version its throuwing following error message.

    Msg 201, Level 16, State 7, Line 1

    Procedure 'master.dbo.SYSREMOTE_COLUMN_PRIVILEGES' expects parameter 'ServerName', which was not supplied.

    Is there any other way to select the record from the table ?

  • July 16, 2012 at 8:38 am

    #1513108

    sudhakara (7/16/2012)

    When i run following query select GRANTOR from [master].[dbo].[SYSREMOTE_COLUMN_PRIVILEGES] on sql server 2000 version its throuwing following error message.

    Msg 201, Level 16, State 7, Line 1

    Procedure 'master.dbo.SYSREMOTE_COLUMN_PRIVILEGES' expects parameter 'ServerName', which was not supplied.

    Is there any other way to select the record from the table ?

    I don't work with 2000, and this is a 2008 forum so your question should really be in another forum. That being said, the error is telling you that you are calling a procedure that expects a parameter, not selecting from a DMV or table.

    Jared
    CE - Microsoft

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply