You love this if you write a lot of T-SQL code. This tip I can say as T-SQL language syntax enhancement. The following are the enhancements in T-SQL
Now We can declare and initialize the variables with single statement.
Remote Desktop Sessions from Commandline
You will commonly see the following error message when you try to connect windows 2003 server using RemoteDesktopConnection. “The terminal server has exceeded the maximum of allowed connections †You can disconnect the other remotely logged in users if you are a domain Admin user. Most of the users some time not even be using the sessions. To see the list of remote sessions in the...
Solution for Office 2007 application project system could not be enabled
When you first time creating a Office 2007 application using VS 2008 you may get the following error. “Programmatic access to the Microsoft Office Visual Basic for Applications project system could not be enabled†The Error looks like the following window The solution for the above error is 1. Open the MS Word or MS Excel 2. Go to Tools Menu then select Macro then click security option 3...
Calculating the size of the File in C#
Introduction This code snippet explains how to calculate the size of the file and display in a label control. For example I am taking PDF file to find the size. It Displays the size of the file in Bytes, Kilobytes and Megabytes. //Calculate size of the PDF file if (PdfFilePath.EndsWith("pdf")) {...
Working with Configuration files
Introduction Configuration files are central place to configure your web or windows applications. The web.config file is used for configuring the web applications and app.config for windows applications. The ASP.NET Application comes with web.config file with default configuration sections and you can easily manage them at the intialstage of the project development. As soon as your project grows...
Configuring .NET Framework 1.1 on windows vista
Configuring .NET FW v1.1 on Windows vista is bit tricky. Here are the steps you need to follow Download .NET Fx from .NET FW v1.1 because by default vista come up with .NET FW v2.0 and v3.0. If you install FW v1.1 alone at the end of installation you will get the following error RegSvcs...