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

180 reads

Blogs

A New Word: Proluctance

By

proluctance – n. the paradoxical urge to avoid doing something you’ve been looking forward...

Know Thy Platform

By

IT and data professionals, I implore you – know thy platform. All of it....

Adding Git LFS Support – #SQLNewBlogger

By

I got this message recently while committing some changes: This post shows my work...

Read the latest Blogs

Forums

when peers maintain a job rdp'd in they corrupt the job

By stan

Hi, one of my peers prefers to maintain one specific sql agent job after...

import json file

By smattiko83

Any idea on how to import a json file into sql server? I've never...

Downside to running a query in parallel

By water490

I am a SS rookie.  To me it seems like running a query in...

Visit the forum

Question of the Day

Filestream on Linux

I want to implement a Filestream table on SQL Server 2022 running on Linux. Can I do this?

See possible answers