The Database Engine Service could not resolve the specified location. You are most likely to get this error message, if you try to restore or backup a database from a UNC drive (Mapped drive) If you … Read more
Handling White space in T-sql is very annoying. When you are comparing strings it is crucial that you remove any white space or special characters that could interfere with your results. You can user rtrim(ltrim … Read more
Here we go again! You are trying to connect to your freshly installed sql server 2008 R2 express edition using localhost as server name and you are getting this error. The purpose of this … Read more
Let’s say you want to order these times below. of course a simple “order by” will not do it, what you need is the query given below 1:00 PM, 1:30 PM, 10:00 AM, 10:30 AM, … Read more
System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object … This usually happens if the user does not have execute permission on the stored procedures that the application is calling. While there might be many … Read more
