SQL Server Performance Forum – Threads Archive
procedure mark as "System"
One procedure,sp__spaceavail, must be marked as "system" after it is added to master DB.
anyone have any idea , wht does it mean with system
All store procedures belong to SQL begin with sp_.
That’s why allways you have to write your own store procedure with differents names. Like mysp_.
If SQL find any store procedure with sp_, begin to search his own procedures and after begin to search yours.
I suppose that is the reason because your store procedure sp_spaceavail, was marked as system.
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS†with no warranties for accuracy.
Its sp__spaceavail not sp_ anyway how to mark it as system, any idea? Rajiv
SQL-DBA
Yes, but the first three characters are still sp_ no matter what you put after it, it starts with sp_
so sp__ is no different than sp_a or sp_x or whatever, its still sp_[plus more characters] The first 3 characters should not be sp_ and that should do it.
I have to improve my English[<img src=’/community/emoticons/emotion-6.gif’ alt=’
‘ />].<br /><br />Luis Martin<br />Moderator<br />SQL-Server-Performance.com<br /><br /><font size="1">One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important<br />Bertrand Russell<br /></font id="size1"><br /><br /><font size="1">All postings are provided “AS IS†with no warranties for accuracy.</font id="size1"><br /><br /><br /><br />
Your english is better than alot of people for whom its their first language. I wouldnt worry Luis.
Anyway, if Rajiv really wants to make this a system sp (which I dont recommend) then the information can be found in BOL by searching for "system stored procedures" and looking at Creating a Stored Procedure in the section called system stored procedures (go figure) Now, keeping with what is in this section, I’ll throw this out to emphasize why not to use sp_ for user created sprocs: "It is strongly recommended that you do not create any stored procedures using sp_ as a prefix"
Google for the use of the undocumented sp_MS_marksystemobject. Should give you what you need, but I would refrain from doing so… —
Frank Kalis
SQL Server MVP
http://www.insidesql.de
I wouldn’t worry much to mark it whether as a system or user object and one should not create any stored procedures on the master database. If this is a user defined stored procedure even though return the values from system SPs then better to create in the user databases. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Hi <br /><br />i want to create 30 procedures in master and i got 30 files in my folder c
roce .anyway/script i can use to automate this process<br /><br />Logic<br /><br />for 1 to 30<br />read file from croce,create<br />end<br /><br /><br />is tht possible <img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ /> , jsut a doubt<br /><br /><br />
Why would you need to automate a process to create 30 system procedures in master??? You can do what you are describing. Look up osql in Books Online. MeanOldDBA
[email protected]l.com When life gives you a lemon, fire the DBA.
]]>