You have 2 options.

1. You can run the following SQL query:

   SELECT SERVERPROPERTY(’productversion’), SERVERPROPERTY (’productlevel’), SERVERPROPERTY (’edition’)
   

2. You can check the version of the sqlservr.exe file, below is a list of how the version breaks down:

   SQL Server 2005

   SQL Server 2005 RTM	2005.90.1399
   SQL Server 2005 Service Pack 1	2005.90.2047
   SQL Server 2005 Service Pack 2	2005.90.3042

   SQL Server 2000

   SQL Server 2000 RTM	2000.80.194.0
   SQL Server 2000 SP1	2000.80.384.0
   SQL Server 2000 SP2	2000.80.534.0
   SQL Server 2000 SP3	2000.80.760.0
   SQL Server 2000 SP3a	2000.80.760.0
   SQL Server 2000 SP4	2000.8.00.2039

After an upgrade from CRM 3.0 to CRM 4.0 I noticed that items no longer deleted immediately. It seemed as if they eventually deleted, but I couldnt tell you when. From what I’ve heard from Microsoft and others, the problem is a trigger that is supposed to be disabled or removed during the upgrade. The fix was this:

1. In SQL Management Studio, expand the dbo.QueueItemBase table within your CRM database.
2. Expand the Triggers folder.
3. Right-Click the t_update_queueitembase trigger and disable it. (Select “disable” from the menu).

This may not address items that you have already deleted that are still pending deletion. To correct those, perform the following SQL command:

UPDATE dbo.QueueItemBase
SET DeletionStateCode = 2
WHERE QueueId = ‘YOUR_GUID_HERE’

You’ll have to find the GUID of the Queue you’re trying to delete from, but it’s pretty straightforward after that.

In order for printers to be completely autodeleted from both the registry and Print Manager users may need Full Control over the following registry key and subkeys:-

HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Control/Print

Users also need Change permissions to the following:

%systemroot%\system32\spool

These days many mailservers are requiring reverse DNS (rDNS) and SPF records to validate the sender from this domain.

How does SPF work:

SPF is easy to understand. The “Internet” uses DNS (Domain Name System) to resolve Domain Names (as an example www.msexchange.org) into IP addresses. DNS is also used to direct requests for different services like e-mail and Web Servers. For every Domain around the world an MX (Mail Exchanger) record must exist. An MX record tells the e-mail sender where the target server for receiving mail is located.

SPF is publishing “reverse MX” records in DNS which tells the mail sender which machines send mail from the domain.

The recipient of the e-mail can now check these records to ensure that e-mail is coming from a “trusted” sender from this domain.

These “reverse MX” records can be easily published in DNS. It takes only one line in DNS to fullfil all requirements.

Microsoft has come up with a good and easy wizard (webpage not downloadable tool) that asks a few questions and spits out the correct SPF.

How to add SPF file to Windows Server DNS - link

OpenSPF Website - link or old site

When troubleshooting a computer that beeps when trying to start the computer, usually referring to the motherboard manual or OEM User manual is the quickest way to find out what is causing the computer from not booting. Here is a couple of links to motherboard and OEM beep codes.

Tech Republic - Beep codes for desktops

http://www.bill-cash.com/bios_beep_codes.htm

Issue: When connecting to a Windows 2003 Terminal Server over RDP, some or all of your local printers (LPT or Parallel printers seem to always autocreate), ie USB, local TCP/IP printers don’t autocreate when logging on. Some of the multifunction devices and other USB printers use DOT4 printing which isn’t recognized by default by Windows Server.

Cause:This problem occurs because the printer port does not begin with COM, LPT, or USB. By default, printer port names that do not begin with COM, LPT, or USB are only redirected in Windows Server 2003. By default, multifunction print devices may not be redirected unless you are running Windows Server 2003 on your local computer because they use DOT4 ports.

Solution: To resolve this problem on a computer that is not running Windows Server 2003, force all ports (including DOT4) on the client computer to be filtered for redirection. To do this, open regedit and add a DWORD value named FilterQueueType to HKEY_CURRENT_USER\Software\Microsoft\Terminal Server Client\Default\AddIns\RDPDR and set its value data to FFFFFFFF. Log on to the Terminal Server and all local printers should be redirected to the server. To make sure that printing works normally, install the same printer driver on the Terminal Server so that the printer is mapped to the right driver.

This link provides helpful registry scripts to repair windows file associations:

http://www.dougknox.com/xp/file_assoc.htm

A client of mine recently had 2 CDRom drives that weren’t showing in My Computer. In the device manager, they showed up with exclamation points. Double-clicking them told me that the driver was installed properly but:

“Windows cannot start this hardware device because its configuration information (in the registry) is incomplete or damaged. (Code 19)”

After some research, the solution I found was to remove the LowFilter and UpperFilter entries from this registry area:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Class\{4D36E965-E325-11CE-BFC1-08002BE10318}

Note that you may have several identical keys like this (4D36E965-E325-11CE-BFC1-08002BE10318). The one you are looking for will list DVD/CD Rom Drives as the very first entry.

Reboot after making changes.

Regedit

Find

HKLM/Software/Microsoft/Office/11.0/Registration/<only-32-bit-ID>

-Change the value of key “ProductID” to “OldProductID”
-Delete the key DigitalProductId

Now start one of the office apps - it should ask you to re-enter the key, then activate normally.

In Microsoft CRM 4.0, many of the entities arent immediately available in the Outlook address books.  An example of this is Contacts and Leads.  To synchromize the CRM Address book in the Outlook client with the contacts and leads, you need to change some of the CRM options in the Outlook client.  To do this:

1. In outlook, with the CRM 4.0 client installed, select the CRM menu from the Outlook menu bar and select “Options”
2. On the “Address Book” tab select the following options
   • Match all contacts in Microsoft Dynamics CRM
   • Match all items in Microsoft Dynamics CRM
3. Click OK to set your personal options
4. Select “Synchronize with CRM” from the CRM menu on the Outlook menu bar to manuall sync the address books and test by trying to add a CRM contact as an email recipient.