[dbo].[usm_vw_link_subscription

[dbo].[usm_vw_link_subscription_asset]

(local) > mdb > Views > dbo.usm_vw_link_subscription_asset

Properties
Columns
Permissions
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	11:19:34 AM Monday, December 13, 2010
Last Modified	11:19:34 AM Monday, December 13, 2010

Columns

Name
request_id
request_item_id
asset_uuid_char
asset_uuid

Permissions

Type	Action	Owning Principal
Grant	Select	usmgroup

SQL Script

create view usm_vw_link_subscription_asset as
select request_id,request_item_id,
    sys.fn_varbintohexsubstring(1,usm_link_subscription_asset.asset_uuid,1,0) as asset_uuid_char,
    asset_uuid
from usm_link_subscription_asset
GO
GRANT SELECT ON  [dbo].[usm_vw_link_subscription_asset] TO [usmgroup]
GO

Uses

[dbo].[usm_link_subscription_asset]
dbo
[sys].[fn_varbintohexsubstring]