So you have stored procedure and it’s having issues. When you run it, it returns really fast. When .NET runs it, its like a dog. The first thing you learn about SQL Server is that it has something called ARITHABORT and it is turned on in SQL Management Studio and OFF in ADO.NET. Yeah you heard that...

How to use Generics in C# to allow you to return an array of data objects directly from a stored procedure class

When life throws you hard balls, you can either step back and take a swing or bunt the hell out of it. I just recently went to an information session on T-SQL, Stored Procedures and now LINQ. These folks discussed stored procedures and why they are so important in the world today.

Help me send SMTP mail using a stored Procedure that is auto send email

Subsonic makes working with stored procedures and your database simple. Today we'll discuss the basics in getting SubSonic to allow you to very easily interface with stored procedures and your data store.

This is acctually quite simple. There is 'startup' option that you can set to the procedure. Code included.

This article would explain in detail the methods involved in searching strings within ALL stored procedures. I am sure there might have been situation where you want to find out a stored procedure where you remember writing some complex logic. Won't it be nice if we can find out that stored proce...