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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 process help

Author  Topic 

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2006-10-17 : 01:53:11
Dear friends,
I'm working on 5 different servers,my work is to write the script and make it to run successfully.

I've two databases for me one to test the script and the other for the final script. after that i'l implement in other servers. after successful execution, the testing team will take care. now my problem is, some times i'm not able to find the exact script which was successfully runned.(on some servers, modifications were done.because some dependencies will be increased).

my question is how to maintain the exact script? may be this is a silly question, but after one week i'm not able to find the exact script.

please help me in this regard with your valuble suggesions.

Vinod

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2006-10-17 : 02:26:19
I am not clear what you want.

What do you mean by "exact script"?

Harsh Athalye
India.
"Nothing is Impossible"
Go to Top of Page

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2006-10-17 : 05:45:40
Some times i'm changing according to the client requirements.
and i'm saving that with a new name.for every server, i'm writing to the script and later changing according to the client.

after fewdays, i was unable to find the original version.this is a burning problem for me.

Vinod
Go to Top of Page

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2006-10-17 : 06:06:20
quote:
Originally posted by sunsanvin

Some times i'm changing according to the client requirements.
and i'm saving that with a new name.for every server, i'm writing to the script and later changing according to the client.

after fewdays, i was unable to find the original version.this is a burning problem for me.

Vinod



Seems like this is version control problem !

Use version control software like Microsoft VSS.
Store all your scripts on it and make changes from there so you can always find out all versions you created.

Harsh Athalye
India.
"Nothing is Impossible"
Go to Top of Page
   

- Advertisement -