See codee that created a view

• turkey-500673

  Mr or Mrs. 500

  Points: 516

  More actions

  January 1, 2009 at 7:05 pm

  #203401

  Hello! I have a problem I don't have EM and I'm trying to re-create the code that created a view. Is there any way I can do that using tsql?

  I'm using SQL 2000

  Thanks

  Emil

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  January 1, 2009 at 7:20 pm

  #920063

  Exec sp_helptext 'view name'

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question

• turkey-500673

  Mr or Mrs. 500

  Points: 516

  More actions

  January 1, 2009 at 7:39 pm

  #920070

  Works! Thanks and Happy New Year.