use tempdb sp_tables '##%'

How to Check Whether a Global Temporary Exists in a SQL
Database or not?

Question Posted / ish

Answer Posted / ish

use tempdb

sp_tables '##%'

Is This Answer Correct ?

3 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are the new security features added in sql server 2012? : sql server security

948

What are page splits? : SQL Server Architecture

935

If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?

1040

What happens on checkpoint?

967

What is the use of @@spid?

957

What is data block and how to define data block size?

977

what are the important architecture components of SSRS?

124

what are the types of indexes? : Sql server database administration

1060

What is indexing in sql server with example?

925

how to determine the service pack currently installed on sql server? : Sql server database administration

907

Explain what stored procedure sp_replcounters is used for? : sql server replication

1453

What is meant by dirty read?

950

Explain the flow of creating a cube? : sql server analysis services, ssas

1003

What are the High-Availability solutions in SQL Server and differentiate them briefly?

1087

What is collation sensitivity?

985