Mitch Milam's Dynamics CRM and xRM Discussions

If you’ve ever wondered how to find the values for the statecode and statuscode, you can use the following SQL script to find those values:

select 

    AttributeName, 

    AttributeValue,

    Value

from dbo.StringMap 

where

(dbo.StringMap.AttributeName = 'statuscode' 

or

dbo.StringMap.AttributeName = 'statecode')

and 

dbo.StringMap.ObjectTypeCode = 1

Will display the following values for the Account Entity ( ObjectTypeCode = 1 ):