SELECT DISTINCT

A

,(SELECT t2.B + ' '

FROM (SELECT A, B, ROW_NUMBER() OVER(PARTITION BY...

jpSQLDude (3/8/2012)

---

Chrissy321 (3/8/2012)

---

>>and then in SSIS I can also put the farm name in another column

Can you use the extended properties of a database.. Right-click on the database and go...

Chrissy321 (3/8/2012)

---

>>and then in SSIS I can also put the farm name in another column

Can you use the extended properties of a database.. Right-click on the database and go to...

Why don't you just use powershell to get the instance + db names and load them into a database table?

Do a google search on SQLCMD

What have you got so far? Have you lookied into http://msdn.microsoft.com/en-us/library/ms219082.aspx ??

Just keep in mind that the default PS execution policy is restricted so you will need to get a sys admin to change it for you. Also, to create a...

Something like this should work for you..

$con = "server=localhost;database=YourDatabase;Integrated Security=sspi"

$cmd = "select * from dbo.YourTable"

$path = "c:\Rpt\MyReport_" + $(get-date -f yyyyMMdd) +...

Powershell + windows scheduler?

Brilliant! Thanks for your time and have a good week!

mohammed moinudheen (1/17/2012)

---

We are having around 100 servers and we need below information

1) Find number of databases in each instance

2) Find on which date last backup happened

3) Get the location...

or just right click on instance/reports/schema changes history

http://www.sqlservercentral.com/Forums/Topic1005254-391-1.aspx

indeed this should be UNPIVOT.. cheers Suresh.

Not supported..use Visual Studio 2008