School Assignment? Project Due Tomorrow? Chat LIVE With A Programming Expert!

Programming Help

Web Development



What's Here?

  • Members: 300,480
  • Replies: 826,136
  • Topics: 137,481
  • Snippets: 4,420
  • Tutorials: 1,148
  • Total Online: 1,765
  • Members: 74
  • Guests: 1,691

Welcome to Dream.In.Code
Become an Expert!

Join 300,480 Programmers for FREE! Get instant access to thousands of experts, tutorials, code snippets, and more! There are 1,765 people online right now. Registration is fast and FREE... Join Now!




compiling stored procedures in master database

 

compiling stored procedures in master database
jotadeus10

5 Jun, 2009 - 12:48 PM
Post #1

New D.I.C Head
*

Joined: 5 Jun, 2009
Posts: 1
after compiling a common procedure in the master database, it is as system stored procedure and not as a normal store procedure.
not the name of the procedure starts with sp_


example :
use master
go
create proc1 as select GETDATE ()

User is offlineProfile CardPM
+Quote Post


sloanthrasher

RE: Compiling Stored Procedures In Master Database

5 Jun, 2009 - 12:58 PM
Post #2

New D.I.C Head
*

Joined: 31 May, 2009
Posts: 17



Thanked: 1 times
My Contributions
What database and version are using? What OS?
User is offlineProfile CardPM
+Quote Post

kzimmerm

RE: Compiling Stored Procedures In Master Database

9 Jun, 2009 - 08:48 AM
Post #3

D.I.C Head
**

Joined: 8 Feb, 2009
Posts: 67



Thanked: 3 times
My Contributions
QUOTE(jotadeus10 @ 5 Jun, 2009 - 12:48 PM) *

after compiling a common procedure in the master database, it is as system stored procedure and not as a normal store procedure.
not the name of the procedure starts with sp_


example :
use master
go
create proc1 as select GETDATE ()



If you are using MS SQL Server and you want a stored procedure in the Master database starting w/ sp_ then you name it with the sp_ at the beginning of the name. I've created many system wide stored procedures. Also I don't typically name ANY stored procedure that I create with the prefix of sp_.

Kurt
SR. DBA
Tarrytown, NY
User is offlineProfile CardPM
+Quote Post

Fast ReplyReply to this topicStart new topic

Time is now: 11/8/09 03:52AM
Invision Power Board v2.1.7 © 2009  IPS, Inc.
Licensed to: MediaGroup1

Live Help!

Be Social

Dream.In.Code RSS Feed Dream.In.Code LinkedIn Group Follow Us On Twitter Fan Us On Facebook

Tutorials

Programming

Web Development

Reference Sheets

Code Snippets

DIC Chatroom

Bye Bye Ads

Monthly Drawing

Thumb Drive

Top Contributors

Top 10 Kudos This Month