pavan_srirangam (10/12/2010)
what is the schema of your SP its not sys. right.if you give the name with sys. spname it creates in system store proc.
I tested this and it wouldn't let me create a stored proc with the sys. prefix.
Also if you look in System Stored Procs you will see stored procs owned by dbo, so this isn't definitive.
I've looked in sys.sysobjects and can't see any way of identifying a stored proc as belonging to the system stored procs. I'm not sure how SQL determines this, does anyone else?
Leo
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.