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