try using xp_cmdshell to BCP the results to an XLS file. Excel might complain that it is in the wrong format but should still open the file.

exec xp_cmdshell 'bcp "exec...

check sys.database_permissions.

A good trick if you know how to do something with SSMS is to run a profiler trace of your own SSMS spid and you will capture the...

There would not be many situations where you would need to rebuild master; not having backup would be one.

This...

I am a bit confused now. Your first step says:

I took that as you would be doing a physical to virtual every week. will you also be...

P2V should work fine, I have done it once with a database server a couple years ago and if I remember correctly, did not have to restore any databases. we...

I am pretty sure that once you do physical to virtual you will not have to restore the databases but you would need to change name and IP of virtual...

I have a question; when doing a physical to virtual conversion don't all the drives and what they contain get converted to virtual disks thus negating the need to restore...

you could also use a subquery http://msdn.microsoft.com/en-us/library/aa213252%28SQL.80%29.aspx

select company_name,s_post_code

from address

where s_post_code in

(select s_post_code

from address

group by s_post_code having count(s_post_code)>1)

I stated in my original post that the servers table has to be populated manually with the server/linkedservername. All other columns in server table are handled by the script.

ie.

insert into...

the table population is in the script. What part are you having trouble with?

Thanks Jack, that is what I figured would be needed just wanted second opinion.

Thank for the replies.

Supriya, I was able to use your example to get the results I needed.

here is a proc that can assist in moving logins between servers

http://support.microsoft.com/kb/246133

try sp_helptext.

exec sp_helptext 'sp_who'