[extended Stored procedure]

• sambybaniwal

  SSC Rookie

  Points: 32

  More actions

  March 17, 2008 at 12:23 am

  #183348

  dear sir...

  i m studying abt extended stored procedure..

  i make a dll in vb.net and register it with sqlserver2005.. as extended stored procedure...

  but i m unable to execute it...

  can u plz tell me the wholr process how to call a dll from sqlserver2005.

  extended stored procedure is DLL

  REGARDS SUMAN BANIWAL

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  March 17, 2008 at 12:26 am

  #790226

  If yu're using SQL 2005, you should avoid extended stored procs. They are deprecated. use CLR instead.

  What does your extended proc do?

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• sambybaniwal

  SSC Rookie

  Points: 32

  More actions

  March 17, 2008 at 12:54 am

  #790232

  ok tell me in more detail abt clr integration...

  how it use in sqlserver

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  March 17, 2008 at 1:02 am

  #790235

  It's a fairly big topic. Books online has a good coverage. Have a look through that, then if you have specific questions, post them here.

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass