Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Find all programs installed on a server 1
- Thread starter allyne
- Start date
-
1
- #2
- Thread starter
- #3
Sorry...should have given more detail. I've been tasked to look at an old SQL 2000 server and find all windows programs. There seems to be some old software on it that no one knows about and is needed for something but we don't know what and we are not physically seeing it anywhere. I thought I might be able to see something if I had a sql script.
Thanks for your help.
Thanks for your help.
Olaf Doschke
Programmer
SQL Server is a windows program in itself. Sometimes a physical (or virtual) machine running an SQL Server instance is called SQL Server itself, but that's misnaming things.
If you look for windows applications installed the control panel will show any official installations, the registry will have these in SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\. But software can install without uninstall info, an EXE can run anywhere, as long as runtimes are there, eg C++ runtime is in system32 or syswow64 and several .net framework versions may be installed, so many software runs without any setup.
It seems to me you are actually not looking for windows applications but for any code related to some database or the SQL Server , but not the Server itself, eg SQL Server related third party products like tools from redgate. Add ons.
What can run in a database besides stored procs and user defined functions are jobs, eg backup/restore and other maintainance but also ssis packages, in the former SQL Server 200 that's rather DTS (data transformation services), OLAP cubes can be built from OLTP databases as side job (not seen directly in the database) in that way, for example and last not least SQL profiler tasks may run on the database. You can have sql server projects, BI projects in the form of visual studio projects, old projects of previous VS versions, even before .NET. That's mainly all the job of a DBA to know about and all in the regime of the SQL Server and management studio, least things in regard of an SQL Server instance will show up on the windows programs and functions listing of installed software.
Bye, Olaf.
If you look for windows applications installed the control panel will show any official installations, the registry will have these in SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\. But software can install without uninstall info, an EXE can run anywhere, as long as runtimes are there, eg C++ runtime is in system32 or syswow64 and several .net framework versions may be installed, so many software runs without any setup.
It seems to me you are actually not looking for windows applications but for any code related to some database or the SQL Server , but not the Server itself, eg SQL Server related third party products like tools from redgate. Add ons.
What can run in a database besides stored procs and user defined functions are jobs, eg backup/restore and other maintainance but also ssis packages, in the former SQL Server 200 that's rather DTS (data transformation services), OLAP cubes can be built from OLTP databases as side job (not seen directly in the database) in that way, for example and last not least SQL profiler tasks may run on the database. You can have sql server projects, BI projects in the form of visual studio projects, old projects of previous VS versions, even before .NET. That's mainly all the job of a DBA to know about and all in the regime of the SQL Server and management studio, least things in regard of an SQL Server instance will show up on the windows programs and functions listing of installed software.
Bye, Olaf.
- Thread starter
- #5
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question