SQL Server 2005 Version

Want to know which SQL Server version you exactly have? Execute the following query and the SQL Management Studio will tell you:

select @@version


Kevin Dosseray

Comments

Post a Comment

Popular posts from this blog

"Current active key expired" Error

A client was getting an "Invalid Action" error when trying to open their Microsoft CRM 4.0 (on-premise) application. Checking the event log, showed the following: Event Type: ErrorEvent Source: MSCRMKeyGeneratorEvent Category: NoneEvent ... Description: Current active key (KeyType : CrmWRPCTokenKey) is expired. This can indicate that a key is not being regenerated properly. Starting the Microsoft CRM Asynchronous Processing Service on the server solved the problem! Kevin Dosseray
Read more

BizTalk Error: The adapter failed to transmit message going to send port

I was doing the following: in my orchestration I was sending a message to a custom WCF service. The message was build dynamically (custom .NET class) and passed to a send port configured for a WCF service. All looked fine (and compiled correctly) until I ran the application: I received the "The adapter failed to transmit message going to send port" error. After some investigation it turned out I received the error because the type of the message I was sending through the send port did not match with the type the WCF expected at the other end. After updating my message with the correct namespace, all worked fine again.
Read more

Updating CRM Data from Excel

In the beta version of MS CRM 4.0 it was possible to update CRM data from Excel: you could export data to Excel, change the data in the Excel file, save it as an CSV file and import it back into CRM through the 'Data Management' -> 'Import' option. Sadly enough, with the official release of CRM 4.0, this useful feature of updating data from Excel was left out... But apparently, this is not completely true. You just need to know how to 'enable' the feature. So here we go: - Export the data you like to update to Excel (go to the grid or create an advanced find, select the records you want, click 'Export to Excel' and choose static worksheet). - In the Excel file, add a column to the left with the name of the entity as column name. In this column, add the Guids that correspond to the records. - Update some values and save the excel as a CSV. - In CRM, go to Settings -> Data Management -> Imports and create a new import record. - Select the CSV you ...
Read more