Sorry Shinsu, but could you post a bit more info eg:

Do you have sps installed - eg sp2 for analysis server?

What error message and code do you see?

What does this...

In BOL there is a page which is titled "Features Supported by the Editions of SQL Server 2000" - it has a section for analysis services.

Paul Ibison

Paul.Ibison@blueyonder.co.uk

Norbert - how do you restore to another name? When I've tried to do this, I get the message "The database already exists on this server - do you want...

This is the sort of thing I've used before:

ALTER TABLE [dbo].[TblAuth] WITH NOCHECK ADD

CONSTRAINT [IU_TblAuth] UNIQUE NONCLUSTERED (AuthId)

GO

By the way I cheated to produce this text...

I had a similar problem. It wasn't due to several connections, but rather to scope issues - the transformation didn't have access to the temp table because it was out...

In practice each pc should have two network cards, with a private network setup between them, but this could be missed out in a test scenario. You'll need 3/5 available...

DTS does support transactions, so provided the OLEDB driver also supports them, you could go down this route and effectively issue a rollback on failure. Alternatively, you could use the...

The double quotes are being interpreted as object identifiers ie referring to tables. If you want to use double quotes, you can insert the statement set quoted_identifier off at teh...

You also could use a case statement in the order by clause.

Paul Ibison

Paul.Ibison@btinternet.com

Thanks Andy - I'd forgot this online magazine existed.

Paul Ibison

Paul.Ibison@btinternet.com

Thanks - that'll save us plenty of work.

The original sp was of the form:

select * into #temp from contacts.dbo.tblindustry

select * from #temp

and I've replaced it with:

select * ...

print cast(@no as decimal (10,1)) should do it.

Paul Ibison

Paul.Ibison@btinternet.com

You could use the filesystem object (scripting host). This would be instanciated in an activeX script in a dts package, and would create a new file (FILEA), write out the...

If you do a left outer join on all fields and look for nulls in any of the key fields in cmsemployeetimecompare this should work.

Paul Ibison

Paul.Ibison@btinternet.com

No immediate insights, but are you logged on as the same user doing exactly the same query in QA and through the app? If so, then I'm stumped, otherwise this...