abhi
  • 37, Male
  • Santa Ana, CA
  • United States
Share on Facebook Share

Abhi's Friends

  • John M. Miller
  • Bryce Calhoun

abhi's Discussions

SQL Azure new CTP release – Firewall Settings and Views
4 Replies

Started this discussion. Last reply by Dhaval Ghelashah Oct 26, 2009.

Data center for Windows Azure

Started Oct 11, 2009

 

abhi's Page

Gifts Received

Gift

abhi has not received any gifts yet

Give abhi a Gift

Abhi's Blog

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

Posted on September 26, 2009 at 12:00am

Comment Wall

You need to be a member of Azure User Groups to add comments!

Join Azure User Groups

  • No comments yet!
 
 
 

Latest Activity

© 2017   Created by Azure Admin.   Powered by

Badges  |  Report an Issue  |  Terms of Service