creation of system procedures
-
Hi Experts,
My co- workers are saying , System procedures can be created by database developer.
I have challenged to them , it is not possible.
If possible i have to arrange party for them.
If not possible they will give party to me
Inputs are welcome !
Regards
Karthik
karthik
-
What are you going to have as the theme for this party that you're going to be putting on for your cow orkers?
Sorry.
-
David,
Is it possible to create it ? Really i want to know , I dont know whether you take my words as fun or not.
Regards
Karthik
karthik
-
I have written it just for fun.
Please tell me , is it possible to create System procedures or not ?
Regards
Karthik
karthik
-
You better start your arrangements.
You can "create" system pocedure by marking a user procedure as system with the stored sprocedure sp_MS_marksystemObject. It's an undocumented procedure which allows you to mark any object (table, view, procedure) as system object.
Markus
[font="Verdana"]Markus Bohse[/font]
-
My answer was just an attempt at a humorous method of telling you that you lost. As MarkusB stated, it's quite possible. You need to keep in mind that there's nothing really magical about system stored procedures. Go look at one of the stored procedures in master, such as sp_who2 and you can see that they are just regular stored procedures that happen to be owned by the system.
-
Marcus,
is it possible in sybase database too ? because some co - workers areworking in sybase db. if not possible i will not arrange.
How is my idea ?I would like to know , is it possible in sybase ? Please tell me.
Regards
Karthik
karthik
-
Your idea is bad. If you lose a bet, you pay up.
Even attempting to get off on a technicality won't work for you in this case.
-
Ok. I will pay up.
Bless me to get party from them in future.
Regards
Karthik
karthik
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply