I have alot of problems with the sql server installation. it's the developer
edicition and i can install in the server, but in mi machine when i try to
install it report me a message "SQL Server 2005 has detected incompatible
componentes from Beta versions of Visautl Studio, NET ...

In ADO.NET 2, I use SQLClient namespace to connect to SQL Server 2005. Does
it use SQL Native Client or SQL OLD DB?
Thanks in advance,
Leila

I thought I better post before this year ends. :-)
Anyway, you may know that I have developed a MSBUILD task dll for
deployment of SQLCLR assemblies. I also created some templates for use
from with Visual Studio 2005, the SQLCLRProject.

It seems a bit strange that you can't have an Add() method on a clr UDT as
it errors as a keyword.
set @t = @a.Add(@b)   -- Is an error because "Add" is a keyword.
".Add()" in this context does not conflict with the Add keyword IMO (except

I have had no problem in using a CLR function and a CLR procedure in my
SqlServerProject. However when I try to add one more function or procedure
in the same project it failed. Is there a limitation for that?

OK, since I have something relevant on my mind, let me make the first move ;-)
Which assemblies can we use in a SQLCLR object? Bol has a list
(ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/9c07f706-6508-41aa-a4d7-56ce354f9061.htm), but with
the list is below comment:

I am trying to get the SOP for doing new versions of data access &
manipulation in the CLR within the database.
Would I pass in an array of params for a SP, instead of the X# I needed to
in the past?  Or is the db now able to see which items have changed in a

I have default context connection and I need another one.
If I open it, I get message about Demand Security.
What and where schould I turn on?
Vladimir Chtepa.

Does SqlBulkInsert  not run in CLR? Why does not?
I get follwing exeception
System.InvalidOperationException: The requested operation is not available
on the context connection.

Hi! Please answer me - what can i make with SQL Server??

Can anyone explain the rationale behind EXTERNAL ACCESS ASSEMBLY and UNSAFE
ASSEMBLY being granted to server logins rather than database users?  This
seems counterintuitive to me, considering that assemblies are not
server-level objects.  I can definitely see cases in which I'd ...