Hello AJ Ahrens,

Do you use neutral accounts or accounts like a_account, t_account? I tried both ways but it's both difficult. Another problem is that some accounts own objects, so I...

Maybe here's some information you can use:

http://www.thin-world.com/MFCommands/chfarm.htm

Maybe I'm missing the point, but I don't see what this has to do with QA. Why don't you use "substring" to make the output more readable? Something like: select...

Why not use "sed" for Windows?

sed "s/^[ \t]*//" filename

Removes all leading whitespaces.

Regards, Peter.

Thanks David, that's what I was looking for! I put it together now like this:

select

 substring(name,1,10) as Databasename,

 substring(filename,1,50) as Filename,

 str(size * 8) + N' KB' as Size,

 str(maxsize * 8) + N'...

You could use the "sqlping.exe" utility. You can ping a host and it returns all instances with versionnumbers and tcp portnumber.

Thanks for your answer, but I tried that before to see what happens. When I try to connect through QA I get the message: login failed because server is in...