MSSQL View Snapshot should not use sp_helptext

Description

According to http://connect.microsoft.com/SQLServer/feedbackdetail/view/362818/sp-helptext-deletes-white-space-including-important-white-space-in-some-cases whitespace may be altered when fetching a view definition with sp_helptext

Change code to use SELECT OBJECT_DEFINITION

Environment

SqlServer

Activity

Show:

Nathan Voxland June 23, 2015 at 7:41 PM

Nathan Voxland June 16, 2015 at 7:40 PM

Changed

Fixed

Details

Reporter

Fix versions

Affects versions

Priority

Created June 16, 2015 at 7:39 PM
Updated June 23, 2015 at 7:41 PM
Resolved June 16, 2015 at 7:40 PM