var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Running the exec command on the second machine...
I have a query to execute. The query is :-
exec master.dbo.xp_fileexist @nFilePath
This i can execute on the current machine.
But how do i run this one on another machine.
I took the machinename as a parameter and executed like :-
exec @nMachinename.master.dbo.xp_fileexist @nFilePath
But the exec command is not taking this...
Giving me errors.
Now how can i give the second machines name as a paramter and run dynamically????
not sure about this but try using linked server.
I got it...
I have to set the value into a variable of the above mentioned query and then execute the variable...
declare @sql nvarchar(1000)
select @sql = 'exec ' + @nMachinename + '.master.dbo.xp_fileexist ''' + @nFilePath + ''''