select * from sys.tables where principal_id is null
SET ANSI_NULLS OFFselect * from sys.tables where principal_id = null SET ANSI_NULLS ON
Mark This Response as Answer -- Chandu http://www.dotnetfunda.com/images/dnfmvp.gif
select * from sys.tables where ISNULL(principal_id, -1) = -1 -- here principal_id -1 should not match any of other values in table
Mark as Answer if its helpful to you --- Srihari
Login to post response