List Stored Procedures From Query Analyzer in SQL 2000
I know not too many of you will need this, but I’ll have to look this back up at some point 😉
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 | USE databasename
SET NOCOUNT ON
SELECT
ROUTINE_NAME
FROM
INFORMATION_SCHEMA.ROUTINES
WHERE
ROUTINE_TYPE = 'PROCEDURE'
AND OBJECTPROPERTY
(
OBJECT_ID(ROUTINE_NAME),
'IsMsShipped'
) = 0
ORDER BY
ROUTINE_NAME |
Another option is one of the system stored procedures. Something like:
exec sp_stored_procedures
That’ll list all sp’s for the selected DB and you can throw arguments at it like “exec sp_stored_procedures ‘g%’ ” and get all sp’s that start with “g”. Might save ya typin a lil. 😉
Ha, nice lil tip there Mr. Asher! I didn’t think anyone had any reason to touch SQL2K. I know you are giving up your life of windows for one of endless Mac treasures 😛
I still have to maintain some of my VB6 apps that use SQL Server 2005 databases. Plus, I have a few apps running with SQL2000/MSDE here and there. Mac “treasures”….yeah….sumpin like that. :-/ I’d move everything to linux if I could. Paid support is important to them…even though it hasn’t worked very well at all for the Mac’s! At this point, I’d even take Winders AD over the Mac’s. 😀
AD just works. I’ve been working with it since 2K and I dig it! I have to say that I haven’t worked with the Macs, but then again all my environments have always been Windows…eh 😛
VB6 FTW 😉 Autoit for second place 🙂