Is there a way to identify shared accounts using SQL

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Crm
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - ReAssign an account shares the account with the existing and new o I have noticed that when an account is reassigned from one owner to another, it establishes a share between each of these parties. Is there a way of turning this option off. Thanks Kim Cannon Tag: Is there a way to identify shared accounts using SQL Tag: 31950
  - 2
    - Unit Problem: diffirent basic unit to a product One product has only one Unit Group, and one UnitGroup has only one basic Unit. Then One product has only one basic Unit. But our business is special. We sell software and provide trainings. For selling, we can use "license" as basic Unit. But we need another basic Unit: Hour. Is there any solution in Ms CRM? Thanks a lot. Tag: Is there a way to identify shared accounts using SQL Tag: 31949
  - 3
    - Some CRM interface features are broken I have just noticed that some of the navigation interface is broken in my installation of CRM. Specifically, the Home, Workplace, Sales and Reports buttons at the bottom don't work (a scripting error occurs). Scripting Debugger gives the following error: Line: 69 Char: 4 Error: Permission Denied Code: 0 URL: http://crm/bar_bottom.aspx?startPage=Home Navigation using the GoTo menu works fine. Any ideas? Tag: Is there a way to identify shared accounts using SQL Tag: 31946
  - 4
    - Anyone tried customizing activity views by editing the SavedQueryBase records? Would editing the SavedQueryBase records directly allow me to add otherwise unavailable columns to the various activities views? I am trying to show the phone number (location) but this column is not available using the workarounds posted for editing the activity views using the CRM GUI. Anyone tried this yet? I am not looking for an officially supported solution - just a functional workaround. Tag: Is there a way to identify shared accounts using SQL Tag: 31945
  - 5
    - Attachments & Notes/History in ACT 2000 In ACT 2000, emails are just attached .det files. How are these emails migrated over to MS CRM. It seems that Saleslogix has a hard time importing attachments from ACT. I was wondering if MS CRM is the same way. I will pretty much need to retain all the Notes/History wheter it's a Note, Email, or Attachment. Thanks in advance. Tag: Is there a way to identify shared accounts using SQL Tag: 31929
  - 6
    - System.DivideByZeroException i've just installed Microsoft CRM 1.2 on a server who work with a second sbs 2003 server... All woks, but i have one problem, when i want to send an email i have an System.DivideByZeroException... Someone know how to correct this exception ? thanks alex Tag: Is there a way to identify shared accounts using SQL Tag: 31925
  - 7
    - Test and Production Install on same server We are looking to install Microsoft CRM on our server. We would like to be able to install the demo database for testing and training purposes and then when ready install our live database. MBS Tech support is telling us that we can use the same SQL Server for the 2 databases but that you can't have the 2 Microsot CRM Server installs on the same server. Has anyone out their found any type of work-around that makes this doable? It is simply not practical for us to add another server to our network simply to install the sample database for Microsoft CRM. How have others dealt with this issue? Any feedback is appreciated. Tag: Is there a way to identify shared accounts using SQL Tag: 31923
  - 8
    - How to relate an Activity to a group of contacts? Is there a way to easily attach an Activity to multiple Contacts. For example, how can I attach the same Task to all the Contacts in New York? Selecting contact by contact is much to time consuming Tag: Is there a way to identify shared accounts using SQL Tag: 31922
  - 9
    - DST Import into CRM- Test batch count equals 0 We are trying to import out ACT! data into MSCRM using the cdf databases, and have been going along without problems until we get to the test integration- the p_cdf_SetTestBatchCount appears to work fine, but when we go to the cdf_EntityMigrationInfo, the TestBatchCount still reads <null> not the value we set. Any suggestions? Thanks in advance. Tag: Is there a way to identify shared accounts using SQL Tag: 31921
  - 10
    - MSDE Installation Fails with SFO Trying to install SFO (Version 1.2) and it fails when attempting to install MSDE. I get the follow error: "Set has failed because of an error. Setup was unable to install Microsoft SQL Server 2000 Desktop Engine (sp3a). Install it seperatly and restart setup.exe." I am running Windows XP SP2. I have tried disabling the windows firewall but still fails. The CRM server is up and running and I can access it via the http://<crm server name>. Thanks REG Tag: Is there a way to identify shared accounts using SQL Tag: 31912
  - 11
    - error on page I sometimes have the error message "error on page" below in the main ms crm window, when I switch from Sales to Workplace , or from Workplace to Home. Is this a known problem, and is there a solution for this. I do not have it always, and clicking on F5 resolves it.. untill it is back. Any idea ? Wim Tag: Is there a way to identify shared accounts using SQL Tag: 31900
  - 12
    - rename Order to Contract Is there an easy way to rename objects in ms crm ? or is the only way the rename of field-labels and views ? Example: rename account to company , etc.. Regards, Wim Tag: Is there a way to identify shared accounts using SQL Tag: 31899
  - 13
    - CRM 1.2 Massmail Problems with the Subject Line of Microsoft CRM E Can somebody send me an link to the Tech Article? Thanks Alwin Tag: Is there a way to identify shared accounts using SQL Tag: 31898
  - 14
    - hide or show fields in ms crm based on criteria Is there a way to show or hide certain fields or zones based on for example the relationship type on an account screen ? Regards Wim Tag: Is there a way to identify shared accounts using SQL Tag: 31897
  - 15
    - Email Workflow rule. I created an email workflow rule that is applied when someone updates information on an Order. The rule reassigns the order to another individual and emails the new owner. I am wondering how to also CC the Account owner, owner of the originating account (Not Order owner). Thanks in Advance. Tag: Is there a way to identify shared accounts using SQL Tag: 31896
  - 16
    - Private Activity Hi, is it possible to "make private" (for the owner) an activity ? I.e. that others users can't read it even if they can read/modify the object for which that activity has been created ? Thanks for help, regards. Dominique Szczudlak Tag: Is there a way to identify shared accounts using SQL Tag: 31893
  - 17
    - Role / Privilege doubt Hi, can somebody reply to telling me if it's a wellknow issue/bug or a "local config problem" : On my system, I can see ALL contacts created by a user assigned to a BU "father" even if I have set my privileges to don't see it (I hope !) ? Thanks for your help, regards. Dominique Szczudlak Tag: Is there a way to identify shared accounts using SQL Tag: 31892
  - 18
    - MS CRM 1.2 Sales for Outlook Hi, is it possible to install/use CRM 1.2 Sales for Outlook on a laptop without entry of this laptop in any domain? Thanks achim Tag: Is there a way to identify shared accounts using SQL Tag: 31891
  - 19
    - Customize Activities Can I make any changes to the various Activity forms? A user want to change the Category and Sub-Category to drop-down lists. Is this possible? Thanks, Paul Tag: Is there a way to identify shared accounts using SQL Tag: 31889
  - 20
    - KDC error followed by You are not authorized to view this page My CRM server was reporting KDC errors. I followed the KB article http://support.microsoft.com/?id=215383 to stop the errors. Now I can not get to the CRM web site at all, I am getting "You are not authorized to view this page" when I hit the CRM web page. I can live with the KDC errors so how do I roll back the change I made in KB article 215383? Thanks! Duane N. Tag: Is there a way to identify shared accounts using SQL Tag: 31887
  - 21
    - how to generate a tracefile for one user (log field changes) How can I get a logfile or report on all things that a specific user has done in MS CRM ? Is this possible ? and if so, How ? Regards Wim Tag: Is there a way to identify shared accounts using SQL Tag: 31886
  - 22
    - Salesforce Automation Error When converting a quote to an order some of our sales people are receiving the following error: SalesForce Automation Error. The order is still created, but it does not open, the error appears instead. This is leading to duplicate orders. Has anyone seen this before? Any info. would help. Tag: Is there a way to identify shared accounts using SQL Tag: 31884
  - 23
    - Mail Merge Issue When I perform a mail merge, CMR automatically attaches an activity to each affected account, with a subject line of "Mail Merge Letter." My users want to attach the actual letter to this activity, and rename it to something more meaningful. Unfortunately, when it is created, it is also (inexplicably) closed. Is there any way to tell CRM to leave this activity open? Thanks! Tag: Is there a way to identify shared accounts using SQL Tag: 31882
  - 24
    - C# -- E-mail and back-ground color -- C# Hello, I've some problem with email template in CRM: why I don't make the background color of my e-mail template black?. I can make the fonts blue, yellows, etc. but I don't make the back-ground red o black. I try to put in crm the html, but the crm cut-off the header of the html. The e-mail template function but the color go away. Why? I send a piece of my code, I hope somebody help me! BizUser bizUser = new BizUser(); bizUser.Credentials = CredentialCache.DefaultCredentials; bizUser.Url = String.Concat(crmUrl, "BizUser.srf"); CRMCustomerAddress crmCustomerAddress = new CRMCustomerAddress(); crmCustomerAddress.Credentials = bizUser.Credentials; crmCustomerAddress.Url = String.Concat(crmUrl, "CRMCustomerAddress.srf"); CRMEmailTemplate emailtemplate = new CRMEmailTemplate(); emailtemplate.Credentials = CredentialCache.DefaultCredentials; emailtemplate.Url = String.Concat(crmUrl, "CRMEmailTemplate.srf"); CUserAuth crmUserAuth = null; try { crmUserAuth = bizUser.WhoAmI(); } catch (Exception e) { log.Write(e); log.Close(); Environment.Exit(1); } string strErrorMsg; try { // Set up the XML string for the e-mail template string strXmlTemplate = "<template>"; strXmlTemplate += "<presentationxml><![CDATA[<template><html><![CDATA[<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.0 Transitional//EN\"> <HTML><HEAD> <META http-equiv=Content-Type content=\"text/html; charset=iso-8859-1\"> <META content=\"MSHTML 6.00.2900.2523\" name=GENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=#000000> <DIV><FONT face=Arial color=#ffffff size=2>Prova di e-mail con sfondo nero </FONT></DIV></BODY></HTML>]]]]><![CDATA[></html></template>]]></presentationxml>"; strXmlTemplate += "<subject>A Template Subject Stefano</subject>"; strXmlTemplate += "<templatetypecode>1</templatetypecode>"; strXmlTemplate += "<body><![CDATA[<?xml version=\"1.0\" ?><xsl:stylesheet xmlns:xsl=\"http://www.w3.org/1999/XSL/Transform\" version=\"1.0\"><xsl:output method=\"text\" indent=\"no\"/><xsl:template match=\"/data\"><![CDATA[<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.0 Transitional//EN\"> <HTML><HEAD> <META http-equiv=Content-Type content=\"text/html; charset=iso-8859-1\"> <META content=\"MSHTML 6.00.2900.2523\" name=GENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=#000000> <DIV><FONT face=Arial color=#ffffff size=2>Prova di e-mail con sfondo nero </FONT></DIV></BODY></HTML>]]]]><![CDATA[></xsl:template></xsl:stylesheet>]]></body>"; strXmlTemplate += "<title>Prova di Email con immagine</title>"; strXmlTemplate += "<mimetype>text/html</mimetype>"; strXmlTemplate += "<ownerid type=\"" + Microsoft.Crm.Platform.Types.ObjectType.otSystemUser.ToString() +"\">"; strXmlTemplate += crmUserAuth.UserId + "</ownerid>"; strXmlTemplate += "</template>"; string strEmailTemplateId = emailtemplate.Create(crmUserAuth, strXmlTemplate); } catch (System.Web.Services.Protocols.SoapException err){ // Process the platform error here strErrorMsg = ("ErrorMessage: " + err.Message + " " + err.Detail.OuterXml + " Source: " + err.Source ); log.Write(strErrorMsg); log.Close(); Environment.Exit(1); } catch (Exception err) { // Process other errors here strErrorMsg = ("ErrorMessage: " + err.Message ); log.Write(strErrorMsg); log.Close(); Environment.Exit(1); } Tag: Is there a way to identify shared accounts using SQL Tag: 31881
  - 25
    - SFO causes High CPU utilization on SQL server This recently started happening, and I am not sure why. I loaded SFO on two new laptops and attempted to go offline with each. The SQL Server is also the same server running CRM 1.2. When the synch starts on the client the SQL/CRM server instantly spikes to 100% and stays that way as the SFO client never finishes the synch process. Any ideas on a setting that might need to be changed or a patch, etc? Regards, Sean Tag: Is there a way to identify shared accounts using SQL Tag: 31878
