Viewing 15 posts - 76 through 90 (of 221 total)
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...
June 20, 2002 at 2:28 am
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
June 17, 2002 at 4:01 am
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...
June 17, 2002 at 3:51 am
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...
February 28, 2002 at 3:38 am
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...
February 28, 2002 at 2:33 am
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...
February 25, 2002 at 2:58 am
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...
February 21, 2002 at 8:12 am
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...
February 21, 2002 at 4:19 am
February 18, 2002 at 5:12 am
February 14, 2002 at 5:17 am
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 * ...
February 5, 2002 at 7:33 am
February 5, 2002 at 2:43 am
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...
February 4, 2002 at 8:15 am
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
January 30, 2002 at 8:44 am
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...
January 29, 2002 at 6:03 am
Viewing 15 posts - 76 through 90 (of 221 total)