Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2008
    Posts
    15

    Unanswered: can we bind new tempdb to the database

    Hi,

    Can we bind the tempdb to the database.
    If yes please tell me.

    Thanks
    Jayant

  2. #2
    Join Date
    Sep 2003
    Location
    Switzerland
    Posts
    443
    Dont think so. You can only bind it by logins or application.

    Usage:
    sp_tempdb 'help'
    sp_tempdb 'create', <groupname>
    sp_tempdb 'drop', <groupname>
    sp_tempdb 'add', <tempdbname>, <groupname>
    sp_tempdb 'remove', <tempdbname>, <groupname>
    sp_tempdb 'bind', <objtype>, <objname>, <bindtype>, <bindobj>, <scope>,
    <hardness>
    sp_tempdb 'unbind', <objtype>, <objname>, <scope>
    sp_tempdb 'unbindall_db', <tempdbname>
    sp_tempdb 'show', <command>, <name>
    sp_tempdb 'who', <dbname>

    <objtype> = ['LG' ('login_name') | 'AP' ('application_name')];
    <bindtype> =['GR' ('group') | 'DB' ('database')]
    <hardness> = ['hard' | 'soft']
    <command> = ['all' | 'gr' | 'db' | 'login' | 'app']

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •