Isn't that what the Microsoft PFE is for? ----- Dwayne Allen [email protected] (479) 310-0027
On Thu, Nov 12, 2015 at 12:38 PM, Jimmy Martin <[email protected]> wrote: > 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] <[email protected]>* > > > > *From:* [email protected] [ > mailto:[email protected] <[email protected]>] *On > Behalf Of *Nick > *Sent:* Thursday, November 12, 2015 9:52 AM > *To:* [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. > > > > > > > > > > *From:* [email protected] [ > mailto:[email protected] <[email protected]>] *On > Behalf Of *Schultz, Michael A > *Sent:* Thursday, November 12, 2015 12:24 PM > *To:* [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. > > > > > > Michael Schultz > > Client Systems Engineering > > Information Systems > > Providence Health & Services > > *[email protected] <[email protected]>* > > > > *From:* [email protected] [ > mailto:[email protected] <[email protected]>] *On > Behalf Of *Jimmy Martin > *Sent:* Thursday, November 12, 2015 9:19 AM > *To:* [email protected] > *Subject:* [mssms] RE: missing v_R_system > > > > ADDiscovery got turned off? > > > > Jimmy Martin > (901) 227-8209 > > > > *From:* [email protected] [ > mailto:[email protected] <[email protected]>] *On > Behalf Of *Schultz, Michael A > *Sent:* Thursday, November 12, 2015 11:17 AM > *To:* [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] <[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...* > > >
