SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Error 208
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

rmrper99
Starting Member

29 Posts

Posted - 04/26/2004 :  10:03:25  Show Profile  Reply with Quote
Good morning. I am trying to create a tsql job to run nightly and I am receiving error 208. When I run the sql statement through query, it runs fine, however when I try to put it into the job wizard and parse it, I receive error 208 invalid object. I have checked and the owner for the object is dbo.

Note: When I put in a select statement from that table it works, but my statement is an insert statement and that is when I get the error.

Any ideas?

RickD
Slow But Sure Yak Herding Master

United Kingdom
3608 Posts

Posted - 04/26/2004 :  10:07:44  Show Profile  Reply with Quote
Are you trying to create a table which already exists but with a different owner?

If not, can you post your code?
Go to Top of Page

samsekar
Constraint Violating Yak Guru

India
437 Posts

Posted - 04/26/2004 :  10:09:49  Show Profile  Reply with Quote
Try dbname.dbo.tableA..

- Sekar
Go to Top of Page

rmrper99
Starting Member

29 Posts

Posted - 04/26/2004 :  11:31:42  Show Profile  Reply with Quote
I am not trying to create a table. I am trying to insert into a table. I have tried dbname.dbo.table and that doesn't work either.
Here is my code.

insert into familypwd ("family number", "pedalyear") select distinct "family number", "pedalyear" from familylink
where "family number" >= 1 and "family number" not in (select "family number" from [familypwd]);
Go to Top of Page

RickD
Slow But Sure Yak Herding Master

United Kingdom
3608 Posts

Posted - 04/26/2004 :  11:34:55  Show Profile  Reply with Quote

insert into familypwd ([family number], pedalyear) 
select distinct [family number], pedalyear
from familylink
where [family number] >= 1 
and [family number] not in (select [family number] from familypwd)

Try that instead of using ""
Go to Top of Page

rmrper99
Starting Member

29 Posts

Posted - 04/26/2004 :  11:37:58  Show Profile  Reply with Quote
Thanks. However the problem is that it is saying familypwd is the incorrect object.
Go to Top of Page

rmrper99
Starting Member

29 Posts

Posted - 04/26/2004 :  11:40:28  Show Profile  Reply with Quote
Rick. I tried that and it worked. Very weird! Thank you VERY VERY much!
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000