code & chips

I have just spent the last hour trying to locate – by hook, crook and Google – the location of the SMO assemblies I need to develop a sql management application in C#.

I found it and need to log it:

{Program Files}\Microsoft SQL Server\100\SDK\Assemblies

I ran a stored procedure through SQL Server Studio and it came back quick!

I ran the same stored procedure through C# code and it ran slow.

The solution?

SET ARITHABORT ON

GO

CREATE PROCEDURE dbo.SomeProcedure

AS

BEGIN

(…)

END

Not altogether sure why though…..ho hum…