Extended Stored Procedure.
I have an extended stored proc that is associated with a .dll.It was working fine on the old SQL SERVER.
when we migrated the SQL server to a new one. This .dll doesn't give back result that it used to do.
We investigated the connection in the application of the .dll to see to which SQL SERVER server it is pointing to, we found nothing was hard coded.