Use the script below

IF EXISTS (SELECT 1

FROM INFORMATION_SCHEMA.TABLES

WHERE TABLE_TYPE='BASE TABLE'

AND TABLE_NAME='tablename')

...

Why dont you shrink the log file by using the following command

USE DatabaseName

GO

DBCC SHRINKFILE( , 1)

...

Executing a stored procedure on another database / server is very easy: follow the following steps:

1. if you have to execute stored procedure in the same server but in different...

The first thing to remember is that the data to be passing in the Stored procedure must be of same datatype as declared for the particular parameter, and if not,...

Try to use the Server name before the table name: as

[ServerName].[schema].Table