Unable to view Stored procedure of MSSQL data base hosted on Microsoft Azure


  • I have hosted my Database on Microsoft Azure and Connected via MSSQL 2014. But I am Unable to see my stored procedures.

    Friday, November 10, 2017 6:22 AM

All replies

  • IS this a PaaS database or IaaS database?

    Can you run @@Servername to the connected server and then ensure you connected to the correct server.

    Not sure whether you have access to view stored procedures or there are no stored procedure in the database?

    If you have proper access to the server and permission in database you should be able to view the stored procedure.

    Mark as ANSWER if I helped you today :-)

    Friday, November 10, 2017 8:36 AM
  • In addition to what @VinhyaSagar has said, are you sure you're connected to the correct database? 

    This sounds like a permissions issue, but without the additional information, it's hard to say for certain.

    Friday, November 10, 2017 1:23 PM