VS SQL Server Project is restricted to what assemblies you can reference

by admin 23. June 2008 21:40

However there are ways around it:

1. Don't use the VS SQL Server Project, but just create a normal class library project, add references as per usual and then manually create your assembly through CREATE ASSEMBLY. Make sure your referenced assemblies are in the same directory as your user assembly. The SQLCLR team has released some code that automatically creates procs/functions/triggers etc. when you run the CREATE ASSEMBLY code.

2. If you want to use the VS SQL Server Project you can create the assembly you want to reference in the database before you try to reference it. I.e: do a manual CREATE ASSEMBLY against the ManagedDTS.dll

3. Use my SQL Server VS templates and deploy task. This gives you the ability to reference what you want, and still get auto deployment. However, which-ever way to go, be careful with what you are doing. You don't want some code to compromise SQL Server!

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags:

Security | SQL 2005

Comments are closed

Powered by BlogEngine.NET 1.4.5.0
Theme by Mads Kristensen

Calendar

<<  March 2010  >>
MoTuWeThFrSaSu
22232425262728
1234567
891011121314
15161718192021
22232425262728
2930311234

View posts in large calendar