Change Data Source to Stored Proccedure in SQL Server 2008 R2

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  November 18, 2012 at 10:14 am

  #284970

  Where do you change the Data Source to a Stored Proccedure in SQL Server 2008 R2?

  In SQL Server 2005 I seem to recall changing it in the Data Tab.

  I can't find where you change it?

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

• Gazareth

  One Orange Chip

  Points: 27737

  More actions

  November 19, 2012 at 4:52 am

  #1560287

  Assuming you mean DataSet - double-click the dataset name, on the dialog box that pops up there's radio buttons for Text/Table/Stored Procedure.