• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 212
  • Last Modified:

How can you view a # table in SQL Server 2005?

How can you view a # table in SQL Server 2005?
0
fsuedu
Asked:
fsuedu
1 Solution
 
SireesCommented:
You can view using Microsoft SQL Server Mangement studio.

Do you have SQL Server 2005 client tools installed?
0
 
dqmqCommented:
Or just
Select * from #tablename

But it can only be viewed by the user and session that created it!  Use ##table for a temp table that can be viewed by someone else.
0
 
fsueduAuthor Commented:
Thanks where would I see SQL Server 2005 client tools installed?


JK
0
 
eozz_2000Commented:
dgmg is fully right, you can only view the # temp tables when you don't close the connection that create it, with ## temp tables any user could see and change it
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now