Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
eljapo4
Posting Yak Master
100 Posts |
 Posted - 2011-10-11 : 08:32:50
|
| Hi - I save any SP's that I work on into Microsoft VSS, and check out from VSS and update according in SQL Server 2005. The SP's in VSS are saved as both .PRC & .SQL files. The problem I have is that if another use takes the file from VSS and opens it, the file contains control characters but yet I do not see these when I open the same file. Is there a setting within SSMS that i can turn on/off to view these control characters?Thanks in advance |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-10-11 : 08:40:17
|
| Probably a unicode issue. Do you have the sam O/s and version/service pack.Check the editor options under tools.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
eljapo4
Posting Yak Master
100 Posts |
Posted - 2011-10-11 : 09:37:39
|
| I've updated my version of VSS to match the other users and files are ok, not sure if this actually solved the issue because I also opened the file in question and pasted it into a new query window in SQL and saved it overwriting the existing file in VSS. |
|
|
|
|
|
|
Control Characters in files