May 6, 2008 at 4:02 am
Hi ,
i moved to sql 2005 from sql 2000. Stored procedure should be in synch with both server.if i take from sysobject it shows all stored procedures. so How to find system defined stored procedure , user defined stored procedure in sql 2005 and sql 2000.
May 6, 2008 at 4:36 am
Hi niranjankumar,
All system Procedure's should start with sys.sp_.
And all the user defined procedure you want to find out by using the following stmts.
SELECT * FROM sys.sysobjects
WHERE [name] LIKE '%SP%'
AND xtype LIKE 'P'
----
May 6, 2008 at 11:11 pm
sqluser (5/6/2008)
And all the user defined procedure you want to find out by using the following stmts.SELECT * FROM sys.sysobjects
WHERE [name] LIKE '%SP%'
AND xtype LIKE 'P'
Many SQL users do not prefix their own stored procedures with 'SP', only the xtype LIKE 'P' will return the correct result too. Using xtype='S' will return the system stored procedures.
[font="Courier New"]
------------------------
MCPD Web Developer, MCPD Windows Developer[/font]
Computers are made to solve problems you did not have in the days they didn't exist.
May 12, 2008 at 8:03 am
bert (5/6/2008)
sqluser (5/6/2008)
And all the user defined procedure you want to find out by using the following stmts.SELECT * FROM sys.sysobjects
WHERE [name] LIKE '%SP%'
AND xtype LIKE 'P'
Many SQL users do not prefix their own stored procedures with 'SP', only the xtype LIKE 'P' will return the correct result too. Using xtype='S' will return the system stored procedures.
I think xtype='S' is system tables??
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply