Search results for query: *

Hi, I'm trying to get that good old "movelast" functionality with the datareader in vb.net. I understand that this is a forward only dataset. What I need is the last record in my retrieved data set and then the one prior to it etc. I can find no fuctionality in the datareader that will allow...

Hi all, I need to know how to use the NAME property when I use the getpivotdata function. Here is an example of the issue: Key value = "BMX" Name vale = "BMX BIKES" Here is what excell generates when I create the getpivotdata function: =GETPIVOTDATA("[Measures].[Extended Price USD -...

Hi all, I need to know how to use the NAME property when I use the getpivotdata function. Here is an example of the issue: Key value = "BMX" Name vale = "BMX BIKES" Here is what excell generates when I create the getpivotdata function: =GETPIVOTDATA("[Measures].[Extended Price USD -...

This code throws the error " Bad filename or number" at the arrow. The path does exsist on the remote pc. It does work if I use a local folder though. Any suggestions on how to get around this? Dim stAppName As String Dim stFolder As String stFolder = "\\waterloo16\shared"...

Hi, I have a set of dims; YTD, MTD, etc that are basised on MDX queries. These do NOT show up in Excell 2007. But they do show up in Excell 2003 and in the AS Browser. Any Ideas? TIA Jeff

Hi all, I have 2 calc'd members one that has "#,#" as its' format string and another that has "percent" I view the data 3 ways: Excel 2000 Excel 2005 The cube browser. The data for the "#,#" is presented as follows for each browser: 1234.56789 1,234 1,234 The data for the "percent" is...

Hi. I have a db that has the following settings: -truncate on check pt. on -recovery mode simple -it is not published for replication -auto shrink false -auto close false -auto create stats true -auto update stats true We are loading the db using an ETL tool called Data Inegrator. It has a...

What does the &[0] mean? I can't seem to find a reference to the & in BOL TIA [Dates].[Intl Model Year].[Fiscal Month].&[0]

I get the following error message when i try to build my cube. I have plenty of space on the drive where the cube is defined, but a limited amount of space on my OS drive. Is there any way to get AS2005 to use temp space on a non OS drive? TIA The following system error occurred from a call...

Hi, How do I move a cube from 2000 to 2005? I have tried the migrate database, but get errors. I can't even get the FoodMart2000 to work... TIA Jeff

Hi, I got the following message in my sql logs about 2 weeks ago. Autogrow of file 'InventoryMart_Data' in database 'InventoryMart' took 825844 milliseconds. Consider using ALTER DATABASE to set a smaller FILEGROWTH for this file Should I: A) Manually grow my files when they get to X% B) Set...

What is the SOP for moving my tempdb. I want to place it on a different drive. Can I do this with out restarting SQL Server? Version is sqlsrv 2000 TIA Jeff

Hi, I'm tring to use the copy db wisard to move a db from 2000 to 2005. I keeps failing and giving me no real clue as to why. This is what I see in the event viewer: There is a reference to a db called "salesmart". This is not the db I'm trying to transfer. But it is used in some of the view...

I was running a database defrag indexes script this weekend and got a several I/O errors on the log file raid set. Questions: Has this ever happened to anyone out there? Does Drefraging the indexes drasticlly increase my log file size? (simple recovery model) TIA

Anyone have a scrip that will defrag all the indexes in a db? tia

Hi, I'm trying to drop my PK. Here is the code I'm using: alter table japan_rep.dbo.whm09_2 drop constraint PK_whm09_2 There are only 56 columns in the table and 2 fields. The table is not being used. I have let the above sql run for 10 minutes without completion. What am I doing wrong...

Hi, I'm replicating a 2005 db to a 2000 db. On the pub I set to false every property. ie copy indexes, copy keys, etc. Yet every time I run a snapshot the replication fails with the error, primary key already defined. I have to drop the primary keys on all my subs tables and re-run the...

Hi, I need to use the result from one query to define the name of the field to use in the surrounding query. The inner select stmt returns the field name (dcEt5) select (select Cost_Field from dbo.Cost_Field_Lookup where MonthNumber = datepart(m,getdate())) from dbo.whm03t This just...

Hi, How do I defrag all of the indexs in a table? If I leave the index part of the dbcc indexdefrag statment off I get an error. TIA

Hi, Can I do this: I need to add a second subscription to a database that already has a subscription. The second sub will replicate 3 new tables to my db. I keep getting the error when I do this "Subscription already exsists" I really don't want to have to drop my existing sub and recreate it...