Post reply

export invalid objects

  • December 19, 2005 at 8:40 pm

    #169932

    I am doing a database export with dts to another database on another server. The destination db has the same name. The tables, views and stored procedures all seem to go through, though I haven't counted them!

    It comes up with errors saying I've got invalid sql server objects some of which refer to a database that is now gone. Anyone know how I can find out where these invalid objects are?

     

    thanks

  • December 22, 2005 at 8:00 am

    This was removed by the editor as SPAM

  • December 22, 2005 at 8:10 am

    #611149

    Generally when this happens you have a stored procedure or view that cannot compile because it refers to objects that have been dropped from the database since the object was created.

    Run this query on the source db and the destination and you will find out based on type how many objects you have

    select type,count=count(*) from sysobjects group by type

    V=view, p=proc, fn=function etc..

    If the counts don't match by type you will know what was not created.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply