Mark

You can have SQL 2005 and 2008 in the same computer. If you are planning to install 2008 server components, make sure to install a new instance instead of upgrading...

Ron,

You should be able to find the cause of failure from setup bootstrap log. It should be located at \Microsoft SQL Server\90\Setup Bootstrap\LOG. I would advice to read the latest...

Tried SSIS from 2K5 to 2K8? I mean try till 2K5 using SP and then use SSIS to transfer login?

Thanks folks. Found a trigger

Here is what I am writing...

cusror A

from a list of 100 servers

(

sqlcmd server 1 (execute a command)

)

So now, if second server in the list in unreachable, still the execution will...

Thanks a lot... I will try to explore from my end also and will post here if I get a better way..

Thanks again 🙂

Thank you both for the idea and scrpit. I am working on this..

I understand that the script given will work if I am connected to server only. However the issue...

Nope.

This is the only error I found in Nt log...

IN SQL , it tells backup failed.. See application log for more details..

I guess I found the cause... The box is...

Sounds like setup could not start.. Please refer to setup

Bootstrap for more information.

Windows

Thanks. But the major concern is how can I run a query on a remote server from the local server?

For example, I want to execute SERVERPROPERTY('collation') on a remote server...

Thanks. But we do not have option to intall new application on our box.

So I need to take an approach which will use native technology only and will not...

Yep... Thanks for that.. However I am actually concerened about space crunch.

Could you please advice on that?

I think that is a good idea 😀 Thanks for that

Is there any way to run something like a trace though which will give me some data to justify that...