SQL Server 2008 – Page 5

.Net, ADO.NET, ASP.NET, Database, DB Connection Example, Error Handling, SQL, SQL Server 2005, SQL Server 2008, SQL Tips, Transact-SQL, tSQL, Web Development, XML

Correcting: SELECT failed because the following SET options have incorrect settings: ‘ARITHABORT’

2013-10-292013-10-29 Justin Cooney

This error showed up on a stored procedure that I was trying to execute from an ASP.NET Web page. The strange part was that I could execute the stored procedure directly from SSMS without any problems.

The procedure was very simple in its design, but the database I was working in was new to me and I had very limited access. The procedure was set up to receive an XML parameter and then to do a bulk insert into a table from the XML. Continue reading “Correcting: SELECT failed because the following SET options have incorrect settings: ‘ARITHABORT’” →

Database, Programming, SQL, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Tips, Transact-SQL, tSQL

SQL Server Rounds FLOATS when Casting to VARCHAR

2013-09-252013-09-25 Justin Cooney

A quirk about converting between the FLOAT and the VARCHAR data types in SQL Server is the unexpected rounding that will happen. This is specific to working with the FLOAT data type, and the rounding will not happen when casting a DECIMAL or an INTEGER. Continue reading “SQL Server Rounds FLOATS when Casting to VARCHAR” →

Database, SQL, SQL Server 2005, SQL Server 2008, SQL Tips, System Objects, Transact-SQL, tSQL

Get All Linked Servers Modify Date in SQL Server

2013-09-182013-09-18 Justin Cooney

This is a short post that extends on a concept that I talked about in a previous article about querying linked server information in SQL Servers 2005, 2008, & 2012 using T-SQL. Specifically, I will give an example of how to check the last modified date for each linked server residing on your database server. Continue reading “Get All Linked Servers Modify Date in SQL Server” →