Hi Grasshopper,

Thanks for all the info. Our issue is that we started tracking changes in SQL Server 2000. When we would alter a stored procedure, we could 'script' it out to a file, do a 'DIFFERENCES' and then check it back into VSS. We used ANSI Text output format for the script file . In SQL Server 2005, the only output option is Unicode. As a result, we are unable to do a Difference using the latest VSS file and the output file from SQL Server 2005. VSS gives us an error that it cannot compare files that are different types

Until we discover a solution we

1. Extract latest from VSS

2. Make the changes in SQL Server 2005

3. Copy the altered Stored Procedure and Paste it into the

extracted .SQL file

4. Do A Diff in VSS

5. Check it back in

If you find a way to diff a text file and a SQL Server 2005 script file, please let us know

Thanks again for your response