locked
Accessing SQL using Visual Studio for Community RRS feed

  • Question

  • User451945003 posted

    I am using Visual Studio for Community to develop a website hosted on a Windows Server 2012.   I am accessing the website using the FTP connection option.  We have an instance of SQL Server for Web and I am trying to CREATE a stored procedure.  I do not know how to save the stored procedure directly back to the server SQL database.  When I try to save I only get the option to save it on my local computer drive.  This was not an issue when using the we were hosted on a Windows Server 2003 platform.

    Question:  I can create the stored procedure using VS for Community.  How can I save it directly back to the SQL Server for Web instance located on our remote VM running under Windows Server 2012? 

    Sunday, September 20, 2015 9:50 PM

Answers

  • User879242426 posted

     I can create the stored procedure using VS for Community.  How can I save it directly back to the SQL Server for Web instance located on our remote VM running under Windows Server 2012? 

    If you create the stored procedure locally, it's only located to local site.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, September 22, 2015 2:10 AM