How to change text in syscomments?

• Vidas Zabinskas

  Hall of Fame

  Points: 3258

  More actions

  May 17, 2005 at 1:14 am

  #87551

  We have a lot of refferenced views to other server and now we need to change server name into other. Does anyone know any way to change for IE:

  create view TT as  select * from server123.DB.dbo.table 

  to

  create view TT as  select * from server345.DB.dbo.table 

  Speaking in other words is there any way to convert one symbols combination into other

   

  Thanks in advance

• Vidas Zabinskas

  Hall of Fame

  Points: 3258

  More actions

  May 17, 2005 at 2:50 am

  #559194

  I thought there is more simple way to achieve that by altering view in a cursor. Previously typed way isn't right

• Chris Hedgate

  One Orange Chip

  Points: 25041

  More actions

  May 17, 2005 at 5:29 am

  #559212

  I would probably just script the views and then use Find&Replace in the script, and run it back in again.

  --
  Chris Hedgate http://www.hedgate.net/
  Contributor to the Best of SQL Server Central volumes
  Articles: http://www.sqlservercentral.com/columnists/chedgate/

• Vidas Zabinskas

  Hall of Fame

  Points: 3258

  More actions

  May 17, 2005 at 5:37 am

  #559215

  

  Yes, quite simple way. I'll use it next time. Now I've allready fixed that

  Thanks