 |
SoftTree Technologies
Technical Support Forums
|
|
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: 7948
|
|
|
|
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: 7948
|
|
|
|
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 |
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|