Technology

Home / Technology

Get all the database names in a sql server instance using tsql

its a simple sql : SELECT * FROM sys.databases ;

Tables without a clustered index are not supported in this version of SQL Server

when you published the MVC application for windows AZURE cloud and SQL Azure it’s giving below mentioned error. Tables without a clustered index are not supported in this version of

How to enable remote connections in SQL Server 2008?

You experience the following error message: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that

Fix wamp httpd msvcr100.dll not found

29.04.2013   gyanendra   My SQL   1 Comment

Most of people get following error when they install WAMP, The MSVCR100.dll file is part of the Microsoft Visual C++, redistributables. You can install them and see if this solves

Cannot open database “” requested by the login. The login failed. Login failed for user ‘IIS APPPOOL\DefaultAppPool’.

22.04.2013   gyanendra   Asp.net   No comments

While starting development on a new project in Windows 7, I ran across the following error when trying to access the database. Cannot open database “<Database Name>” requested by the

Turn Off ALL CAPS Menus in Visual Studio 2012

22.04.2013   gyanendra   Asp.net   No comments

For all those people who can’t stand the ALL CAPS menus in Visual Studio 2012 there’s a way to switch them to normal casing. Crack open your registry editor and

Summing times that exceed 24 hours in Excel

22.04.2013   gyanendra   Excel   No comments

Q. I have a range of time values, but when I try to sum them, the total is never greater than 24 hours.   When you add a range that contains

Calculating time difference through midnight in Excel

22.04.2013   gyanendra   Excel   No comments

All Tricks and formula failed when you wanted to do time difference for midnight .. mostly questions arise like “How do I calculate the time duration in minutes between two

Saving the FolderBrowserDialog Selected Path or escape character to MySQL Database, using C#

Example: Here is my selected path from browserdialog C:\Users\Project\XXXX After saving it to database, the path goes like this C:UsersProjectXXXX Solution: You need to escape \ by using \\ instead.

How to Solve Android SDK Error : Unable to resolve target ‘android-x’

17.04.2013   gyanendra   Android   No comments

There are few variants of this error message: Unable to resolve target ‘android-1’ Unable to resolve target ‘android-2’ Unable to resolve target ‘android-3’ Unable to resolve target ‘android-4’ Unable to