Strange that Data length always gives me 8000 even if the length of the string is above 8000.

Kind Regards,

Affan

Thanks everybody, finally i downloaded the CHM file and it contains the system tables MAP, but one slight comment that it does not contain too much illustration of the fields....

I dont think that BOL contains this kind of detail, if you know kindly mention the topic it will ease my search process. also does some one has those maps with him...

Thanks every body,

Yes, when i installed SP from CD it had a spereate folder and i installed it and now its working fine, every problem is solved. and downloaded SP...

Add on to the problem i want ot ask one question, is there any difference between SQL Service Packs and Analysis Server Service Packs. coz i have found in some...

But i amd trying ot connect it to the enterprise manager of Analysis services and i ma using a single machine and it used to work in case of win2k...

HI,

Please find the example below, hope this helps.

Regards,

Affan

declare @RECORDCNT int

declare @TABLE char(100)

declare @cmd Nvarchar(100)

-- Set the table to be used

set @TABLE = '[ORDERS]'

-- Build the dynamic T-SQL command

SET @CMD =...

Hi,

DTS looks for first 8 rows to make certain decisions about the data to be loaded. also if sheet is not being ended properly then it also puts niull values...

If you are interested in traversing the hierarchy then you can do it with the sampel SP which builds the tree using @@rowcount variable. Hope this helps. If its irrelevant...

Actually i was reading the articles and looking at the examples and thats why i was using the composite keys. If there are other ways of solving thsi problem, i'll...

Hi Steve,

The point is that i want the HH:MM:SS as there could be any transaction of the same id with time difference. e.g. in my fact fact table if i...

One more question related to index that

what are the best guidelines and practices for creating indexes.

Regards,

Affan

Thanks Antares and sorry for the cross post as i thought different people are subscribed to different forums.

So whats the right solution for importing from excel the data having large text in columns.

Thanks jeremy,

actually one of my table takes lot of time as it has 2 big indexes adn i think i shoudl remove those and ltems c what happens, but the...