Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 7 down vote favorite
1

Do SQL Server Express Editions (2005, and 2008) have support for installing, enabling and running CLR Stored procedures and functions.

share|improve this question
5  
Yes – Martin Smith Jan 24 '12 at 14:43
I guess there might be specific issues with using this on Express though as it only has 1GB of memory to play with anyway. – Martin Smith Jan 24 '12 at 14:47
1  
@MartinSmith I'm pretty sure the 1GB limit is buffer pool (single-page allocator) only. SQLCLR allocations make use of the multi-page allocator. (Versions >= 2005 and < 2012) – Paul White Jan 25 '12 at 2:00

2 Answers

up vote 7 down vote accepted

Yes, the Express editions do support CLR integration. The link is for the latest version, but if you switch to 2008 you will see it is supported there too.

share|improve this answer
up vote 0 down vote

Yes, this is supported.

A note of caution, though: to support 2005, you have to be extremely careful to thoroughly test your application on 2005, because some of the functionality is limited compared to 2008+, and the differences are buried in the documentation.

For example, we had to deploy a user-defined aggregate function for our database, which is supposed to be 2005+ compatible, but found that the MaxByteSize attribute cannot be set to -1 (unlimited) on 2005 (and we require it to be -1 for our purposes). We were able to restrict deployment of the assembly to 2008+ for that feature -- you may not be as lucky.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.