Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
rmrper99
Starting Member
29 Posts |
Posted - 2004-04-26 : 10:03:25
|
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
3608 Posts |
Posted - 2004-04-26 : 10:07:44
|
Are you trying to create a table which already exists but with a different owner?If not, can you post your code? |
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
Posted - 2004-04-26 : 10:09:49
|
Try dbname.dbo.tableA..- Sekar |
|
|
rmrper99
Starting Member
29 Posts |
Posted - 2004-04-26 : 11:31:42
|
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 familylinkwhere "family number" >= 1 and "family number" not in (select "family number" from [familypwd]); |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2004-04-26 : 11:34:55
|
[code]insert into familypwd ([family number], pedalyear) select distinct [family number], pedalyearfrom familylinkwhere [family number] >= 1 and [family number] not in (select [family number] from familypwd)[/code]Try that instead of using "" |
|
|
rmrper99
Starting Member
29 Posts |
Posted - 2004-04-26 : 11:37:58
|
Thanks. However the problem is that it is saying familypwd is the incorrect object. |
|
|
rmrper99
Starting Member
29 Posts |
Posted - 2004-04-26 : 11:40:28
|
Rick. I tried that and it worked. Very weird! Thank you VERY VERY much! |
|
|
|
|
|