Re: How to know if a table exist in a Stored Procedure?

From: "Grupo ESI" <Pedir@xxxxxxxxxxxxxxx>
Date: Fri, 8 Sep 2006 10:00:38 -0300

Hari:

Thanks for your quick help.

Best regards from Argentina,

--
Jorge L. Cotarelo

"Hari Prasad" <hari_prasad_k@xxxxxxxxxxx> escribió en el mensaje
news:uhJ87V00GHA.4972@xxxxxxxxxxxxxxxxxxxxxxx

Hi,

use dbname
go
Select object_name(id) from syscomments where text like '%table_name%'

Replace table_name with actual table name.

Thanks
Hari
SQL Server MVP

"Grupo ESI" <Pedir@xxxxxxxxxxxxxxx> wrote in message
news:eRsvJT00GHA.720@xxxxxxxxxxxxxxxxxxxxxxx

Hi,

Can anybody please tell me How to know if a table exist in a Stored
Procedure?

Thanks in advance,

--
Jorge L. Cotarelo

References:
- How to know if a table exist in a Stored Procedure?
  - From: Grupo ESI
- Re: How to know if a table exist in a Stored Procedure?
  - From: Hari Prasad

Prev by Date: Re: How to know if a table exist in a Stored Procedure?
Next by Date: Idenifying MSDE and MSDE Version via Registry
Previous by thread: Re: How to know if a table exist in a Stored Procedure?
Next by thread: Re: How to know if a table exist in a Stored Procedure?
Index(es):
- Date
- Thread

Relevant Pages

Re: How to know if a table exist in a Stored Procedure?
... Of course, if you wanted to avoid accessing the system tables, and create code that will still work in future versions (when syscomments is no longer available), try something like this: ... Most good judgment comes from experience. ... >> Jorge L. Cotarelo ...
(microsoft.public.sqlserver.msde)
Re: How to know if a table exist in a Stored Procedure?
... use dbname ... Select object_namefrom syscomments where text like '%table_name%' ... SQL Server MVP ... Jorge L. Cotarelo ...
(microsoft.public.sqlserver.msde)
How many user are conected to a MSDE Database?
... conected to a MSDE Database? ... Best regards, ... Jorge L. Cotarelo ...
(microsoft.public.vb.database)
How many user are conected to a MSDE Database? (From a VB Application)
... conected to a MSDE Database? ... Best regards, ... Jorge L. Cotarelo ...
(microsoft.public.sqlserver.msde)
Re: Supress Server Messages
... If you refer to error message sent to the client application, ... Tibor Karaszi, SQL Server MVP ... "Jorge" wrote in message ...
(microsoft.public.sqlserver.server)