The following sample database is currently available for Microsoft SQL Server 2005 and Microsoft SQL Server 2008:
SQL SERVER – Simple Use of Cursor to Print All Stored Procedures of Database Including Schema
I love active participation from my readers. Just a day ago I wrote article about SQL SERVER – Simple Use of Cursor to Print All Stored Procedures of Database. I just received comment from Jerry Hung who have improved on previously written article of generating text of Stored Procedure. DECLARE…
Read MoreSQLAuthority News – SQL Server White Paper: SQL Server 2008 Compliance Guide
Note: Download White Paper by Microsoft Organizations across the globe are being inundated with regulatory requirements. They also have a strong need to better manage their IT systems to ensure they are operating efficiently and staying secure. Microsoft is often asked to provide guidance and technology to assist organizations struggling…
Read MoreSQL SERVER – Simple Use of Cursor to Print All Stored Procedures of Database
SQLAuthority Blog reader YordanGeorgiev has submitted very interesting SP, which uses cursor to generate text of all the Stored Procedure of current Database. This task can be done many ways, however, this is also interesting method. USE AdventureWorks GO DECLARE @procName VARCHAR(100) DECLARE @getprocName CURSOR SET @getprocName =Â CURSORÂ FOR SELECT s.name…
Read More
SQLAuthority News – Author Visit – South Asia MVP Open Day 2008 – Goa – Group Photo
MVP Open day 2008 is one of the best event happened so far. I have previously written about this event in detail on this blog.
SQLAuthority News – Author Visit – South Asia MVP Open Day 2008 – Goa – Day 3
Yesterday was our last day at South Asia MVP Open Day. For three days continuously we are having great time along with fellow MVP. Every MVP was having great time because the way whole event was planned. We had plenty of time for networking as well lots of interesting sessions…
Read MoreSQLAuthority News – Author Visit – South Asia MVP Open Day 2008 – Goa – Day 2
At MVP Open Day we were promised that we will have 8 to 8 action packed day but we all observed much longer hours where we all MVP’s were busy with activity. I will say instead of 8 AM to 8 PM we actually had fun from 8 AM to…
Read MoreSQLAuthority News – Author Visit – South Asia MVP Open Day 2008 – Goa – Day 1
It is great fun! Perfect Event and Great start. Yesterday I wrote about agenda of South Asia MVP Open Day 2008 which is at Hotel Kenilworth Resorts, Goa. November 15 – Day 1 of Open Day started with plain journey and ended with Goan Team Party at beach with fellow…
Read MoreSQLAuthority News – Author Visit – South Asia MVP Open Day 2008 – Goa – Link List
Today is very exciting day as I will start my trip to South Asia MVP Open Day 2008 – Goa. Yesterday I wrote about my visit. I will be attending South Asia MVP Open Day 2008 on November 15 – 17, 2008 at Hotel Kenilworth Resorts, Goa. Those who have…
Read MoreSQLAuthority News – Author Visit – South Asia MVP Open Day 2008 – Goa
I will be attending South Asia MVP Open Day 2008 on November 15 – 17, 2008 at Hotel Kenilworth Resorts, Goa. I am very excited as this will be my first Open Day event after being MVP. Microsoft Most Valuable Professionals (MVPs) are exceptional technical community leaders from around the…
Read More