The BOL is probably the best reference point for you:

http://msdn.microsoft.com/en-us/library/system.text.regularexpressions.match.groups.aspx%5B/url%5D

Is there something specific that you are having a problem with this? Can you provide an example...

As long as you use the same certificate key to sign the other assemblies.

Thanks for sharing that. I learned something new.

Kent,

I documented how to do this with screenshots on the link I provided above. You can access the article directly though using:

http://www.sqlclr.net/Articles/tabid/54/articleType/ArticleView/articleId/9/Default.aspx

Same question also asked on MSDN Forums:

http://forums.microsoft.com/Forums/ShowPost.aspx?PostID=3944576&SiteID=1&mode=1

Perform the encryption operations external to SQL Server is the only thing I have ever seen recommended. System Administrators have the keys to the kingdom, it is one of...

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.

I wouldn't turn trustworthy on just to run a External_Access or Unsafe assembly. Trustworthy allows numerous other things to occur security wise as well, and you don't need those...

kent.kester (9/30/2008)

---

The performance benefit of stored procedures starts to look tempting when you start thinking about running the same query 5000 - 10000 times for a single job every...

I agree completely. A stored procedure is much easier to maintain for what you are doing.

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,...