Subscribe to this blog
Don Halloran
SQL Server, SSIS, SSAS and maybe even SSRS rants and raves (and, on occasion, useful code or designs).
Archives: June 2011
Things That Should Be In TSQL
Relation Types
[PREF] create type type_T(i int primary key clustered, j int check (j > 0)) -- relation type. Includes constraints! create table T(type_T) [ENDPREF]Relvar Assignment
This follows from relation types: [PREF] create table T(type_T) create table U(type_T) = T declare @V table(type_T) = U [ENDPREF] Strong typing could…1 comments, 251 reads
Posted in Don Halloran on 15 June 2011
Getting Backup File Information from a Table Valued UDF - SQLCLR to the Rescue?
Update:
After all of this SMO stuff failed (changing the permission set to unsafe got around the security exception, but instead I got an error about functionality being disabled in the SQLCLR) I gave up and turned back to the idea of opening a connection and using the engine to…0 comments, 498 reads
Posted in Don Halloran on 15 June 2011