CLR Integration in SQL Server 2005 Using Visual Studio 2005 – Part 2
page 7 of 8
by Soyuj Kumar Sahoo
Feedback
Average Rating: 
Views (Total / Last 10 Days): 42862/ 77

Note

If any error occurs in the above process like:

Server: Msg 325, Level 15, State 1, Procedure Object Name, Line 4 Incorrect syntax near 'external'. You may need to set the compatibility level of the current database to a higher value to enable this feature.

Then we have to set the compatibility level to 90 from 80, which is default, before we create a CLR object in the database.

Listing 4

EXEC sp_dbcmptlevel 'DatabaseName',90

View Entire Article

User Comments

Title: Update?   
Name: Apuma
Date: 2010-02-03 7:17:37 PM
Comment:
Can we see an example using VS 2008?
Title: Bout the article..   
Name: ainOmar
Date: 2007-05-13 10:57:53 PM
Comment:
can u simply attach more samples using .net clr
Title: Nice Article   
Name: Abhishek
Date: 2007-02-21 4:50:26 AM
Comment:
Nice article to work with .net CLR.

Product Spotlight
Product Spotlight 





Community Advice: ASP | SQL | XML | Regular Expressions | Windows


©Copyright 1998-2021 ASPAlliance.com  |  Page Processed at 2021-01-25 12:07:36 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search