title: How to execute store procedure for another DB?
body: <p>I have a stored procedure that should be able to be executed on any table of any database on my MS Sql Server. Most of the combination of EXEC and USE statements didn't result in anything. Here is the stored procedure:</p>
  
  <pre><code>CREATE PROCEDURE [dbo].[usp_TrimAndLowerCaseVarcharFields]
  (
      @Database VARCHAR(200),
      @TableSchema VARCHAR(200),
      @TableName VARCHAR(200)
  )
  AS
  BEGIN
      DECLARE @sSql VARCHAR(MAX)
  
      SET @Database = '[' + @Database + ']'
      SET @sSql = ''
  
      -- Create first part of a statement to update all columns that have type varchar
      SELECT @sSql = @sSql + COLUMN_NAME + ' = LOWER(RTRIM(' + COLUMN_NAME + ')), ' 
      FROM INFORMATION_SCHEMA.COLUMNS 
      WHERE DATA_TYPE = 'varchar'
      AND TABLE_CATALOG = @Database
      AND TABLE_SCHEMA = @TableSchema
      AND TABLE_NAME = @TableName
  
      SET @sSql = 'UPDATE ' + @Database + '.' + @TableSchema + '.' + @TableName + ' SET ' + @sSql
  
      -- Delete last two symbols (', ')
      SET @sSql = LEFT(@sSql, LEN(@sSql) - 1)
  
      EXEC(@sSql)
  END
  </code></pre>
  
  <p>Please, advice what I have to do to execute it on [OtherDB].[TargetTable].</p>