Post reply

Object question

  • September 12, 2002 at 5:18 pm

    #173338

    Hello. I'm using an insert into in one my procedures and I'm having a problem with it. It gives me "Invalid object name 'dbo.Advertisers'" error. I use it like "insert into dbo.[Advertisers]..." and there is a table name Advertisers on the database with the owner "dbo". What's the problem with this?

  • September 12, 2002 at 6:32 pm

    #436452

    The problem is that when you use Select Into it creates a nwe table with the result of the table you select. So, no other table must exists when you specified the select into.

  • September 12, 2002 at 9:25 pm

    #436460

    I just realised that I didn't selected the database from drop down list in query analyzer. The master database was selected by default. duh! 🙂

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

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