CREATE ASSEMBLY MyAssembly FROM 'S:\SourceCode\TryUDF\bin\Debug\TryUDF.dll'
an error is returned:
Could not find file 'SqlAccess.dll' in directory 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\'.
The assembly is a class library built with VS2008. SQL Server is 2005. SqlAcesss.dll exists in the above location, and that Binn directory is in the PATH environment variable for the system. How can I diagnose what is causing this problem?