You can find startup procedures with this code:

use master;

select StartupProc = name

from sys.sysobjects where xtype = 'p'

and OBJECTPROPERTY(id, 'ExecIsStartup') = 1;

If you want to see them actually execute,...

If the jobs are all SQL based, IE, not calling operating system processes, you can also see them running in sysprocesses:

http://code.msdn.microsoft.com/SQLExamples/Wiki/View.aspx?title=AgentLongRunning&referringTitle=Home

Are you using the SSIS Compatibility Execute DTS Task, or are you building the package from scratch in SSIS? If you built it from scratch in SSIS, what kind...

If you monitor the SQL:StmtCompleted Trace Event, and add a filter for TextData LIKE '%sp_%' or TextData LIKE '%xp_%' it will trap them.

You need to implement the Singleton pattern as a part of your CLR Assemblies design, using a static readonly object member variable which still allows for the Assembly to be...

I guess I am not getting somthing from your logic that is probably important that makes it RBAR. Even if the correct implementation in TSQL was a RBAR solution,...

My advice on this would be to not use CLR for it. TSQL is best suited for this operation. You will lose performance pulling the data into the...

To understand what is happening here, you really have to have a understanding of how the MTL is allocated at startup, and how it is consumed later on. I...

Take a look at the SqlDependency Class in .NET 2.0.

http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldependency.aspx

You can register a dependency object in an external app that triggers an event when the data changes in the database....

I am surprised that PSS didn't tell you up front that the assembly you are trying to load is unsupported in SQL Server, and you shouldn't be using it in...

Paul,

did you happen to get this working, or are you still having trouble?

Abstract the logic that you want to use inside SQL Server to a new assembly and restrict it to the approved assembly list only. That is the only alternative...

If this was a homework assignment, then you have a bad teacher if this is the kind of implementations of SQLCLR that they are teaching. Others here will agree...

You don't need a CLR object to do this. You can do it in TSQL completely, and with much better performance. If you are new to SQL Server,...

The EXECUTE AS is SQL Based, not CLR Based Impersonation. You would still be operating as the SQL Service account exterior to SQL Server. Making the windows identity...