Detecting Custom Objects Used by SQL Server 2000 objects

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Scott Yu (ScottYu_at_discussions.microsoft.com)
Date: 11/02/04 

Date: Tue, 2 Nov 2004 12:39:01 -0800

Hello,

I work as a software engineer and we have installed third party and custom
in-house dlls and ocx on our SQL Server 2000 server to support our business
applications. These dlls and ocx are referenced by the database
objects(jobs, storedprocedures). What I need to do is to generate a list of
all the dlls and ocx that our SQL Server reference, so that I can copy these
files out to our new future SQL Server box.

Does anyone here know how to do this? Is there a system table in one of the
system databases that keep track of the information I'm seeking?

Thanks you.
Scott Yu

Relevant Pages

  • Re: Visual Basic executable file
    ... i am specifying the database is in d:/system/database name. ... If your App uses no OCXes, AX DLLs etc, then you can get away with ... it is something that includes other files in just one EXE ... I've tested it on an OCX and it worked fine, ...
    (microsoft.public.vb.general.discussion)
  • Re: missing msadodc.ocx
    ... open the database and go into the Code Editor. ... ocx, one or more errors should be generated. ... As to how the reference got there if you don't need it, ... > OfficeXP. ...
    (microsoft.public.access.setupconfig)
  • Re: missing msadodc.ocx
    ... open the database and go into the Code ... >ocx, one or more errors should be generated. ... >As to how the reference got there if you don't need it, ... >experimenting with additional controls on the form at ...
    (microsoft.public.access.setupconfig)
  • Re: Creating 3.5 databases ?
    ... If you have the right DLLs you can create a 3.5 database ... I changed the SqlServerCe.dll reference to 3.5, ... "The database file has been created by an earlier version of SQL Server ... I successfully upgraded the sdf file, ...
    (microsoft.public.sqlserver.ce)
  • Re: how to create a reference to a DLL which does not have a separate .tib type library file
    ... DLLs likely need to be in the same folder as your Access FE database ... But did you try using it in your code without a reference? ... Tony Toews, Microsoft Access MVP ...
    (comp.databases.ms-access)