While using Visual Interdev:

• Create a DSN pointing to the database in MS SQL Server.
• Create a new "Database project" in Visual J++/Visual Interdev and choose the DSN name that u've created in ur prev step.
• As soon as u try to collapse the connection object in data view in the workspace, a window asking u for the login/password for the database pops up. Supply them and enter the database.
• Now, if u try to collapse the "Stored Procedures" hive under this data connection, it'll ask you for login/password on VSS in a popped up window. Supply ur usual login and password that u're using for VSS and u're inside that.
• Once u can see the list of stored procedures, u can right click on any stored procedure and do "check out" and/or "check in", as u're doing for other ordinary files.

To add a new stored procedure:

• Once the "Stored procedures" hive is collapsed, u can right click on the "Stored procedures" itself or the name of any stored procedures under that and select "New Stored Procedure".
• Once u save ur newly created stored procedure, right click on its name and select "Add to Source Control".

To "Roll back" in the history or to see differences between different versions of a stored procedure, to any of its previous version:

• Close ur Visual Studio database project.
• Open VSS with ur login/password, as u're currently doing.
• Open up the project by the name selected in VSS previously.
• U can see the list of stored procedures in the right side pane.
• Right click on the desired stored procedure and select "Show History".
• Then do the rollback operation u want or see differences.
• Open ur Visual Studio project for this database again.
• Follow the above steps to see the name of the desired stored procedure and try to check out the stored procedure u want.
• U'll see a window popped up saying that, the data in VSS is different from the one in database, which version u want to use. U select the last option, that says, "Use the Source Control version" and check it out.
• If u modify the stored procedure at the SQL Server database (by any chance/need), u select the apt choice (first one, that says, "Use database version and update VSS") in the above screen.