Post reply

TempDB Objects and restrictions

  • January 21, 2014 at 8:16 am

    #396137

    Hi All,

    Can you please tell about Temp DB on below points.

    What are the typical objects that are created in the TempDB database?

    Is it possible to restrict user from creating objects in TempDB?

    Is it possible to create procedures in TempDB?

    What do you mean by Table Sample?

    Any relation between TEMPDB & Table sample?

    Thanks !!!

  • January 21, 2014 at 8:21 am

    #1681949

    1) Temp tables

    2) Temp tables, no, all users have permission to create those

    3) Yes, kinda pointless though

    4) See Books Online (the SQL help file), the page on the FROM clause

    5) No.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply