Author |
Message |
judahr
Joined: 09 Mar 2007 Posts: 319 Country: United States |
|
Code Snippets CR/LF |
|
5.1.10 Pro
SSMS 2008
 |
 |
$PROMPT(proc_name,Enter new procedure name)$
IF OBJECT_ID('$proc_name$') IS null
Exec ('Create procedure $proc_name$ AS')
GO
/***********************************************************
* Procedure description:
* Date: $DATE$
* Author: $OSUSER$
*
* Changes
* Date Modified By Comments
************************************************************
*
************************************************************/
Alter PROCEDURE $proc_name$
(
|
)
AS
BEGIN
SET NOCOUNT ON
RETURN 0
END |
Outputs everything as a single line, and not even all the text. Seems to truncate after 152 characters.
|
|
Tue Sep 07, 2010 4:37 pm |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7963
|
|
|
|
Sorry, I'm unable to reproduce this one too. I copied your text from the web page.
Did you copy the snippet text from some text editor or entered it directly into the snippet text edit box?
|
|
Thu Sep 09, 2010 6:31 am |
|
 |
judahr
Joined: 09 Mar 2007 Posts: 319 Country: United States |
|
|
|
I worked around by copying the text from the snippet editor into the SQL editor window, then copying back. Copying into notepad showed similar issues. There seemed to be a difference in the encoding or handling of CR/LF between version or how the settings were transferred between versions.
|
|
Thu Sep 09, 2010 9:00 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7963
|
|
|
|
Here is the issue tracking number #SA 11313. This issue has been fixed and the fix should be released in the next public build.
|
|
Wed Sep 15, 2010 11:04 pm |
|
 |
|