user schema issue

• balaji.ganga

  SSCrazy

  Points: 2280

  More actions

  October 13, 2010 at 1:51 am

  #230337

  Hi All,

  Our Scenario is we can upgrade from sql 2000 to 2008 server.

  I restore sqlserver 2000 db's to sqlserver 2008 express edition client tools.Then i change the

  compatablilty mode.

  I used to select * from sysobjects query..

  Some of the objects comes under dbo schema and some of the objects comes under user schema..

  when i ran the dbo schema objects using select query.. it's executed and

  if i ran the user schema objects, it shows invalid object name.

  I had checked the source server like sql 2000 dev server.. User schema objects ran successfully

  using normal select query.

  Can you pls advise me.. where is the problem occurs.. how can i fix it?

  Regards

  Balaji.G

• RichardDouglas

  SSCarpal Tunnel

  Points: 4029

  More actions

  October 14, 2010 at 6:51 am

  #1236799

  OK, a couple of things:

  Have you tried running DBCC commands on the newly upgraded databases?

  It's generally a good idea to update statistics and check the integrity of the databases once they have been upgraded.

  If you run SELECT * FROM Sys.Schemas do you see all the schemas you were expecting?

  Hope this helps,
  Rich

  [p]
  [/p]