Thanks for the reply Steve... The output file format vaires everytime. Please let me know if your code works for the below scenario that I face.. I have a batch...

As Jeff said, I am not able to get rid of it.. Actually, what happens is, I have a batch file which when executed connected to each server using OSQL...

Yes. I will go for a separate group while installing SQL Server 2005. Tnx for your reply.. I appreciate it...

The cluster type is active/passive. We are not moving to active/active type. We already have sql 2000 installed which is clustered. We are going to install sql 2005 in the...

Any suggestions???

Thanks George.. That script work very well.. But I got an issue.

I run the SQLCMD for named instances too.. Suppose, when i execute my script again a named instance say...

Thanks for the reply & the code as well... 🙂 That was lot helpful.. 😀

@Gsquare..

Thanks for the reply.. In the long run, I will create a view which pulls the data...

thanks again....

I m not good in vbs.. I m hoping to do this using SQL script.. How can i check the version of sql server using SQL CMD...

I m using this...

Thanks for the reply.. Is this a valid statement?

Declare Cur cursor for exec('select js.Job_id, js.name, js.freq_interval from msdb..sysjobschedules js where js.freq_type = 8')

How should i use dynamic sql here?

Thanks!!!

Yes.. I thought of that... But creating a view in 80+ servers is hard task to do.. :w00t:

I thought of using osql to pull data from each and every server...

I am trying to get the backup information (backup job name, schedule etc.,) from multiple servers.. Some server have 2000 installed and some have 2005 installed..

I m using 2 scripts....