Technical Article

SP_HELPTEXT Modified for XML

This is the standard sp_helptext from SQL Server 2000 modified slightly to return the object definition as an XML document.The document is structured in the following format:I admit it was not a lot of work since I merely modified the final SELECT statement from Microsoft's own procedure, but I still find this very useful.The only […]

You rated this post out of 5. Change rating

2003-09-26

172 reads

Blogs

Creating an Empty Repo in GitHub–#SQLNewBlogger

By

I saw someone struggling with getting started with a Visual Studio project and Azure...

Product Review: DataVeil

By

If you’re looking at data masking tools, I recently was able to review the...

The Last Price Bump for the Data Community Summit

By

This week the cost of the PASS Data Community Summit jumps up to full...

Read the latest Blogs

Forums

Just upgraded SSRS from 2016 to 2022

By LearningDBA

I just upgraded SSRS from 2016 to 2022. This is my first time doing...

Weekly sales report

By mailramk

I have two tables InvHeader and InvDetail InvHeader table has the columns: InvNo, InvDate...

Copying an old database to a new database

By paul 69259

Hi All, I've got a write a program to copy the data from one...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers