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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-03-04 : 08:17:03
|
| Sumanesh M writes "Hi SQL Team,I want to maintain all my SP, Table, Views in VSS. So that I have to check them out from VSS to change them (Alter statement). I know how to control the same using Visual Studio.Net, but still I can alter them if I login to Query Analyser. Is there any other way to achieve the same. My requirement is simple, I want to checkout from VSS before ALTERing anything anywhere (Using code or using Query Analyser or using VS.Net) and to maintain version support.Thanks Sumanesh" |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2005-03-04 : 09:44:52
|
| You can't protect the database from being changed by someone who has the database rights to do so simply by having the scirpts that create/alter the database objects in source safe. Your code can be protected by VSS in case something does get changed or dropped just like your VS.Net code is. For your VS code, someone could "get latest" without checking out and make writable, alter and compile code and deploy those changes as well. That is the equivalant of using Query Analyzer to alter a sql objects.Be One with the OptimizerTG |
 |
|
|
|
|
|
SQL Server and VSS