Use database in sp

[sardinka2]

I am trying to redirect statement to a different db by using Use database statement in sp. however it is not alloud me to do.
What should I use instead?

 

[john76]

Try fully qualifying the table name instead:
ie - <database>.<owner>.<table>

such as:

CREATE PROCEDURE pMyProcedure
AS
  SELECT  Field1 = 1
    INTO  MyDatabase..MyTable

HTH,
John