- Next
  - 1
    - Manager grayed out on user setup After adding a user, I want to change the manager (which is blank at the moment) but the manager field is grayed out, as a result, I can't change this field. Any suggestions? Tag: Is there a way to identify shared accounts using SQL Tag: 31875
  - 2
    - Emails in HELP DESK enviroment The clients in this case are people working inside the same organization (using the same exchange) and when they opened a case the main comunication between Help desk and them is by email. But those emails are arriving to OUTLOOK and NOT to the CRM!! How can we change that?? We want to relate those emails to the correct case. The actual process is: 1. The request arrive by email to Outlook. Help Desk open a case and attach the email to it. 2. Help Desk send an email (from CRM) to the user with indications... 3. The user responde and send other email... (we are loosing this email in the CRM platform) Any help?? or Ideas??? Tag: Is there a way to identify shared accounts using SQL Tag: 31873
  - 3
    - Modifying Domain Logon name I added a user, but forgot to include the domain name infront of the user name. While CRM told me (after save & close) that the domain name must be entered, it still allowed the user to be created. Now I want to go back to the user and edit the domain logon name field in the user profile, but it is grayed out and will not let me change it. Any suggestions? Regards, Tag: Is there a way to identify shared accounts using SQL Tag: 31872
  - 4
    - Rule for sending e-mail, Opportunity? Hi I would like to create a rule that checks if estimatedclosedate is after actual date (for open opportunities). If so I would like to send an e-mail (from a template) to the owner of the opportunity. Does anyone have som tips about how to do that. I have tried to create a rule in workflow manager, but I cannot find the fields above to include in the rule. Regards Thomas, Mandator AB Tag: Is there a way to identify shared accounts using SQL Tag: 31871
  - 5
    - Licences mixing Hi All! If i need 3 sales personnel and 5 customer service personnel and 2 manager to see everything. Then i need to buy: 3 sales licences 5 CS licences 2 Suite license OR just 10 Suite licences? Thanx for advance Tag: Is there a way to identify shared accounts using SQL Tag: 31866
  - 6
    - Case Resolution Type In the service module, when I resolve a case, there is a Resolution Type drop-down in the Resolve Case dialog box. Currently, the only Resolution Type available is Problem Solved. How do I add resolution types to this drop-down list? I do not see any way to access (and modify) this dialog in the customiozation module. Thanks in advance, Paul McBride Tag: Is there a way to identify shared accounts using SQL Tag: 31863
  - 7
    - Quote for Customer Report Problem I create a printable quote form using Crystal Reports base don Michael Yourshaw's method (send GUID to aspx page and redirect to the report). But I have a problem. When I press the 'open quote in Crystal' button on the quote form, I have to enter my username and password again to be able to see the report. How can I solve this? Thx! Tag: Is there a way to identify shared accounts using SQL Tag: 31862
  - 8
    - Access to CRM reports not via CRM Hi All! Is there any way to see CRM reports without using CRM interface? It's useful in case when you need just to see reports without buying licences for CRM. For example, some boss does not work with CRM modules Sales or Customer Service and just wants to see reports related to it. It's not a good idea to buy Suite Licence only for viewing reports. May be some other type of licences? Crystal Report? Thanx for advance. Tag: Is there a way to identify shared accounts using SQL Tag: 31861
  - 9
    - Creating an account with special characters, like & in the name Hi I'm using CRM 1.2 SDK and trying to import my data to CRM. Some of my accounts contain & in the name (of cource :-) ) But I fail in my Account.Create ... My code works fine with regular names, and I also managed to query whether an account like that exists (using like %...). Anyone knows how to do that? I tried "<account><name>A && B</name><ownerid type=\"8\">{6E8835EF-61E2-4E11-8DAB-D5A13C3E0A34}</ownerid></account>" and also "<account><name>A \& B</name><ownerid type=\"8\">{6E8835EF-61E2-4E11-8DAB-D5A13C3E0A34}</ownerid></account>" and also "<account><name>A '&' B</name><ownerid type=\"8\">{6E8835EF-61E2-4E11-8DAB-D5A13C3E0A34}</ownerid></account>" Any more ideas? Thanks in advance Rakefet Tag: Is there a way to identify shared accounts using SQL Tag: 31860
  - 10
    - error trying open CRM's object in "Sales for Outlook" v. 1.2 Hi! I have installed "Sales for Outlook" v 1.2 in XP (without XP SP2!) Installation was succesfully, but when i try to open every object into Outlook about CRM (for example home, account, etc.) appear this error Exception from HRESULT: 0x80044104. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Runtime.InteropServices.COMException: Exception from HRESULT: 0x80044104. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [COMException (0x80044104): Exception from HRESULT: 0x80044104.] Microsoft.Crm.Platform.ComProxy.CBizUserClass.WhoAmI() +0 Microsoft.Crm.Security.UserCache.GetCurrentUser(Cache cache, String username) +224 Microsoft.Crm.Security.UserCache.GetCurrentUser(Page page) +72 Microsoft.Crm.Application.Controls.AppPage.OnLoad(EventArgs e) +101 System.Web.UI.Control.LoadRecursive() +27 System.Web.UI.Page.ProcessRequestMain() +731 any idea about this? Thanks! Max Tag: Is there a way to identify shared accounts using SQL Tag: 31859
  - 11
    - Accounts, Cases, Teams + Sharing Issue All, I've noticed that If I share an Account (Account A) with a Team (Team A) then any Cases (Case A) where 'Account A' is the Customer of 'Case A 'are automatically shared with 'Team A' and cannot be unshared. This means that once an Account is shared, no 'User Level' or confidential Cases can be created for that Account, as they are always shared with 'Team A'. Is this the correct functionality, seems bizarre! kind regards. Les Tag: Is there a way to identify shared accounts using SQL Tag: 31857
  - 12
    - CRM and SQL reports - install error Have installed the SQL Reporting for CRM, and during the install I get an error "Object error is not set to an instance of an object" Any one know what this may be. thanks Kim Cannon Tag: Is there a way to identify shared accounts using SQL Tag: 31848
  - 13
    - MSCRM Application Error Report Hi, I cannot connect to my CRM servers after using it for 3 weeks. Below is the error from the event viewer: MSCRM Application Error Report -------------------------------------------------------------------------------------------------------- Error Message: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Source File: Line Number: Stack Trace Info: at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain() at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequest(HttpContext context) at System.Web.CallHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) ============================================= I have tried to looking for a solution in the MS knowledge based without any avail. Greatly appreciated if someone will be able to solve this problem. As my users are pressing me now. Thanks, Boon Tag: Is there a way to identify shared accounts using SQL Tag: 31846
  - 14
    - Why does the procedure present the mistake? hi: Why does the procedure present the mistake? ErrorMessage: The request failed with HTTP status 405: Method not allowed. progedure code: function:CRMAccount.CreateAndRetrieve string strServer = "computer"; // virtualDirectory should be set with the name of the Microsoft CRM // virtual directory on the platform Web server string virtualDirectory = "computer"; string strDir = "http://" + strServer + "/" + virtualDirectory + "/"; // BizUser proxy object Microsoft.CRM.Proxy.BizUser bizUser = new Microsoft.CRM.Proxy.BizUser (); bizUser.Credentials = System.Net.CredentialCache.DefaultCredentials; bizUser.Url = strDir + "BizUser.srf"; // CRMAccount proxy object Microsoft.CRM.Proxy.CRMAccount account = new Microsoft.CRM.Proxy.CRMAccount (); account.Credentials = System.Net.CredentialCache.DefaultCredentials; account.Url = strDir + "CRMAccount.srf"; string strErrorMsg; try { Microsoft.CRM.Proxy.CUserAuth userAuth = bizUser.WhoAmI(); // Set up the XML string for the account string strAccountXml = "<account>"; strAccountXml += "<name>Account Number 2</name>"; strAccountXml += "<accountnumber>A0193</accountnumber>"; strAccountXml += "<websiteurl>www.adventure-works.com</websiteurl>"; strAccountXml += "<ownerid type=\"" + Microsoft.CRM.Flags.ObjectType.otSystemUser.ToString() +"\">"; strAccountXml += userAuth.UserId + "</ownerid>"; strAccountXml += "</account>"; // string strAccountXml = "<account>"; // strAccountXml += "<name>Account Number 1</name>"; // strAccountXml += "<accountnumber>A0192</accountnumber>"; // strAccountXml += "<websiteurl>www.adventure-works.com</websiteurl>"; // strAccountXml += "<ownerid type=\"" + Microsoft.CRM.Flags.ObjectType.otSystemUser.ToString() +"\">"; // strAccountXml += userAuth.UserId + "</ownerid>"; // strAccountXml += "</account>"; string strNewAccountXml = account.CreateAndRetrieve(userAuth, strAccountXml); // this.TextBox1.Text = strNewAccountXml; } catch (System.Web.Services.Protocols.SoapException err) { // Process the platform error here strErrorMsg = ("ErrorMessage: " + err.Message + " " + err.Detail.OuterXml + " Source: " + err.Source ); this.TextBox1.Text = strErrorMsg; } catch (Exception err) { // Process other errors here strErrorMsg = ("ErrorMessage: " + err.Message ); this.TextBox1.Text = strErrorMsg; } Tag: Is there a way to identify shared accounts using SQL Tag: 31845
  - 15
    - ErrorMessage: The request failed with HTTP status 405: Method not hi: Why does the procedure present the mistake? ErrorMessage: The request failed with HTTP status 405: Method not allo procedure Code: procedure function:CRMAccount.CreateAndRetrieve string strServer = "computer"; // virtualDirectory should be set with the name of the Microsoft CRM // virtual directory on the platform Web server string virtualDirectory = "computer"; string strDir = "http://" + strServer + "/" + virtualDirectory + "/"; // BizUser proxy object Microsoft.CRM.Proxy.BizUser bizUser = new Microsoft.CRM.Proxy.BizUser (); bizUser.Credentials = System.Net.CredentialCache.DefaultCredentials; bizUser.Url = strDir + "BizUser.srf"; // CRMAccount proxy object Microsoft.CRM.Proxy.CRMAccount account = new Microsoft.CRM.Proxy.CRMAccount (); account.Credentials = System.Net.CredentialCache.DefaultCredentials; account.Url = strDir + "CRMAccount.srf"; string strErrorMsg; try { Microsoft.CRM.Proxy.CUserAuth userAuth = bizUser.WhoAmI(); // Set up the XML string for the account string strAccountXml = "<account>"; strAccountXml += "<name>Account Number 2</name>"; strAccountXml += "<accountnumber>A0193</accountnumber>"; strAccountXml += "<websiteurl>www.adventure-works.com</websiteurl>"; strAccountXml += "<ownerid type=\"" + Microsoft.CRM.Flags.ObjectType.otSystemUser.ToString() +"\">"; strAccountXml += userAuth.UserId + "</ownerid>"; strAccountXml += "</account>"; string strNewAccountXml = account.CreateAndRetrieve(userAuth, strAccountXml); } catch (System.Web.Services.Protocols.SoapException err) { // Process the platform error here strErrorMsg = ("ErrorMessage: " + err.Message + " " + err.Detail.OuterXml + " Source: " + err.Source ); } catch (Exception err) { // Process other errors here strErrorMsg = ("ErrorMessage: " + err.Message ); } Tag: Is there a way to identify shared accounts using SQL Tag: 31844
  - 16
    - Change Date Format Within E-mail While using the E-mail Template Manager, I notice the date format that comes in from the database is 2005-01- 12T00:00:00-05:00. I'm assuming this is GMT format. I would like to have this format modified to 12/01/2005. Is this possible? Please help ... Tag: Is there a way to identify shared accounts using SQL Tag: 31840
  - 17
    - Dates Hello Everyone, I am tring to create a sql report off the CRM database and suppose if I write a query Select * from Opportunity where estimatedclosedate >='12/30/2004' It sometimes picks up records equal to '12/30/2004' and sometimes it doesn't. when I say Estimatedclosedate='12/30/2004' then it doesn't return anything at all and one more thing I noticed was on the CRM site there is an opportunity with estimatedclosedate as '12/30/2004' and that same record is stored in CRM database with Estimatedcloseddate as '12/31/2004' Any help is greatly appreciated. Regards, Rose Tag: Is there a way to identify shared accounts using SQL Tag: 31827
  - 18
    - How to pass a parameter to a crystal report with a twist I'm cheating because I need a quick answer. I already know how to pass a parameter to a report manually. But how do I pass an entity ID through as a parameter? Specifically, I am adding a button to the account and contact objects using the isv.config file. I want these buttons to open a report filtered to the calling object. I.e. a report that lists all the the invoice line items for the contact that being viewed. Tag: Is there a way to identify shared accounts using SQL Tag: 31826
  - 19
    - Unsupported but working: CR w/external ODBC CRM SERVER 1) Copy crdb_odbc.dll to the Crystal Decisions Bin directory along with all the other cr*.dll (Programs/Common/Crystal Decisions/2.0/BIN) I believe 2) Create ODBC for external datasource on CRM SERVER - make sure you use Windows Authentication DEVELOPMEN 1) Create ODBC for external datasource while developing report. Same name/settings as ODBC on CRM SERVER GOOD LUCK! PS crdb_odbc.dll comes with the licensed Crystal Reports - if you do not have your own Crystal Reports you do not have this .dll Tag: Is there a way to identify shared accounts using SQL Tag: 31822
  - 20
    - New Version Release I heard there might be a beta version of CRM 2 available first half this year before the full release later in the year. Does anyone have more info on this? Thanks. Tony Tag: Is there a way to identify shared accounts using SQL Tag: 31819
  - 21
    - Changed System Admin Role Privileges Now Get Role Errors I accidentally changed the System Admin Role to disable leads and now I am locked out of being able to put it back. How do i fix this problem? -- Dave Tag: Is there a way to identify shared accounts using SQL Tag: 31806
  - 22
    - Assign without sharing properties Hi there, When assigning a record, we don't want our users(assigners) to keep any sharing properties(read, write, etc...) over that record. Is there any possibility to do this? or is this some native unchangeable CRM feature? thanks, Diogo Tag: Is there a way to identify shared accounts using SQL Tag: 31799
  - 23
    - CRM 1.2 Massmail Problems with the Subject Line of Microsoft CRM E and the tracking number in. I saw, that there was an update for the CRM 1.0 to remove the tracking number. How can I remove this tracking number with the version 1.2? Tag: Is there a way to identify shared accounts using SQL Tag: 31798
  - 24
    - Leads Is it possibe to send an email to all Leads which were entered by diffrent users? Thans Tag: Is there a way to identify shared accounts using SQL Tag: 31797
  - 25
    - I can't access to Workflow Manager Hi !! I can't access Workflow manager ... I was using my server as localserver and CRM only could be acces locally but now we put it in DNZ zone so it can be accesed through Web but now I can´t access Workflow manager. Before we move it I access typing localhost but now it doen't work ... what should I type ?? This is the error message I get "The specified Microsoft CRM server is not responding. This might happen if it is currently unavailable or it is not a Microsoft CRM server. For more information, contact your system administrator." I hope you can help me ... Tnks in advance Karolina Tag: Is there a way to identify shared accounts using SQL Tag: 31791

