Very Computer

by **john** » Thu, 10 Jan 2002 08:38:22

Is it possible to get the actual T-SQL Syntax out of a SQL
Server stored proceduer via ADOX? I can enumerate through
all the proceduers in a database and see their name, but i
cant seem to get the T-SQL syntax out. There is a Command
property of the Procedure object, but every time i try to
use it i get an interface not supported error. Is there
anything i can do?

by **Kally Wang(** » Fri, 11 Jan 2002 21:44:57

Hi John,

The Microsoft OLE DB Provider for SQL Server (SQLOLEDB) and the Microsoft
OLE DB Provider for ODBC (MSDASQL) does not support all ADOX features
including the Command property of Procedure object.

To get the detailed content of a stored procedure, you can use the system
stored procedure: sp_helptext

For more information on this, please refer to the following article:
http://msdn.microsoft.com/library/en-us/tsqlref/ts_sp_help_7c38.asp

I hope this helps.

This posting is provided "AS IS" with no warranties, and confers no rights.
Copy Right, 2001 Microsoft Corporation. All rights reserved.

Regards,

Kally Wang
Microsoft Support Engineer

== Original Message ==

Subject: ADOX stored procedures question
Date: Tue, 8 Jan 2002 15:38:22 -0800
Newsgroups: microsoft.public.vb.database.ado

Is it possible to get the actual T-SQL Syntax out of a SQL
Server stored proceduer via ADOX? I can enumerate through
all the proceduers in a database and see their name, but i
cant seem to get the T-SQL syntax out. There is a Command
property of the Procedure object, but every time i try to
use it i get an interface not supported error. Is there
anything i can do?

by **john** » Sat, 12 Jan 2002 07:48:20

Thanks,
Actually i ended up going with the SQL DMO object
instead. It gave me much more control over the SQL
objects.

Quote:>-----Original Message-----
>Hi John,

>The Microsoft OLE DB Provider for SQL Server (SQLOLEDB)
and the Microsoft
>OLE DB Provider for ODBC (MSDASQL) does not support all
ADOX features
>including the Command property of Procedure object.

>To get the detailed content of a stored procedure, you
can use the system
>stored procedure: sp_helptext

>For more information on this, please refer to the
following article:
>http://msdn.microsoft.com/library/en-

us/tsqlref/ts_sp_help_7c38.asp

- Show quoted text -

>I hope this helps.

>Regards,

>Kally Wang
>Microsoft Support Engineer

>== Original Message ==

>Subject: ADOX stored procedures question
>Date: Tue, 8 Jan 2002 15:38:22 -0800
>Newsgroups: microsoft.public.vb.database.ado

>Is it possible to get the actual T-SQL Syntax out of a
SQL
>Server stored proceduer via ADOX? I can enumerate
through
>all the proceduers in a database and see their name, but
i
>cant seem to get the T-SQL syntax out. There is a
Command
>property of the Procedure object, but every time i try to
>use it i get an interface not supported error. Is there
>anything i can do?

>.