You can run John Mitchell's query on a Server Group (right click on folder icon > New Query) within your Registered Servers.

Also check:

Quick and Dirty DR Solution Using Robocopy[/url]

select dbname.dbo.LPAD('88', 4, '0')

returns '0088'

🙂

you mean sql 2005 😉

Thanks!

Nice fast results 🙂

Jeff Moden (7/17/2009)

---

Heh... I know where this one came from because it avoids RBAR 😉

--===== "Space Used on Steroids"

-- If "UnusedKB" is...