Re: I have 2 versions of .NET, which is being used

Tech-Archive recommends: Fix windows errors by optimizing your registry




"Lloyd Dupont" <net.galador@ld> wrote in message
news:Oztq4C6DGHA.1180@xxxxxxxxxxxxxxxxxxxxxxx
>> My measurements show that for SQL Server 2005 Express there are 137
>> executable files (dll and exe) and of those 46 are managed. These are
>
> common, 47 on 137, that's a good score for a huge legacy product!
>
>

But these have nothing to do with SQL "Server" code, it's supporting code
for interop and client side management, you don't need this stuff if you
only run SQL server without using CLR stored procs.
Also note that even when hosting the CLR, SQL Server will not use all of the
functionality of the CLR. SQL server uses the CLR GC to manage object
lifetime, but he allocates/manages his own GC heap, the same goes for
threading, SQL uses it's own thread pool, and you aren't allowed to start a
thread in a managed stored procedure when hosting, neither can you use
PInvoke interop.

Willy.


.



Relevant Pages

  • Re: MS SQL Server Management Studio - Import and Export Settings
    ... you can use Management Studio as a script development ... platform for SQL Server, Analysis Services, and SQL Server Compact Edition. ... DefaultNewProjectLocation - %USERPROFILE%\My Documents\SQL Server ...
    (microsoft.public.sqlserver.setup)
  • Re: compiled Delphi.NET?
    ... I was at PDC 2003 and spoke with Jose Blakely, SQL Server Architect ... The presentation was on hosting the CLR, ... The crux of .NET is managed code, otherwise, what's the point? ...
    (borland.public.delphi.non-technical)
  • Re: adp vs mdb
    ... can you copy and paste a view in SQL Server Management Studio? ... ADP uber alles ... And his criticisms were entirely sensible. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Quick Question on SQL Server 2005 Express
    ... I wondered if we need any type of license to use Management Tools on a non-licensed machine so I asked to the Server and Tools Product Manager of Microsoft Turkey, whose name is Selma Karaca, I had met her on several Microsoft seminars which are held here in Istanbul... ... Server tools or technologies installed must have a valid SQL Server license. ... I have installed SQL Server 2005 Express, and now I want to connect to the remote database and use the Management Studio to manipulate the database. ...
    (microsoft.public.sqlserver.setup)
  • RE: connection problems in secondary site and SQL server
    ... Management Point MP_RETRY.LOG and MP_GETAUTH.log files. ... I wonder if it is full of Database connection errors? ... I use SMSService account to ... SMS on SQL Server My_Primary_SMS_Server. ...
    (microsoft.public.sms.admin)