EM 2000 to define views of 2005 tables ?

• toni.sala

  SSC Rookie

  Points: 48

  More actions

  February 11, 2009 at 3:21 pm

  #71858

  Hello, does anybody know if it's possible to use EM 2000 to define views from 2005 tables ?

  Thanks a lot

• happycat59

  One Orange Chip

  Points: 29451

  More actions

  February 11, 2009 at 7:43 pm

  #942577

  I am pretty sure the answer is no. This is because Enterprise Manager uses SQL-DMO to access SQL Server instances and this does not support SQL 2005.

  However, you are able to use Query Analyzer if you wish although some bits of it don't work you can connect to SQL 2005 databases and run queries.