Abhi's Blog (1)

Alter Stored Procedure in SQL AZURE

Absence of object browser in SQL Azure throws many challenges. For example, how would you update a stored procedure in your SQL Azure database? The challenge is to get the source code from the cloud database.



select * from sys.objects



will only display the objects in your database and not the source code for any stored procedure or view etc.



Here is my hack to get the source code for any stored procedure.



1. SELECT * from… Continue

Added by abhi on September 26, 2009 at 12:00am — No Comments

Most Popular Blog Posts

Monthly Archives

2009

Latest Activity

Profile IconKevin Rolnick, Tony Williams, Mark Sullivan and 48 more joined Azure User Groups
Sep 21, 2018
chandupatla joined Mike Holdorf's group
Thumbnail

Dallas Azure User Group

Dallas Azure User Group - Meetings held at the Microsoft Technology Center in Las Colinas
Apr 20, 2017
Anthony.Tex.M posted a status
"We are ACTIVE on http://www.hccug.org ... and open for new members!"
Feb 21, 2017
Ani Arth posted an event
Thumbnail

Live! 360 Orlando at Loew's Royal Pacific Resort

November 17, 2014 to November 21, 2014
Live! 360 brings together five conferences, and the brightest minds in IT and Dev, to explore leading edge technologies and conquer current ones. These co-located events will incorporate knowledge transfer and networking, along with out-of-this-world education and training, as you create your own custom conference, mixing and matching sessions and workshops to best suit your needs. Whether you are a developer who uses Visual Studio, SQL Server, and SharePoint;…See More
Jun 6, 2014

© 2019   Created by Azure Admin.   Powered by

Badges  |  Report an Issue  |  Terms of Service