Comments
-
Thank you. It's a bit unusual but the query works fine.
-
I got the information from the three tables today, but due to additional changes being made since the original delete I chose not to do a full restore of the tables. I just used the info provided to extract the basic information and then recreate the view for the user. But it still helped me out a great deal. Next time I…
-
I think I found the table you meant. I see that the table "ResourceProperties" has the filters that belongs to the tables. I know what I need to do from here. Thank you very much Stuart.
-
I have edited the original post and attached a screenshot to that.
-
Perfect, thank you d09h.
-
Hi Stuart, That answer was great but I have only two other questions for clarification. 1. Are those the only 3 tables that affect a view? 2. I do not have a "Resource Settings" table, did you happen to type a different name by accident? I do have a plain "Settings" table. I plan on having my SQL team restore my database…
-
I found out that the alert value is CustomTablePollerCurrentStatus.CurrentNumericValue