Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

TempDB Objects and restrictions Expand / Collapse
Posted Tuesday, January 21, 2014 8:16 AM


Group: General Forum Members
Last Login: Tuesday, January 21, 2014 8:11 AM
Points: 103, Visits: 398
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 !!!
Post #1533110
Posted Tuesday, January 21, 2014 8:21 AM



Group: General Forum Members
Last Login: Today @ 4:42 PM
Points: 41,516, Visits: 34,431
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 2008, MVP
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

Post #1533115
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse