sql server - How to Acess Remote Computer Folders in PS SQLSERVER:\> -

sql server - How to Acess Remote Computer Folders in PS SQLSERVER:\> -

recently came know how utilize powersehll commands executing sql queries mentioned below:

import-module “sqlps” -disablenamechecking $ds=invoke-sqlcmd -query $query -database $database -serverinstance $server -connectiontimeout $connectiontimeout -querytimeout $querytimeout

at time powershell ise output console in

ps sqlserver:\>

i able perform select , update queries without error. problem faced when wanted access 1 of file in remote computer. tried access file below:

ps sqlserver:\> get-content -path \\server\d$\log\app.log

even tried, list files/folders as

ps sqlserver:\> ls \\server\d$\log\

iam getting below errors:

get-content : cannot find path '\server\d$\log\app.log' because not exist. ls : cannot find path '\server\d$\log\' because not exist.

need not say- folder , file exists on server able access same when powershell running without sql module. mean console showing ps c:\user\abc\

sorry long story-- now, simple question! how access remote files/folders when shell in sqlserver console?

thanks in advance!

-raj

you should able utilize filesystem provider explicitly this:

ls filesystem::\\server\d$\log

sql-server powershell remote-access