I have created several extended stored procedures in SQL 2008 which when i run always return a NULL. I call these XP's from within a stored procedure. They work fine in SQL 2005 and SQL 2000. One thing i have noticed is when i click on the properties of the xp the path to the DLL is not there is that normal in 2008 (cos it shows the path in sql 2005).
When i run the XP in Query mode without calling from another stored procedure i get error:
Could not load the DLL "C:program files....."
syntax i have used to create:
exec sp_addextendedproc N'xp_Commission', N'C:Program FilesMicrosoft SQL ServerMSSQL10.SQL2008TEST1MSSQLBinnxp_commission.dll'
make call like so on the master DB:
Thanks in Advance