I've some developers who want to be able to select from some system tables. I'm reluctant to give this in case we get any locking issues. As an alternative I'm thinking of creating views with nolock hints, and granting them access to this. e.g.
CREATE VIEW vw_sysjobs
select * FROM sysjobs WITH(NOLOCK)
Is there a better way of doing this ? Am I right to asume that locking would be a potential problem on these tables ?
(SQL Server 2005)
View Complete Post