This is not working for me in sql 2000. It works well in sql 2005
use mosaikdb741
select object_definition(o.object_id),o.name from sys.objects as o
thanks a lot
what s the equivalenet of object_definition in sql 2000 pls
Hot Topic
- Homophones and Synonyms
- SQL 2000 - How to Reduce data files from 2 to 1?
- Out of virtual memory
- SQL 2005 Index Issue – General Network Error
- Problem calling Stored Procedure from C#
- SQL & Passwords
- Why is TOP executed last?
- Installing/Deploying Windows App with SQL Server 2005 CE
- .Net CF 2.0 Error , "Can't find PInvoke DLL 'dbnetlib.dll'."
- How can we limit the data regions in a specific report page?
SQL Server
- Cannot Attach a Visual Web Developer Created DB in SQL SMS
- Management Studio output of queries with regional settings
- Regular Expressions in SQL 2005 using C#
- Report Builder percent calculation.
- Identifying obsolete views
- Foreign Key - ON DELETE RESTRICT
- Excel 2003 with MSFT Query cannot refresh data on Analysis Services 2005
- Oracle Client Exception
- F7 Key : Summary -> Object Explorer Details
- Cannot connect to oracle using SSIS on Windows 2003 Server with 64 bit
what s the equivalenet of object_definition in sql 2000 pls
govindpandey
OBJECT_DEFINITION is a new function in SQL Server 2005. The nearest equivalent system stored procedure for this in SQL Server 2000 is the sp_helptext, which will only work for stored procedures, user-defined functions, triggers and views.
SQL Server Helper
http://www.sql-server-helper.com
PK_VBE05
how d this translate using sp_helptext then
exec
sp_msforeachdb 'select '' '', o.name, object_definition(o.object_id) from [ ].sys.objects as o where
object_definition(o.object_id) like ''%mykeyword%'' and o.type=''P'''
Thanks a lot
Banna
use the system table syscomments in sql server 2000.
exec sp_msforeachdb '
select '' '', o.name, c.text from sysobjects as o join syscomments as c on (o.id=c.id) where
c.text like ''%mykeyword%'' and o.xtype=''P'''