|
17>
18> SELECT
19> *
20> FROM
21> sysobjects
22> WHERE
23> type IN('FN', 'TF')
24> AND
25> uid IN(user_id('system_function_schema'),
26> user_id('dbo'))
27> GO
name
id xtype uid info status base_schema_ver replinfo parent_obj crdate ftc
atid schema_ver stats_schema_ver type userstat sysstat indexdel refdate version deltrig instrig
updtrig seltrig category cache
------------------------------------------------------------------------------------------------------------------------
-------- ----------- ----- ------ ------ ----------- --------------- ----------- ----------- ----------------------- ---
---- ----------- ---------------- ---- -------- ------- -------- ----------------------- ----------- ----------- -------
---- ----------- ----------- ----------- ------
linear_max
318676233 FN 1 0 0 0 0 0 2007-10-22 04:26:43.660
0 0 0 FN 0 0 0 2007-10-22 04:26:43.660 0 0
0 0 0 0 0
fn_linear_max
386152471 FN 1 0 0 0 0 0 2007-10-22 04:00:40.323
0 0 0 FN 0 0 0 2007-10-22 04:00:40.323 0 0
0 0 0 0 0
(2 rows affected)
1>
2>
|