Re: question about tempdb
From: joe (pearl_77_at_hotmail.com)
Date: 07/13/04
- Next message: Adam Machanic: "Re: Searching in a field for the actual character %"
- Previous message: Willie Bodger: "Re: Changing object owner to dbo"
- In reply to: Tom Moreau: "Re: question about tempdb"
- Next in thread: Eric Sabine: "Re: question about tempdb"
- Reply: Eric Sabine: "Re: question about tempdb"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 13 Jul 2004 14:37:19 -0400
well.. that doesnt work.
use tempdb
go
create table joe(id int)
"Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message
news:%23InCXCQaEHA.1840@TK2MSFTNGP11.phx.gbl...
> That's right. Those two statements aren't necessary.
>
> --
> Tom
>
> ----------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
> .
> "joe" <pearl_77@hotmail.com> wrote in message
> news:uW7n89PaEHA.1644@tk2msftngp13.phx.gbl...
> Hi everyone, is it true that everyone who has access to a sqlserver will
> have full right to tempdb?
>
> if this is true, then following steps are not neccessary. please give
your
> commands. thanks
>
> exec tempdb..sp_grantdbaccess 'joe'
> exec tempdb..sp_addrolemember 'db_owner','joe'
>
>
>
- Next message: Adam Machanic: "Re: Searching in a field for the actual character %"
- Previous message: Willie Bodger: "Re: Changing object owner to dbo"
- In reply to: Tom Moreau: "Re: question about tempdb"
- Next in thread: Eric Sabine: "Re: question about tempdb"
- Reply: Eric Sabine: "Re: question about tempdb"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
