connect othe userthrough procedure from one user ,pass value to procedure

• niranjan.litu

  Grasshopper

  Points: 11

  More actions

  June 24, 2008 at 4:19 am

  #193101

  How i connect to othe user inside a procedure;

  how i pass a table name to procedure at the time of execute the procedure

• hmaharaj

  Right there with Babe

  Points: 781

  More actions

  June 25, 2008 at 12:52 pm

  #834215

  not sure what you are saying but i think this is what you need:

  SET ANSI_NULLS ON

  GO

  SET QUOTED_IDENTIFIER ON

  GO

  create procedure tsst

  @tbl_name nvarchar(50)

  AS

  BEGIN

  insert into @tbl_name

  select * from tbl_2

  END