USE [msdb] GO /****** Object: Job [Data_Update_statistics_everyday] Script Date: 05/27/2010 12:32:03 ******/ BEGIN TRANSACTION DECLARE @ReturnCode INT SELECT @ReturnCode = 0 /****** Object: JobCategory [Database Maintenance] Script Date: 05/27/2010 12:32:03 ******/ IF NOT EXISTS (SELECT name FROM msdb.dbo.syscategories WHERE name=N’Database Maintenance’ AND category_class=1) BEGIN EXEC @ReturnCode = msdb.dbo.sp_add_category @class=N’JOB’, @type=N’LOCAL’, @name=N’Database Maintenance’ IF (@@ERROR <> [...]
Posts Tagged ‘Update’
Update database statistics everyday
Posted: September 9, 2010 in Microsoft Dynamics CRM, SQL, SQL ServerTags: Database, SQL, Statistics, Update, Update Statistics
0
Using Update Method of CrmService WebService
Posted: July 28, 2010 in Microsoft .NET, Microsoft Dynamics CRMTags: Update, WebService
Using Update Method of CrmService WebService
Posted: January 20, 2009 in Microsoft Dynamics CRMTags: CRM, Update, WebService
// Set up the CRM Service. CrmAuthenticationToken token = new CrmAuthenticationToken(); // You can use enums.cs from the SDK\Helpers folder to get the enumeration for AD Authentication. token.AuthenticationType = 0; token.OrganizationName =”AdventureWorksCycle”; CrmService service = new CrmService(); service.Url =”http://<servername>:<port>/mscrmservices/2007/crmservice. asmx”; service.CrmAuthenticationTokenValue = token; service.Credentials = System.Net.CredentialCache.DefaultCredentials; // Create the contact object. contact contact = new [...]

