Check the records on your DNS server, or run nslookup against the IP addresses and hostnames locally on each server.

It's probably that there is no reverse look-up available for the...

"is it possible to have the read only database/snapshot on another server "

Yes.

"How often does the snapshots have to be done/can it be real time"

The idea of a reporting server...

The package migration wizard is a starting point, you can also try the Execute DTS 2000 Package task, but there's no gaurantee it'll work as some functions have no mirror...

"hen I try and use the copy wizard it fails because it tries to list the available databases on the hosting server and my login doesn't have sufficient access"

Right, if...

Thanks for the clarification - basically, no.

Using a single user account is fine, but the application needs to manage permissions, not SQL server. MS profer using a single account only...

With copy database wizard you can

"Pick a source and destination server.

Select one or more databases to move or copy.

Specify the file location for the databases.

Create logins on the destination server.

Copy...

Well, we don't know what access you have.

How about the import wizard?

"Our mandate is to monitor the DBA's and other accounts with Admin and Owner rights and privleges."

There is no native way of doing this - by nature the sysadmins can...

Just for continuities sake, I don't see anyone here describing requirements, I see them offering solution (or solutionizing in management speak )

Most...

"The database currently has a SQL login for each user and each user is a member of a specific role which is applied to each Stored Proceedure & View....

Okay this can be simple or complex:

Simple

Use windows authentication. Ctrl+Alt+Del > Change password

Authentication protocols, password complexity and encryption is handled for you.

Not so simple

Upgrade to SQL Server 2005, use...

"I'm now getting this error "Cannot generate SSPI context" "

Try doing the work of adding users through the server console, not any kind of remote admin tool like RDP or...

Tell them thanks, but you will grant them access if you need their help.

They can always apply for a job in production support if they want - offer to pass...

"Can I have some sort of server-wide user that I can activate in my triggers? Any ideas on how to implement this are appreciated."

Absolutely, sp_addlogin creates a server login, not...

I beg to differ. The poster has one server with two databases, not two servers.