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 |
|
Rachel_ch19
Starting Member
5 Posts |
 Posted - 2011-07-21 : 13:35:13
|
| Hi, I'm trying to organize my SQL codes and link them together. Sometimes I need to find the source of some files. Is there a way that I can search text(file name/variable) within multiple SQL files? The windows search doesn't seem to search within the SQL code. Thank you! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-07-21 : 13:41:20
|
| you've find option inside sql management studio editor.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
Rachel_ch19
Starting Member
5 Posts |
Posted - 2011-07-21 : 14:09:36
|
| What option should I look for? Wouldyou please let me know under which tree? |
|
|
|
Ghanta
Yak Posting Veteran
96 Posts |
Posted - 2011-07-21 : 15:32:00
|
quote:
Originally posted by Rachel_ch19
What option should I look for? Wouldyou please let me know under which tree?
"EDIT" in SQL Server Management Studio |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Rachel_ch19
Starting Member
5 Posts |
Posted - 2011-07-25 : 13:13:03
|
| SQL codes that the user wrote(created) to execute a certain procedure. The edit option won't work because of the following:I'm trying to look for a certain text by not opening a SQL code. I have many SQL codes stored in one location, and I need to look for in those files. If I open each one and do a ctrl-F, it will take a long time. So is there a way to search it in all the files?Thanks! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
How to search text within multiple SQL code files?