Post reply

How To Convert the SP to View

  • October 29, 2009 at 5:36 am

    #136898

    Dear All;

    I need to convert the sp to view but in sqlstmt to throw the following

    Error Message;

    pls help this;

    SQL Server blocked access to STATEMENT 'OpenRowset/OpenDatasource' of component 'Ad Hoc Distributed Queries' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Ad Hoc Distributed Queries' by using sp_configure. For more information about enabling 'Ad Hoc Distributed Queries', see "Surface Area Configuration" in SQL Server Books Online.

    Thanks & Advance;

    A.Faijurrahuman

  • October 29, 2009 at 6:01 am

    #1072364

    Have you asked the sa for rights to OpenRowSet?

  • October 29, 2009 at 6:05 am

    #1072369

    HOW CAN I CHECK WHETHER THE RIGHTS ARE ENABLED

    OR OTHER WISE

    HOW TO ASSIGNED THE RIGHTS

  • October 29, 2009 at 6:26 am

    #1072378

    faijurrahuman17 (10/29/2009)

    HOW CAN I CHECK WHETHER THE RIGHTS ARE ENABLED

    OR OTHER WISE

    HOW TO ASSIGNED THE RIGHTS

    the error message from MS was really good; it basically said to check the Surface Area Configuration.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • October 29, 2009 at 6:27 am

    #1072379

    Please don't shout at us (type all caps)

    sp_configure 'Ad Hoc Distributed Queries'

    There is a good reason this is disabled by default. Check with the DBA and whoever's responsible for security before you ask for it to be enabled.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • October 29, 2009 at 6:36 am

    #1072385

    Thanks for awsome response;

    God Bless you;

Viewing 6 posts - 1 through 5 (of 5 total)

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