SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

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…

Read more

1 comments, 796 reads

Posted in Don Halloran on 15 June 2011

Getting Backup File Information from a Table Valued UDF - SQLCLR to the Rescue?


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…

Read more

0 comments, 1,204 reads

Posted in Don Halloran on 15 June 2011