Is there a way to identify which accounts are shared using an SQL query.

Thanks

Kim Cannon

Re: Is there a way to identify shared accounts using SQL by daniel

daniel
Thu Jan 13 22:00:34 CST 2005

Sharing information is stored in the PrincipalObjectAccess table.

"Kim Cannon" <KimCannon@discussions.microsoft.com> wrote in message
news:A6F89502-A9A3-45B6-AD5F-B89B3696E3CE@microsoft.com...
> Is there a way to identify which accounts are shared using an SQL query.
>
> Thanks
>
> Kim Cannon

Top

Re: Is there a way to identify shared accounts using SQL by Kb

Kb
Mon Jan 17 23:11:05 CST 2005

It should also be pointed out that the PrincipalObjectAccess table is for
display purposes only. When an account is shared, an entry is made into this
table and the sharees SID is added to the account's security descriptor. The
security desciptor is used by the security service to determine if a user has
share access to a record. So, adding an entry in the POA table at the db
level is not a way you could share out an account programmatically.

"daniel" wrote:

> Sharing information is stored in the PrincipalObjectAccess table.
>
> "Kim Cannon" <KimCannon@discussions.microsoft.com> wrote in message
> news:A6F89502-A9A3-45B6-AD5F-B89B3696E3CE@microsoft.com...
> > Is there a way to identify which accounts are shared using an SQL query.
> >
> > Thanks
> >
> > Kim Cannon
>
>
>

Top