Tips & Tricks
In case you need to find out the version of the SQL Server installed on a server you could execute the following statement:SELECT @@VERSION;Which returns on my development sandbox the following string:Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) Apr 14 2006 01:12:25 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2) Cross-posted from The .NET Aficionado...
Part of my job is to provide guidance and take on the role of problem solver. Today I got visited by one of our .NET developers with the following problem: I need to create e-mail (.eml) files based on data I receive from a legacy system. Regarding the complexity of the file format I wonder if there is a way to do this using the Base Class Library (BCL) instead of writing a custom EML file writer. There is an easy solution but with some drawbacks. What you need to do is wrap all this data in a System.Net.Mail.MailMessage...
I got this tip from the book Visual Studio Hacks by James Avery and was contributed by Sara Ford. Vertical guidelines can be very useful to better organise your code. You can have up to 13 different guidelines in the Visual Studio IDE by adding some minor modifications to the registry. Here are the steps you need to take to add vertical guidelines: Close all instances of the Visual Studio IDE (not really required) Open the registry editor (Start -> Run -> RegEdit) Navigate to the following...
A co-worker received today the following exception after the installation of Oracle Designer everytime his web service tried to open a connection to the Oracle Server:System.Exception: OCIEnvNlsCreate failed with return code -1The problems started when help desk installed the Oracle Designer on his machine so we figured out that this exception was related to this installation. Now what was exactly the problem.Together with the installation of the Oracle Designer a different Oracle Client has been...
This is a problem that people have reported previously and it seems like this one is a bug in Windows XP. So far Microsoft has acknowledged this problem but hasn't offered yet a solution of fix since it doesn't seem "reproducable". The problem I am referring to are the missing icons in the Taskbar Notifcation Area. Like the volume control icon that is missing or the network connection icon and so on.Since the cause is not known for sure there are several speculations of which the...
In Windows XP when you try to do a search for people or computers you see a different dialog box then you would normally see when you try to do a search in for example Windows Server 2003. This is how the dialog box looks in Windows XP: There is however a way to open the more detailed Active Directory search dialog in Windows XP: Start -> Run -> rundll32 dsquery,OpenQueryWindow Which will open the following dialog: Cross-posted from The .NET Aficionado...
Months ago I received an account for Google Analytics and I forgot about it. Two days ago someone reminded me indirectly that I still had an account so yesterday I decided to give it a try. If you want to Google Analytics empower your site you need to embed a javascript block (called the conversion code) into all the pages you want stats on. In CS instead of modifying all the master pages there is an easier way and propably the correct way to inject the conversion code into all the ASPX pages