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.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Database objects

Author  Topic 

starnold
Yak Posting Veteran

83 Posts

Posted - 2008-10-16 : 09:10:03
Where can you find the database objects?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-10-16 : 09:16:16
look at sysobjects system table
Go to Top of Page

starnold
Yak Posting Veteran

83 Posts

Posted - 2008-10-16 : 09:18:21
is there a transact sql query to bring this up?
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-10-16 : 09:23:16
In SQL Server 2005 look for sys.objects too


Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

starnold
Yak Posting Veteran

83 Posts

Posted - 2008-10-16 : 09:25:23
I am trying to find the parsevalues object but can't find it?
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-10-16 : 09:59:11
select * from sys.objects
where type in ('FN','TF','IF')


Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-10-16 : 12:45:49
quote:
Originally posted by starnold

I am trying to find the parsevalues object but can't find it?


ah...you meant this?

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=112678

its actually a user defined function. you can find it here

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=111986
Go to Top of Page
   

- Advertisement -