Re: master database
From: Peter The Spate (anonymous_at_discussions.microsoft.com)
Date: 09/27/04
- Next message: Steen Persson: "Re: Connect to enterprise manager"
- Previous message: Kalyan: "SQL Server 7 and Service pack"
- Maybe in reply to: m.posseth: "master database"
- Next in thread: Tibor Karaszi: "Re: master database"
- Reply: Tibor Karaszi: "Re: master database"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 27 Sep 2004 06:16:33 -0700
"Oh and of course there's a number of times I've run a
script to create stored procs only to realize I was in the
wrong DB.... like master. :-)"
Been there, done that, had the frantic fear filled 20
minutes clearing it up before someone finds out....
Peter
>-----Original Message-----
>
>"Wayne Snyder" <wayne.nospam.snyder@mariner-usa.com>
wrote in message
>news:%238DrO4IpEHA.1272@TK2MSFTNGP09.phx.gbl...
>> I agree, talk to the DBA... I think in Oracle it is not
a big deal, but in
>> SQL it is... Without a working master, your server is
down. By placing
>> anything in master you are openining yourself up to
database full and
>other
>> issues which could hurt...
>>
>> One thing that some people do is to create addition
Special, system
>> procedures in master - that is a normal and accepted
practice... But do
>not
>> place data there..
>>
>
>Well, normal, perhaps. Accepted is debatable. You never
know when MS is
>going to come along and change the rules.
>
>Having said that, I've done it. sp_tablespaceused_u is
one that I use a lot
>for example and having it in the master db is a big help.
>
>(This shows me how much each table within a DB is using.
Needs some work,
>but works for me.)
>
>I tend to add the _u at the end so I know it's user
created so that MS is
>less likely to come along with their OWN stored proc and
screw me up. :-)
>
>Oh and of course there's a number of times I've run a
script to create
>stored procs only to realize I was in the wrong DB....
like master. :-)
>
>
>> --
>> Wayne Snyder, MCDBA, SQL Server MVP
>> Mariner, Charlotte, NC
>> www.mariner-usa.com
>> (Please respond only to the newsgroups.)
>>
>> I support the Professional Association of SQL Server
(PASS) and it's
>> community of SQL Server professionals.
>> www.sqlpass.org
>>
>
>
>.
>
- Next message: Steen Persson: "Re: Connect to enterprise manager"
- Previous message: Kalyan: "SQL Server 7 and Service pack"
- Maybe in reply to: m.posseth: "master database"
- Next in thread: Tibor Karaszi: "Re: master database"
- Reply: Tibor Karaszi: "Re: master database"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
