Dosql

select * from INFORMATION_SCHEMA.TABLES Where Table_name = ‘__RefactorLog’
TABLE_CATALOG TABLE_SCHEMA TABLE_NAME TABLE_TYPE
SFSNEXT dbo __RefactorLog BASE TABLE

select * from __RefactorLog;
OperationKey
5FA4FFA8-6057-4AB0-9DF2-03D428415B10
924A1134-36F6-4120-B6A4-051728CE97DA
…

Environment is SQL Server 2008 R2. Database is managed through Visual Studio 2010. This table shows up on SSMS as a system table, but shouldn’t it be hidden from Information_schema view?

C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\v10.0\TeamData\Microsoft.Data.Schema.TSqlTasks.targets(56,5): error MSB4062: The “SqlBuildTask” task could not be loaded from the assembly Microsoft.Data.Schema.Tasks.Sql, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a. Could not load file or assembly ‘Microsoft.Data.Schema.Tasks.Sql, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a’ or one of its dependencies. The system cannot find the file specified. Confirm that the declaration is correct, and that the assembly and all its dependencies are available.

It appears that if I switch to target .Net Framework 4.0 on MSBuild, the error goes away.

I read an article that talked about some rather interesting queries in SQL Server.

Have you ever wondered what this will return:
select \
——————-
(No column name)
0.00

Apparently there are two odbcad32.exe:

C:\Windows\SysWOW64\odbcad32.exe
C:\Windows\System32\odbcad32.exe

Depends on where you start the utility, you may or may not see 32 bit drivers. The one in C:\Windows\SysWOW64 looks like the correct one if you want to edit 32 bit driver based DSNs.

Released on June 18 2010. 

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=0fd439d7-4bff-4df7-a52f-9a1be8725591