Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Deleting records via Database ( Microsoft Dynamics CRM 2011 RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    Hello, Good afternoon Friends! 
    I wonder what the impact of clearing an entire table from Microsoft Dynamics CRM via SQL Database 
    use the command 
    "Delete from new_dadosacademicos" 
    and delete all records from the table?
    Wednesday, July 9, 2014 5:43 PM

Answers

  • Question
    Sign in to vote
    2
    Sign in to vote

    It's not supported to create, update or delete from the database directly. 

    One reason is that any plugins or workflows designed to fire on those events will not be triggered not to mention you run this risk of not deleting related records. 

    You'd be much safer running a bulk delete job from Settings -> Data Management to delete all the records in a safe and supported manner. 

    Jason Lattimer
    My Blog -  Follow me on Twitter -  LinkedIn

    Wednesday, July 9, 2014 7:36 PM
    Moderator