Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Manage Extended Property Expand / Collapse
Author
Message
Posted Saturday, October 13, 2007 6:43 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, October 15, 2012 3:48 AM
Points: 24, Visits: 2
Comments posted to this topic are about the item Manage Extended Property


Post #410294
Posted Tuesday, January 26, 2016 3:41 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, January 26, 2016 3:36 AM
Points: 1, Visits: 28
Hi I just tried this usefull function unter SQL 2014.

In order to maked it run again i needed to replace

permissions(id)

with

(SELECT COUNT(*) FROM fn_my_permissions(id, 'DATABASE'))

because permissions is marked as "will be removed in future versions"

[url=https://msdn.microsoft.com/query/dev10.query?appId=Dev10IDEF1&l=EN-US&k=k(PERMISSIONS_TSQL);k(SQL12.SWB.TSQLRESULTS.F1);k(SQL12.SWB.TSQLQUERY.F1);k(MISCELLANEOUSFILESPROJECT);k(DevLang-TSQL)&rd=true][/url]

But now script works great again.


Thank You very much for Your work.
Post #1755660
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse