Answered by:
Doubling Words

Question
-
The sp_spaceused in the code section doubles up:
http://social.msdn.microsoft.com/Forums/en/sqltools/thread/2ec98066-1710-42ff-8c96-3f78498cb2e2
Following is the actual source:
EXEC AdventureWorks..sp_MSforeachtable 'EXEC sp_spaceused ''?'';'
Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM
- Edited by Kalman Toth Thursday, November 24, 2011 11:49 AM
Answers
-
- Proposed as answer by Ed Price - MSFTMicrosoft employee Friday, December 9, 2011 8:12 AM
- Marked as answer by Kalman Toth Friday, December 9, 2011 9:33 AM
All replies
-
-
See image below: sp_spaceused doubles up at line break. If I copy and paste it to SSMS query editor, it is not double (and should not be).
Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM -
-
Richard,
The idea occured to me that it is related to screen resolution. Nevertheless it happens as the image shows. My resolution is 1024x768.
Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM- Proposed as answer by Ed Price - MSFTMicrosoft employee Friday, December 9, 2011 8:10 AM
-
-
My font is the same as Hasham's. Notice it is not fixed width, so the single quotes are very difficult to read. My screen resolution is 1366x768. I'm thinking the font makes a difference, although I use Courier New all the time for code and have never seen a problem. But your fixed width font is not in the forum html, but rather from your browser (I think). The code insert button does not result in fixed width font.
Richard Mueller - MVP Directory Services- Proposed as answer by Ed Price - MSFTMicrosoft employee Friday, December 9, 2011 8:10 AM
-
-
It does not happen (does not wrap) at higher resolution. It happens at lower resolution (800x600) as well. IE9 Windows 7. This is the html:
<div style="color:Black;background-color:White;"><pre> <span style="color:Blue;">EXEC</span> AdventureWorks..sp_MSforeachtable <span style="color:#A31515;">'EXEC sp_spaceused '</span><span style="color:#A31515;">'?'</span><span style="color:#A31515;">';'</span> </pre></div>
Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM
- Edited by Kalman Toth Sunday, November 27, 2011 5:16 AM
-
- Proposed as answer by Ed Price - MSFTMicrosoft employee Friday, December 9, 2011 8:12 AM
- Marked as answer by Kalman Toth Friday, December 9, 2011 9:33 AM