Friday, August 5, 2011
Friday, July 29, 2011
Get list of data locations for SQL databases
Select name, physical_name from sys.master_files
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
Tuesday, May 17, 2011
Thursday, May 12, 2011
Configuring SMTP mail on Server 2008
Wednesday, May 11, 2011
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
Subscribe to:
Posts (Atom)