DTS not copying views and stored procedures

• gfahrlander

  SSCommitted

  Points: 1888

  More actions

  October 24, 2002 at 10:42 am

  #105180

  MSSQL 2000 import from another server, selected all tables, views and stored procedures. Only the tables were imported with successful completion message. What's up with that?

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  October 24, 2002 at 6:38 pm

  #439414

  Never had an issue with it. Have you tried to repro?

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter