Thank you all of you guys and gals to assist. I finally got the solution to my above original issue.

Solution:

Declare @cmd varchar(2000)

set @cmd = 'EXEC ' + @servername + '.'...

Thank you for the try but it gave me the following error 🙂

similar to the on earlier...

The name RemoteServerName.DatabaseName.DBO.sys.sp_executesql is not a valid identifier

Please advise.

I ran exactly you mentioned and got this error

The RemoteServerName.DatabaseName.DBO.sp_executesql N'truncate table DBO.tablename' is not a valid identifier

i tried double quotes and single quote and same error above.

so how would i truncate data in my scenario through T-SQL command? Please...

Lynn Thank YOU so much..... 4 eyes better than 2 ...:-)

David you are absolutely right... I will use this in another task though 🙂

So how can I execute what I am trying to execute above from within SQL Server? Please...

Hello Lynn,

Because I have to exec the same proc many times for different Paths and different Databases in multiple servers. so its easier to use and control variables in a...