Hi, Basically I'm preparing a script to get backup details of all my servers (124 Physical Boxes in a single domain),

Steps:

1. Passing veriable name in @server and storing that script into a variable @query.

2. passind that @query into openrowset();

but when I'm seting connect string in @query like

@query = 'provider string with trusted connection' its showing syntex error on @Password