The View doesn't return any record but when i run the table that the view is dependent on, i get the records. any suggestions what i have been missing here? Thanks!
asked
View doesn't return any record
it's a simple select statement. from another Database on the same instance. the table retrieves the data. am not sure if i answered your questions correctly.
Nothing is simple when crossing databases.
Cross database ownership chaining is a royal pain.
Who owns the schema where the view lives?
Who owns the schema where the table lives?
Who owns the database where the view lives?
Who owns the database where the table lives?
What permissions do the person who’s selecting from the view have?
16 People are following this question.
