Error:208 [SQL Server] Invalid Object Name  
Author Message
OvErboRed





PostPosted: Fri Jan 02 16:52:25 CST 2004 Top

SQL Server >> Error:208 [SQL Server] Invalid Object Name

Hello

I was adding a line to a store procedure in MS SQL 6.5 when I saved the server gave an error about the stored procedure being more than 255 lines after my edit. I selected NO to save changes but when the Enterprise Manager windows refreshed the stored procedure was gone from the list

I had backed up the text of the SP in a text file so I open a new SP windows, pasted in the text, but received the Error: 208 Invalid Object Name error when I tried to hit save. Rebooted the server...same issue. I have checked at least 10 times and SP is not listed. I have modified nothing about this SP so would think it would just 'go back in.

Anyhelp would be greatly appreciated

Thanks in advance.

SQL Server280  
 
 
James





PostPosted: Fri Jan 02 16:52:25 CST 2004 Top

SQL Server >> Error:208 [SQL Server] Invalid Object Name BK,

Try running a DROP PROCEDURE [myProcName] to see if that wipes it out before
you attempt to create it again.

James Hokes



> Hello,
>
> I was adding a line to a store procedure in MS SQL 6.5 when I saved the
server gave an error about the stored procedure being more than 255 lines
after my edit. I selected NO to save changes but when the Enterprise
Manager windows refreshed the stored procedure was gone from the list.
>
> I had backed up the text of the SP in a text file so I open a new SP
windows, pasted in the text, but received the Error: 208 Invalid Object Name
error when I tried to hit save. Rebooted the server...same issue. I have
checked at least 10 times and SP is not listed. I have modified nothing
about this SP so would think it would just 'go back in.'
>
> Anyhelp would be greatly appreciated.
>
> Thanks in advance.


 
 
Erland





PostPosted: Fri Jan 02 17:46:25 CST 2004 Top

SQL Server >> Error:208 [SQL Server] Invalid Object Name
> I was adding a line to a store procedure in MS SQL 6.5 when I saved the
> server gave an error about the stored procedure being more than 255
> lines after my edit. I selected NO to save changes but when the
> Enterprise Manager windows refreshed the stored procedure was gone from
> the list.
>
> I had backed up the text of the SP in a text file so I open a new SP
> windows, pasted in the text, but received the Error: 208 Invalid Object
> Name error when I tried to hit save. Rebooted the server...same issue.
> I have checked at least 10 times and SP is not listed. I have modified
> nothing about this SP so would think it would just 'go back in.'

So which name did SQL Server list in the 208 message? I would guess
that you are trying to create the procedure in the wrong database, and
one or more tables that the procedure refers to does not exist in this
database.

You could also try to create the procedure through a query window.


--


Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
 
 
Hari





PostPosted: Fri Jan 02 20:41:17 CST 2004 Top

SQL Server >> Error:208 [SQL Server] Invalid Object Name Hi,

Before creating the procedure , can you login to ISQLW and run the below
select statement on your database

select name from sysobjects where type='p' and name ='name of the procedure'

Incase if the statement return values , use drop proc <proc name> to drop.

After this cut and paste the procedure in the same window and create the
procedure.

Thanks
Hari
MCDBA




> > I was adding a line to a store procedure in MS SQL 6.5 when I saved the
> > server gave an error about the stored procedure being more than 255
> > lines after my edit. I selected NO to save changes but when the
> > Enterprise Manager windows refreshed the stored procedure was gone from
> > the list.
> >
> > I had backed up the text of the SP in a text file so I open a new SP
> > windows, pasted in the text, but received the Error: 208 Invalid Object
> > Name error when I tried to hit save. Rebooted the server...same issue.
> > I have checked at least 10 times and SP is not listed. I have modified
> > nothing about this SP so would think it would just 'go back in.'
>
> So which name did SQL Server list in the 208 message? I would guess
> that you are trying to create the procedure in the wrong database, and
> one or more tables that the procedure refers to does not exist in this
> database.
>
> You could also try to create the procedure through a query window.
>
>
> --

>
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp


 
 
Wayne





PostPosted: Sat Jan 03 08:48:56 CST 2004 Top

SQL Server >> Error:208 [SQL Server] Invalid Object Name A common reason for this in SQL 6.5 is that the sp refers to a temp table...
If it does, you must create the temp table, then create the sp, then drop
the temp table to get the sp created.

--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), C****te, NC
www.computeredservices.com
(Please respond only to the newsgroups.)

I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org




> Hello,
>
> I was adding a line to a store procedure in MS SQL 6.5 when I saved the
server gave an error about the stored procedure being more than 255 lines
after my edit. I selected NO to save changes but when the Enterprise
Manager windows refreshed the stored procedure was gone from the list.
>
> I had backed up the text of the SP in a text file so I open a new SP
windows, pasted in the text, but received the Error: 208 Invalid Object Name
error when I tried to hit save. Rebooted the server...same issue. I have
checked at least 10 times and SP is not listed. I have modified nothing
about this SP so would think it would just 'go back in.'
>
> Anyhelp would be greatly appreciated.
>
> Thanks in advance.


 
 
Kalen





PostPosted: Sat Jan 03 13:45:21 CST 2004 Top

SQL Server >> Error:208 [SQL Server] Invalid Object Name Hi Brandon

Can you try using isqlw instead of EM to create the proc from your saved
text file.
If that doesn't help, can you post the text of the procedure?

--
HTH
----------------
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com




> Hello,
>
> I was adding a line to a store procedure in MS SQL 6.5 when I saved the
server gave an error about the stored procedure being more than 255 lines
after my edit. I selected NO to save changes but when the Enterprise
Manager windows refreshed the stored procedure was gone from the list.
>
> I had backed up the text of the SP in a text file so I open a new SP
windows, pasted in the text, but received the Error: 208 Invalid Object Name
error when I tried to hit save. Rebooted the server...same issue. I have
checked at least 10 times and SP is not listed. I have modified nothing
about this SP so would think it would just 'go back in.'
>
> Anyhelp would be greatly appreciated.
>
> Thanks in advance.