By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,419 Members | 1,636 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,419 IT Pros & Developers. It's quick & easy.

sp_helprotect COLUMN has NULL value

P: n/a
Does anyone know what it means when i see some
records returned that have their COLUMN value
as NULL?

I investigated a little to see if they are somehow
related to orphaned users but I don't believe they
are. What else would cause this column to be NULL?

And it seems they are all MSP related. Maybe this is
a Project Server bug?

Here's one sample:

Owner dbo
Object MSP_WEB_FN_SEC_GetAllProjectsResCanViewByViewID
Grantee MSProjectServerRole
Grantor dbo
ProtectType Grant
Action Select
Column NULL
Thank you
May 29 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
serge (se****@nospam.ehmail.com) writes:
Does anyone know what it means when i see some
records returned that have their COLUMN value
as NULL?

I investigated a little to see if they are somehow
related to orphaned users but I don't believe they
are. What else would cause this column to be NULL?

And it seems they are all MSP related. Maybe this is
a Project Server bug?


I don't have Project Server installed.

But if you want to dig further "sp_helptext sp_helprotect" can keep
you busy a little while. :-)
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
May 29 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.