Search results for query: *

Thank you for the code. It really is a big help

jebenson... I'm a newbie on vb.net. Got any good code snippits to share? zmrabdulla... sorry no autonumber id column. I just need to do a movelast, read it, then delete it, then do a move movelast again.

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...

I forgot to mention, The data source for the pivot table is an Analysis Server 2005 cube. Jeff

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 -...

Here is my work around.... Private Sub Command6_Click() On Error GoTo Err_Command6_Click Dim stAppName As String Dim stFolder As String Dim fs, f Set fs = CreateObject("Scripting.FileSystemObject") stFolder = "\\waterloo16\shared\" Set f =...

yes the path does exist. Try changing the path or share name to one that doesn't exist. What will happen is that it will open windose explorer to your root c: dir

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"...

Thanks!! The work around is messy from a users stand point though... Most of my users will never grasp what or why they will need to do that. sigh.....

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

Thanks. I figured so after fussing with it.

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...

The log file has grown from 40Mb to 135Gb in the last 15 hours...... I wish I knew where to set the top end. If I did I'd just grow the thing manually. Some thing is causing the transaction log to not truncate on the check points.

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]

Very VERY Nice. Of course I read this post after I had half writen my own version of an auto grow sp... No matter this ggives me that elusive % free space :) Thanks and heres your star

An interesting side note: When runing the code you sent me; All but two of my db's report a growth of 80KB!! In reality almost all of my db's are set to 10%

Also ... where did you get some of that info on the sysaltfiles table? I looked it up on the BOL and it gives no info on the column "Status". Hence I can't read into what or how you got the "log only/data only" flags baised on the 0x40 in the status column.

Wait, you're saying to set some upper limit for my dbs and monitor when I'm within say 10% of full. So I have a 100gb db. I set the MaxSize to say 120gb. (20% free space) I run a script nightly to watch for the 10%. If 10% then we branch to a script that will force the increase the db's...