I want to migrate some databases hosted in SQL Server 2000/2005 to SQL Server 2014.
I don't have direct access to the databases and I want to know all applications connecting to it and connection details. Is there any best way to get this information? I tried using DB profiling but its not allowed as its taking up lot of space on hosted DB server which causing disruptions.
Any better way like a SQL statement or remote connection monitoring will be helpful.
Thanks in advance for all your help.