Do you have a guy that you blame for everything that goes wrong? We got one of those a few years back and it has been awesome!
From: [email protected] [mailto:[email protected]] On Behalf Of Schultz, Michael A Sent: Thursday, November 12, 2015 12:34 PM To: [email protected] Subject: RE: [mssms] RE: missing v_R_system Our MS PFE sent me the transact SQL to rebuild the view. Now we have it working, we will try to figure out root cause. Michael Schultz Client Systems Engineering Information Systems Providence Health & Services [email protected]<mailto:[email protected]> From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Nick Sent: Thursday, November 12, 2015 9:52 AM To: [email protected]<mailto:[email protected]> Subject: RE: [mssms] RE: missing v_R_system Take a look at all the views and see if there's one in there that's just not like the others. I've often times found myself in a senariou where I've single-clicked on a view. In one case, I renamed the V_r_system view on accident. [cid:[email protected]] From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Schultz, Michael A Sent: Thursday, November 12, 2015 12:24 PM To: [email protected]<mailto:[email protected]> Subject: [mssms] RE: missing v_R_system They are still on. I think I will try kicking off an AD system scan to see if the view comes back. [cid:[email protected]] Michael Schultz Client Systems Engineering Information Systems Providence Health & Services [email protected]<mailto:[email protected]> From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Jimmy Martin Sent: Thursday, November 12, 2015 9:19 AM To: [email protected]<mailto:[email protected]> Subject: [mssms] RE: missing v_R_system ADDiscovery got turned off? Jimmy Martin (901) 227-8209 From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Schultz, Michael A Sent: Thursday, November 12, 2015 11:17 AM To: [email protected]<mailto:[email protected]> Subject: [mssms] missing v_R_system I have an interesting one. I got a call saying some reports were not working. Looking at the queries, they couldn't find v_R_system. I look at the database and the v_R_system view is gone. Anyone know how to restore or recreate it? Michael Schultz Client Systems Engineering Information Systems Providence Health & Services [email protected]<mailto:[email protected]> ________________________________ This message is intended for the sole use of the addressee, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. This message and any files transmitted with it may contain legally privileged, confidential, or proprietary information. If you are not the intended recipient of this message, you are not permitted to use, copy, or forward it, in whole or in part without the express consent of the sender. Please notify the sender of the error by reply email, disregard the foregoing messages, and delete it immediately. P Please consider the environment before printing this email... ________________________________ This message is intended for the sole use of the addressee, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. ________________________________ This message is intended for the sole use of the addressee, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. This message and any files transmitted with it may contain legally privileged, confidential, or proprietary information. If you are not the intended recipient of this message, you are not permitted to use, copy, or forward it, in whole or in part without the express consent of the sender. Please notify the sender of the error by reply email, disregard the foregoing messages, and delete it immediately. P Please consider the environment before printing this email...
