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.
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
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
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… —
SQL Server MVP
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
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 croce .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.