<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
Administering
»
after making a non system stored procedure it...
14 posts, Page 1 of 2
1
2
»»
after making a non system stored procedure it appears in the system stored procedure folder
Rate Topic
Display Mode
Topic Options
Author
Message
bryan van ritter
bryan van ritter
Posted Thursday, September 23, 2010 4:20 PM
SSC Journeyman
Group: General Forum Members
Last Login: Monday, April 01, 2013 12:35 AM
Points: 82,
Visits: 443
Hi,
i have this strange thing going on. when i create a procedure in the master database it appears in the system stored procedures folder. can anyone explain me how this comes. maybe something to do with the user mapping?? platform: sql server 2005 64-bits enterprise / os : windows 2003 64-bits enterprise
kind regards,
Bryan
Post #992396
Bhuvnesh
Bhuvnesh
Posted Friday, September 24, 2010 1:27 AM
SSCrazy
Group: General Forum Members
Last Login: Tuesday, March 26, 2013 8:41 AM
Points: 2,562,
Visits: 3,451
What is the name of that SP?
-------Bhuvnesh----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post
Post #992526
bryan van ritter
bryan van ritter
Posted Friday, September 24, 2010 1:36 AM
SSC Journeyman
Group: General Forum Members
Last Login: Monday, April 01, 2013 12:35 AM
Points: 82,
Visits: 443
the name is random. not a specific name op this SP. let's call it test.
Post #992529
MANU-J.
MANU-J.
Posted Sunday, October 10, 2010 2:25 AM
SSCommitted
Group: General Forum Members
Last Login: Yesterday @ 1:56 PM
Points: 1,658,
Visits: 8,564
Is your problem resolved?
MJ
Post #1001784
bryan van ritter
bryan van ritter
Posted Monday, October 11, 2010 1:25 AM
SSC Journeyman
Group: General Forum Members
Last Login: Monday, April 01, 2013 12:35 AM
Points: 82,
Visits: 443
My problem is not solved yet. i hope someone can help me on this one. maybe it's a user issue??
so normally when you create a stored procedure in the master database it will not end up in the system stored procedures folder, but in my case it is.
kind regards,
Bryan
Post #1001956
paul.knibbs
paul.knibbs
Posted Tuesday, October 12, 2010 3:37 AM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 2:19 AM
Points: 1,257,
Visits: 4,258
You're not prefacing the name of your procedure with sp_, are you? That's reserved for system stored procedures.
Post #1002643
bryan van ritter
bryan van ritter
Posted Tuesday, October 12, 2010 4:22 AM
SSC Journeyman
Group: General Forum Members
Last Login: Monday, April 01, 2013 12:35 AM
Points: 82,
Visits: 443
No not using sp_.....
Post #1002659
Leo.Miller
Leo.Miller
Posted Tuesday, October 12, 2010 3:05 PM
SSC-Addicted
Group: General Forum Members
Last Login: Yesterday @ 8:07 PM
Points: 442,
Visits: 1,301
I've tested this on my SQL 2005 server and can't get it to save an object in System Stored procs.
Are you sure they are actually defined as system stored procs? In SQL 2005 the view is a bit misleading as there isn't a seperate User Stored Procs folder. All the user stored procs appear under "Stored Procedures", and there is a seperate "System Stored Procedures" folder on the same level, but it's at the top of the list, so it does look a bit like everythin is in that folder.
Cheers
Leo
Post #1003232
@SQLFRNDZ
@SQLFRNDZ
Posted Tuesday, October 12, 2010 5:03 PM
SSC-Addicted
Group: General Forum Members
Last Login: 2 days ago @ 12:03 PM
Points: 412,
Visits: 862
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.
--
SQLFRNDZ
Post #1003290
Leo.Miller
Leo.Miller
Posted Tuesday, October 12, 2010 5:32 PM
SSC-Addicted
Group: General Forum Members
Last Login: Yesterday @ 8:07 PM
Points: 442,
Visits: 1,301
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
Post #1003297
« Prev Topic
|
Next Topic »
14 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
