Norkevicius

Had a headache because of compilation of project which was using System.Data.SqlClient SortOrder data type. After some hours of investigations we found out that Microsoft .NET framework 2.0 SP1 was not installed on the machine. .NET 2.0 contains system.Data.SqlClient namespace but not SortOrder type in it. SP1 adds this data type to the namespace mentioned above.

Check this on microsoft.

Question: How to change sidebar template of the wizard control so that only previous wizard steps would be enabled? (more…)

Script to find not partitioned tables containing some particular column
SELECT o2.NAME FROM sys.objects o

INNER JOIN sys.indexes i ON o.OBJECT_ID=i.OBJECT_ID
INNER JOIN sys.partition_schemes ps ON ps.data_space_id=i.data_space_id
RIGHT OUTER JOIN sys.Objects o2 ON o2.OBJECT_ID=o.OBJECT_ID
INNER JOIN sys.columns c ON c.OBJECT_ID=o2.OBJECT_ID
WHERE o2.TYPE_DESC='USER_TABLE' AND c.NAME='mycolumnname' AND o.OBJECT_ID IS null