the default instance name will be what ever you specify in the "SQL Server Network Name" on the "Instance Configuration" screen (same screen you choose default or named insatnce)

well lets give this a try.

run the following in SSMS when you are logged in to your remote mobile client

SELECT session_id,login_name,host_name

FROM sys.dm_exec_sessions

where session_id > 50

it...

I enabled server authentication and made a strong PW for the 'sa' account. (why i enabled SA, beacuse I thought to remotely login from other networks off site, I needed...

since...

I don't think you will be able to have SSIS 2008 and 2008 r2 on the same box as SSIS is shared across major versions. The Database engine, Analysis servers,...

here you go

http://lmgtfy.com/?q=t-sql+grant

Might have been a bad plan in cache on the day it was running bad and that plan got flushed out and a correct plan was created the next day.

you...

I think you need the "Process database" permission to be able to refresh the cube.

http://technet.microsoft.com/en-us/library/ms174786.aspx

Here you go

SELECT total_physical_memory_kb

FROM sys.dm_os_sys_memory

RAID 10 would have the best performance.

check this out although i think it's a moot point because it would require you to change settings on the 2000 box

http://support.microsoft.com/default.aspx?kbid=318605

have a look at this http://sqlblog.com/blogs/roman_rehak/archive/2009/05/10/issue-with-64-bit-sql-server-using-sql-2000-linked-server.aspx. not exactly the same error but same symptom.

I believe it is correct to say SQL Server 2008 R2 RTM because it is a different version. you cannot apply the same Service packs or cumulative updates to both...

you have to qualify the database in the query with a ?. you can also load the result into a table to make them searchable

CREATE TABLE #tmp(dbname VARCHAR(256),username VARCHAR(256))

INSERT #tmp...

this should get you what you want per database (without excluding any users)

select name from sys.database_principals

where type in ('S','G','U')

give it a try with sp_msforeachdb and post back if you are...