Thursday, May 19, 2011

Check which Update Rollup version is installed on CRM

Browse to the CRM website.
Click on the “Help” button on the top right side of the window.
Click on “About Microsoft Dynamics CRM”
Get the build number displayed
Check build number with link below

http://crmdynamo.com/2010/03/check-which-update-rollup-version-is-installed-on-your-crm-environments/

Tuesday, May 10, 2011

Rename a SQL server

Check the server name:
Select @@ServerName

For a server with a default instance:
sp_dropserver 'old_name'
GO
sp_addserver 'new_name', 'local'
GO

For a server with a named instance:
sp_dropserver <'old_name\instancename'>
GO
sp_addserver <'new_name\instancename'>, local
GO

Restart the SQL Server instance