Tuesday, April 7, 2009

SourceSafe saves SQL Stored Procedures as Binary

For some reason Source Safe only works with ASCII. SQL Manager 2005 by default saves everything as UNICODE (The standard) but source safe cannot recognize this. In order to fix this you must do the following:

The issue is that sql manager saves everything in UNICODE format by default. This is an issue because source safe doesn’t accept Unicode and saves the sql file as binary. When using sql manager and saving a sql file be sure to do save encoding choose US acsii.

No comments:

Post a Comment