Tempdb

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Noorali Issani (naissani_at_softhome.net)
Date: 03/05/04 

Date: Fri, 5 Mar 2004 14:47:17 +0500

Dear Professional

I want to do one activity but not sure either it is possible or not.. I want
that when tempdb database will be created so it auto create one user which
name tempdbuser which has a owner rights of tempdb but only dbo rights of
tempdb database.

The problem is that I don't wanna use sa password in the application so when
application run it use AspState (for .Net Application) database and it point
to tempdb database for maintaining the session and If I created the login
for tempdb so it deletes that user when sql service stop and when the
service start, that user has been vanished from the sql server tempdb
database and gave an error...

Can any body tell me what I have to do ?

Waiting for your reply

Noor

Relevant Pages

  • Re: use of tempdb by union all
    ... > You are certainly correct about table variables using the tempdb database, ... Andrew J. Kelly SQL MVP "Tenaya" wrote in message ... > You are certainly correct about table variables using the tempdb database,> and not being entirely memory resident ... ...
    (microsoft.public.sqlserver.programming)
  • Re: Error Granting DB / Role Access
    ... the database or object owner (within tempdb) even though they have DBO ... The script below executes correctly. ... >> Now the owner of the tempdb database is SA, and the dbo login is mapped to ...
    (microsoft.public.sqlserver.security)
  • Re: use of tempdb by union all
    ... You are certainly correct about table variables using the tempdb database, ... and not being entirely memory resident ... ... are you stating the SQL Server will use the ...
    (microsoft.public.sqlserver.programming)
  • Re: TempDB
    ... TEMPDB holds all temporary tables and temporary stored procedures. ... Allow the tempdb database to automatically expand as needed. ...
    (microsoft.public.sqlserver.server)
  • Re: SORT_IN_TEMPDB not use tempdb???
    ... Andrew J. Kelly SQL MVP ... > Does SQL Server test if the tempdb database is on the same hard drive as ... >> Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.server)