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 |
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
 Posted - 2006-09-05 : 16:16:26
|
| GurusHow can i ensure that there is consistency in the db objects in the db like sp and all?if one user want to modify any stored procedure then no other user can do any modifications on that sp..how do we maintain this?Please adviceRegardsNitin |
|
|
dewacorp.alliances
452 Posts |
Posted - 2006-09-05 : 21:58:16
|
| I don't think you can have a source control for the SQL 2000 as far as I remember. But I could be wrong. |
 |
|
|
Westley
Posting Yak Master
229 Posts |
Posted - 2006-09-06 : 01:40:05
|
| MS doesn't come with a source control app for SQL, but for all production DB, only DBA (or production DBA) should have access to it, so its all up to the DBA, I worked with a company before where they use VSS to keep all changes. I remember there are some 3rd party apps that "can" intergate to SQL for source control, but I never tried them before. |
|
|
|
|
|
|
Consistency in database objects