Browse by Tags

All Tags » tempdb (RSS)

Dropping all temp tables

In SQL Forum one of the posters asked a question about dropping all the temporary tables There are many ways to do this One of the ways to to run the following code declare @sql varchar ( 8000 ) set @sql = '' select @sql = @sql + ' drop table...
Posted by Madhivanan | with no comments
Filed under: , ,

When was my Server restarted?

Temporary database tempdb is created whenever the Server is restarted. So you can know when Server was restarted by knowing the creation date of the tempdb EXEC sp_helpdb tempdb select crdate from master..sysdatabases where name='tempdb'
Posted by Madhivanan | 1 comment(s)
Filed under: ,