How can we help you today? How can we help you today?

Build ErrorInvalid Object

I have set up a build definition in TFS and when I run the build I am getting an error when the build process executes sql to create a view - the create view sql includes an inner join to another database on same server.

How do I get around this issue?
Derek_Johnston_Rte1
0

Comments

1 comment

Sort by
  • Andrew P
    Hey Derek,

    Thanks for posting!
    When you do a build - it creates all of the objects to a created database on the specified SQL Server instance - that sql server instance needs to have all of the cross database and linked server dependencies available or else the build will fail.

    Because of that, customers often use a QA or Dev server to do the build - and they have static copies of other databases there so that the build can find all of the required dependencies.

    If that is not the issue - would you mind sending in the full build log as well as a screenshot of the build definition?

    Kind Regards,
    Andrew P
    0

Add comment

Please sign in to leave a comment.