For large updates, index the update_id column to improve performance:

CREATE TYPE CustomerUpdatesType AS TABLE (

update_id int identity(1,1) not NULL PRIMARY KEY,

customer_id int null,

title nvarchar(16) null,

first_name nvarchar(32) null,

...

Thank you both for your help. From within BIDS, the environment variable is what I was looking for. I have been in that screen too many times and wasn't paying...

Are you looking to run these as DTS packages on SQL 2008 or convert them to SSIS? I would recommend converting to SSIS if time permits.

For DTS support, check the...

SELECT t.tid, t.Num

FROM

(SELECT DISTINCT Table1.tid, Table1.Num FROM dbo.Table1) As t

ORDER BY t.tId,

CASE

WHEN t.Num = 1 THEN 10

WHEN t.Num = 2 THEN 20

WHEN t.Num = 3...

Is the service running?

Also, how are you connecting? Are you using ".", "(local)", IP address, or the machine name when you connect? They can send you through different paths.

This may help: http://blog.sqlauthority.com/2008/09/02/sql-server-hardware-and-software-requirements-for-installing-sql-server-2008/

Which edition? 64 or 32 bit? Is it compatible with Windows 7?

What version of SQL Server did you install?

Thank you for all the feedback.

I think the issue has to do with the underlying data which would sort of be related to dimension usage. The keys are no...

In the data source view, I can see data when I "Explore Data".

I go to the cube and look in the partitions tab and there is one partition for...

Lowell, I ran the script you had verbatim. I still get the same error message using this sql server login. The issue is who the DOMAIN\USER is. If they have...

The problem is that I don't have a mydomainname\username login on the remote sever. I must connect to that server with a SQL login. It's not the way I would...

It is correct that I am trying to do #3. Unfortunately, I can't get it to work. I get the error: "Access to the remote server is denied because no...

Yes, I have looked at sp_addlinkedserver. I'm not having trouble connecting the linked server though, just restricting it. If I open it up all the way it works but I...

My mistake. It is actually a SQK 2k5 instance that I'm connecting to.