I'm trying to create and debug a CLR function written in C# using Sql Server Express Edition 2005. I'm using VS 2008 Professional. My goal is to write, test, and validate a series of functions on a locally installed copy of sql server express and later deploy
them to an instance of sql server 2005 on a server. I need to do debugging locally because I don't have SA privileges on the box it will deploy to and because the server is being actively used by my team.
I've created a "dummy" function to get started:
public static SqlDecimal Add2(SqlDecimal decd)
int ie = 1;
return new SqlDecimal((Decimal)decd + (Decimal)2.5);
I have a test.sql script set up as the default for debugging that calls the function, and a break point set up within the function.
When I attempt to debug the function by going to debug -> start debugging, the output window says "Auto-attact to process ' sqlservr.exe on machine '[my machine
View Complete Post