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

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


"Richard Grimes" <richardg@xxxxxxxx> wrote in message
news:u90hkT5DGHA.3984@xxxxxxxxxxxxxxxxxxxxxxx
> Michael D. Ober wrote:
>
> dumpbin /clrheader is your friend. If the file is a .NET assembly the
> /clrheader will list details about .NET in that file; if it is an
> unmanaged application, then /clrheader will not list anything. You can
> also use the tool on my website which will go through a folder and tell
> you which files are managed, which are unmanaged and which are managed but
> host the runtime.
>
>> SQL Server 2005 is a .NET 2.0 application.
>
> No it isn't. SQL Server 2005 hosts the runtime to allow you to write
> stored procedures in .NET. This means that it is an unmanaged application
> that allows .NET code to run in its memory.
>
> 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 for
> interop with managed code, for ASP.NET, but the majority are for 'setup
> bootstrap'. All of the main files in SQL Server are unmanaged. So it is
> incorrect to say that SQL Server is a .NET application.
>

Did you also notice that a number of "SQL assemblies" are now authored using
C++/CLI? Is this just "dog-fooding" or is there something else going on?

Willy.



.

Relevant Pages

  • Re: I have 2 versions of .NET, which is being used
    ... /clrheader will list details about .NET in that file; ... My measurements show that for SQL Server 2005 Express there are 137 ... > because of the security implications of managed code. ... Hosting the runtime to use a small amount of .NET code (like the ...
    (microsoft.public.dotnet.framework)
  • Re: 4 Queries about DB clustering
    ... All drives will need to be visible to all hosts for failover. ... I support the Professional Association for SQL Server ... > I have a similar situation where I plan to install/configure multi-instance> cluster. ... SQL binaries will live on>> the local disks of each cluster host. ...
    (microsoft.public.sqlserver.clustering)
  • Re: 4 Queries about DB clustering
    ... but live on a single host node at a time. ... instance is an independent installation of SQL server. ... www.sqlpass.org "Kamal Hassan" wrote in message ... or do have any recommendation for the above setup before> setting up clustering. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Access denied when .ldb is present (only for XP-SP2)
    ... with Win XP are either SQL Server, ... > 4) not mapped drives - i connect to host pc, ... >> 3) multiple domains? ...
    (microsoft.public.access.security)
  • Re: Re:Connection
    ... I know you host a web site on your ISP. ... You want to know you'd better host the SQL server on ...
    (microsoft.public.windows.server.sbs)