Extended Stored Procedures question

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

Select * from master.dbo.sysobjects where XType = 'X'

SQLguy-186994 Old Hand Points: 323 More actions · Answer 2

Thanks, that's cool.

There are other Xtypes in the sysobjects table, does anyone know what these are? They are D, FN, P, S, TF, U, V, X.

Where do you find out nitty gritty stuff like this? My SQL book is pretty thick and it doesn't really go into this kind of detail.

thanks.

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 3

Check in the books online under sysobjects / sysobjects

C = Constraint CHECK

D = Default value or DEFAULT constraint

F = FOREIGN KEY Constraint

FN = Scalar User defined function (returns interger or any variable)

L = Log

IF = Inline User defined function (A select query)

P = Stored procedure

PK = PRIMARY KEY CONSTRAINT

RF = Replication Stored Procedure

S = System table

TF = Table function (returns a table variable)

TR = Trigger

UQ = Unique constraint

V = View

X = Extended stored procedure

Frank Kalis SSC Guru Points: 111183 More actions · Answer 4

Extended stored procedures are not stored in any table. They are usually in a DLL file. You can find this out by running something like this:

USE master

GO

EXEC sp_helpextendedproc 'xp_cmdshell'

GO

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]