U

UDAGGs (user-defined aggregates)

overview of, 85–89

serialization of, 88

UDFs (user-defined functions), creating in .NET CLR, 75–77

UDM (unified dimensional model), support in Analysis Services, 219–220

UDT methods, requirements for, 81

UDTs (user-defined triggers), using, 78–80

UDTs (user-defined types)

adding to databases, 84

creating, 80–85

creating columns with, 85

displaying, 84

Unknown dimension members, using with Analysis Services, 221

UNPIVOT and PIVOT relational operators, T-SQL support for, 92–93

UNSAFE permission, using with .NET database objects, 89

URL-based report delivery, implementing with Report Server, 171

URLs

accessing and running Reporting Services reports from, 183–184

accessing Reporting Services reports from, 183

using with SQL Server Service Broker, 136

UserDefinedFunctions class, generating in Visual Studio 2005, 77

UserName system variable, purpose in Integration Services, 196

user-schema separation, relationship to security, 15–17