0

Hey all. I'm integrating a CLR/Assembly-based sproc replacement for an existing sproc that lives within our production database, and I want to write an update script that only drops the old T-SQL-based script and doesn't drop the new one if its already there. Is that possible?

bitcycle
  • 7,632
  • 16
  • 70
  • 121

1 Answers1

1

When you query against sys.objects where type = 'P' (or sys.procedures), only SQL stored procedures are returned and not CLR functions. See sys.objects or more.

Thomas
  • 63,911
  • 12
  • 95
  • 141
  • Hey, Thanks! I didn't think that it was going to be that easy. Apparently the CLR-based stored procedure has a [sys.objects].[xtype] of 'PC'. – bitcycle Apr 23 '10 at 20:37