I want to check TSQL code I write in SQL Server Management Studio (SSMS) into Visual Source Safe (VSS) and designate the path that is used in VSS. The question is how do I set the path?

I have noticed some added files in the directories where I have used SSMS to check code into VSS, here are two:
XXXSQL.ssmssqlproj.vspscc
XXXSQL.vssscc

The vspscc file opens in notepad and has this:
{
"FILE_VERSION" = "9237"
"ENLISTMENT_CHOICE" = "NEVER"
"PROJECT_FILE_RELATIVE_PATH" = "relative:XXX_20090505\\XXXSQL"
"NUMBER_OF_EXCLUDED_FILES" = "0"
"ORIGINAL_PROJECT_FILE_PATH" = ""
"NUMBER_OF_NESTED_PROJECTS" = "0"
"SOURCE_CONTROL_SETTINGS_PROVIDER" = "PROJECT"
}
and the vssscc file has the same information.

Can I add a new keyword to the above file and set a path?

I am using "Microsoft SQL Server Management Studio version 9.00.4035.00" and "Microsoft Visual SourceSave version 6.0d"

---

Duane Lawrence

Hello Duane,

I am a little bit confused about what you want to do. If we go to "File" -> "Source Control" -> "Change Source Control.." in Visual Studio, the Dialog is shown。Can you elaborate little bit more what you want to do?

Thanks,
Rong-Chun Zhang

---

Please mark the replies as answers if they help and unmark if they don't.
Welcome to the All-In-One Code Framework, a sample code project owned by the MSDN Forum Support team!

Hello Duane,

I am not sure what path you want set, however PROJECT_FILE_RELATIVE_PATH in vspscc or vssscc file meansthe path of the solution's (or project's) folder relative to the root of the source control connection used by that solution/project. For detailed information about file in VSS, please check:

http://alinconstantin.members.winisp.net/webdocs/scc/SccFiles.htm

And SQL Server Management Studio (SSMS)is just an instance ofVsiual Studio Shell(isolated mode), thus it can work with Visual SourceSafe like Visual Studio itself does.

Let me know if this helps, if not, could you please be more specific about your problem?

Thanks,
Rong-Chun Zhang

---

Please mark the replies as answers if they help and unmark if they don't.
Welcome to the All-In-One Code Framework, a sample code project owned by the MSDN Forum Support team!

No, the PROJECT_FILE_RELATIVE_PATH is the path on the hard drive. I want to set the path to the project in Visual Source Safe (VSS). Thus the reply above is not helpful.

---

Duane Lawrence

I stumbled upon the answer, I moved the project in VSS and then opened the project in SSMS and got an error saying it could not find the project in VSS, I then read the messages and choose the advanced option to manually set the bindings. I got what looks to be a standard windows dialog (I was not always a DBA and remember well my days as a C++ coder).

<<picture won't upload>>

Now the question is, how do I open this project “MySQLproject.ssmssln� in the dialog box when I want to?

Duane

---

Duane Lawrence

Hello Duane,

Did you mean the Change Source Control dialog box? If so, please try to open the .ssmssln solution in SQL Server Management Studio (SSMS), and go to "File" -> "Source Control" -> "Change Source Control..", then you can rebind the solution to the right paht in VSS database.

Thanks,
Rong-Chun Zhang.

---

Please mark the replies as answers if they help and unmark if they don't.
Welcome to the All-In-One Code Framework, a sample code project owned by the MSDN Forum Support team!

Nope, that is not what I meant.

How do I open the dialog box using a Visual Studio pull down menu?

---

Duane Lawrence

Hello Duane,

I am a little bit confused about what you want to do. If we go to "File" -> "Source Control" -> "Change Source Control.." in Visual Studio, the Dialog is shown。Can you elaborate little bit more what you want to do?

Thanks,
Rong-Chun Zhang

---

Please mark the replies as answers if they help and unmark if they don't.
Welcome to the All-In-One Code Framework, a sample code project owned by the MSDN Forum Support team!