CODEWITHSUNDEEP
sql-serverlinqpadtempdb
B. Clay Shannon-B. Crow Raven
B. Clay Shannon-B. Crow Raven

Reputation: 10297

Why does LinqPad say a database it presents me with is an invalid object name?

Trying to detective out what is in a certain file ("HHS_WCE4.ARMV4.CAB"), I searched my hard drive for any references to that. One of the results Fileseek* was in C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Template Data\tempdb.mdf

[consider this an asterisk] Why, oh why, doesn't Windows 7 come with a file search utility? their previous one, although kind of lame in some ways, was still one of the most useful applets/utilities for daily usage.

I tried to open that database to see what reference it could have to "HHS_WCE4.ARMV4.CAB" but it says it can't see itself in one pane after exposing the same thing on another pane:

enter image description here

Am I doing something wrong? Is there another way to examine the contents of tempdb?

Note: I tried to connect to this first via Add Connection > Build data context automatically > Default (LINQ to SQL) > Next > (localdb)\v11.0 > Attach Database File > Test, but get:

enter image description here

Upvotes: 0

Views: 325

Answers (1)

Dan
Dan

Reputation: 10548

tempdb is not a table, it is a database.

however, you are trying to select from it - you can't treat a database as an object in this case. you have to select from a table.

Upvotes: 1

Related Questions