RSS FeedIn developing web applications, I mainly use Microsoft’s Visual Studio 2008 together with SQL Server Management Studio. I however only used SQL Server Management Studio to create new databases and tables while adding Stored Procedures from Visual Studio 2008. As the project took shape, this wasn’t a major problem. However the database continues to grow not only in disk space size, but also in the number of tables and stored procedures. Constantly scrolling up and down the the Object Explorer was beginning to become a headache. I have since been recommended to use sp_help and sp_helptext. Both make reading the stored procedure setup and details easier in nearly every aspect. The downfall is the two commands do not allow changes to be made. Instead, the upside is quick access to viewing the stored procedure.
sp_help storedprocedurename
sp_helptext storedprocedurename
Posted in 
Tags: 
