SQL SERVER 2005 quick find replace ctrl+h ect..

• jramepe

  Grasshopper

  Points: 11

  More actions

  February 20, 2008 at 4:36 am

  #179312

  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.

• Grant Fritchey

  SSC Guru

  Points: 399038

  More actions

  February 20, 2008 at 6:01 am

  #780158

  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