Don't know if this helps - I use this to search for references in stored procs:

SELECT Distinct SO.Name

FROM sysobjects SO (NOLOCK)

INNER JOIN syscomments SC...

Try looking at this to watch your memory problem:

select * from sys.dm_os_memory_clerks where type = 'MEMORYCLERK_SQLCLR'

Hi,

Look at these:

sys.assemblies

sys.dm_clr_appdomains

sys.dm_clr_loaded_assemblies

You should be able to find out what you need.........

Thanks - but what I ideally want to do is verify the requested connection entirely in the logon trigger. If the connection is not valid, I will simply do a...

Thanks for the reply.

SQL server is simply failing to execute any code in the DoCallBack method, I tried putting a return statement at the top of this method so...

Hi Grant,

Thanks for the reply. The database is for controlling licenses on a client site. The database contains all the available licenses to the user, when then select a license,...

Thanks for the reply. I've thought of another approach that is easier, i think. I've created a strored procedure which executes automatically from startup. In the procedure I simply use...

Hi Jack,

Thanks for your reply. I tried what you suggested, but it still didn't work. I was getting an error about the SQL Server Agent. I didn't mention in my...

Thanks Gail / Steve,

I've used a stored procedure to run on start up and it's doing exactly what I want!

Thanks again for your help - much appreciated!

Hi Gail,

Thanks for your reply. The database manages licenses that get handed out when requested by a client. The application renews its license by polling the database every few minutes....