Ispirer Website
Ispirer Capabilities - Microsoft SQL Server Migration
Free Trial
Permissions
Function permissions needs to be upgraded to has_perms_by_name:
Microsoft SQL Server 2000
permissions ( <expression1>) permissions ( <expression1>, <expression2>)
Microsoft SQL Server 2008
has_perms_by_name ( object_name(<expression1>), 'object', 'any' ) has_perms_by_name ( object_name(<expression1>), 'object', 'any', <expression2>, 'column' )
Examples:
Microsoft SQL Server 2000:
SELECT name FROM sysobjects WHERE permissions(id)=1
Microsoft SQL Server 2008:
SELECT name FROM sys.objects WHERE permissions(object_id)=1
Microsoft SQL Server 2000:
SELECT o.name FROM sysobjects o,syscolumns c WHERE permissions(o.id,c.name)=1
Microsoft SQL Server 2008:
SELECT o.name FROM sys.objects o,sys.columns c WHERE permissions(o.object_id,Isnull(c.name, ''))=1