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 |
|
pratheepsen
Starting Member
8 Posts |
 Posted - 2006-11-06 : 04:02:06
|
| how can i read line by line from notepad using sql server 2005 T-SQL |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-11-06 : 04:06:10
|
| What is the purpose of doing this? Do you want to read it into table?Check out the following link:[url]http://www.sqlusa.com/bestpractices2005/notepad/[/url]Harsh AthalyeIndia."Nothing is Impossible" |
 |
|
|
pratheepsen
Starting Member
8 Posts |
Posted - 2006-11-06 : 06:09:21
|
| we make changes daily in db. so we keep script on separatly using notepad one by one orderly. when i execute the script . it missing some stmt . to avoid this i am going to execute line by line using dynamic sql. |
|
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-11-06 : 06:27:18
|
| I didnt understood somthing, if you are adding all the changes in the database line by line then how somthing is missing in your db updates file? you require to maintain your database updates in the proper way, rather then running them in a dynamic sql.Chiraghttp://chirikworld.blogspot.com/ |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-11-06 : 06:32:14
|
| Whoa!!!If I understood correctly, then you are duplicating the functionality of LOG WRITER process...My original question still remains...Why you do this?Harsh AthalyeIndia."Nothing is Impossible" |
|
|
|
pratheepsen
Starting Member
8 Posts |
Posted - 2006-11-06 : 06:41:21
|
| we have test server and production sever. we make changes(alter,create,sp_rename) in test server.how can i maintained the scirpt . because monthly ones we have to updated the production server. |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-11-06 : 06:44:40
|
| You need a good version control software, nothing more than that !Harsh AthalyeIndia."Nothing is Impossible" |
|
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
|
|
pratheepsen
Starting Member
8 Posts |
Posted - 2006-11-06 : 07:38:46
|
| thanks for sharing |
|
|
|
|
|
|
sql server 2005