February 20, 2008 at 4:36 am
Hi all,
I can not use the functions in the menu edit / find and replace.
When I select quick find(ctrl+h) for example, I lost the focus on sql server management studio.
Please, could you help me?
Thanks and regards,
Javier.
February 20, 2008 at 6:01 am
Well, it depends. If you have a TSQL script open, it should work just fine (just tested it to reconfirm). If you don't have a script open, the replace window has a blank "Look In" field. If you're trying to do a search & replace on column names throughout a database, it won't work because SQL Server just doesn't work that way. The objects are stored within the database, not represented as text in a file. To change things you have to run DML scripts to modify data or DDL scripts to modify the structures. So to change data within a column you'd have to run an UPDATE ... WHERE... script. To change a column name, you can run sp_rename.
Any of that help at all?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply