sql-server-2012 Archives

Occasionally Getting SqlException: Timeout expired

August 30, 2022 by Magenaut

I have application running on my server. The problem with this application is that daily I am getting nearly 10-20, System.Data.SqlClient.SqlException Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding only one of my SP. Here is my SP,

DateTime.Kind set to unspecified, not UTC, upon loading from database

August 28, 2022 by Magenaut

When I create a Buyin object the response from the ASP.NET MVC controller, (return Json(response, JsonRequestBehavior.AllowGet);, looks like this:

SQL – INSERT with Scope_Identity() – getting the record id

August 24, 2022 by Magenaut

I have an ASP.NET page written in VB.NET that gets the items into a GridView by using a SELECT statement with INNER JOIN and also allows you to add an item to the invoice.

Unable to pass multiple values in querystring in .aspx to report at runtime

August 23, 2022 by Magenaut

This should be simple process but now it became annoying issue.