Yes, i did that and it executed well.

Yes, I posted the error in my first mail in bold letters.

yes, it exists and the account on which sql service is running has full access to the path.

Oh..thats a better approach. Thanks for the advice.

Thanks for the help guys. I'll update this thread with my findings based the the links provided by you.

Thank you very much, thats a valuable info, I have no idea that PRINT statement had a limitation.

no..actually i need the SQL script to be called from sqlcmd.exe so i have no other option but to use what i said. one solution i found is the capture...

yes, but the problem with no_output is that even if the @cmd fails for any reason, still the result is shown as 'Command(s) completed successfully'

for e.g. Try the below script...

thanks for that info..that was very useful to me.

Sure...i'll check these options as well....

Thanks for the link mate. That helped me a lot.

actually my product requires SQL server express as a prerequisite. So i am doing a silent installation of SQL if it does not exist and give any one or the...

thanks for the quick reply.

actually my requirement is as below...

I have a list of SQL servers, I need to connect to each one of them and get the following details.

1. The OS they are...

I am using windows login...also i am admin on the machine.....I tried with sa as well....