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!
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
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.
How to restrict default access on databases
sql query to get bi-weekly data
Unable to configure distribution in replication?
SSRS 2005 Report Model SSRS 2017
SQL Serve 2017 upgrade