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 […]

2003-09-26

129 reads

Blogs

On Dynamic Ports, Named Instances, and Firewalls

By

Recently I had a client and their vendor trying to configure a firewall for...

Daily Coping 13 Jul 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

Last Week Reading (2020-07-12)

By

Press Azure resource providers operations List of all of the available ADF-specific RBAC permissions....

Read the latest Blogs

Forums

The C in ACID

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The C in ACID

Renting Features

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Renting Features

Basic Git for DBAs: Making Changes in GitHub

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Basic Git for DBAs: Making...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

The C in ACID

See possible answers