September 12, 2002 at 5:18 pm
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
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
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