David Kreps's Q&A profile

• SQL Server AS2005. Strange MDX behaviour.

  Hi, MDX gurus, I have a unexplainable problem with pretty easy MDX. Following MDX queries // select Filter ([Date].[Date]. members , [Date].[Date]. CurrentMember . MemberValue = VBA![dateadd]("yyyy", -2, VBA![Date]()) ) on 0, {} on 1 from [Adventure Works] // select Filter ([Date].[Date]. members , [Date].[Date]. CurrentMember . MemberValue = CDate("11.07.2004")) on 0, {} on 1 from [Adventure Works] provide the same result as expected. This query // select Filter ([Date].[Calendar].[Month]. members , [Date].[Date]. CurrentMember . MemberValue = CDate("11.07.2004")) on 0, {} on 1 from [Adventure Works] returns as expected one member ...Show All

• Software Development for Windows Vista Tracking Events and Data

  Hello Everyone, I am trying to implement the state machine workflow for a order processing system, and want to track events that trigger the state transitions. My workflow consists entirely of the out of the box activities. As state transitions happen on user events, i am passing some user specific data to the workflow that I want to capture (like username, comments etc). Is it possible to extract data from the classes derived from ExternalDataEventArgs and can someone point me to a good example on how to do it Many thanks Matt, Thanks for the quick reply, so would i have to create a custom activity for each of my HandleExternalEventActivity and send the data to tracking service ...Show All

• SQL Server Full-text Index Question

  Hello all, I just created a new Full-text index on a column, and I set Change Tracking to Auto. When I do this, do I still need to have an Incremental Population schedule, or does SQL Server handle the population in the background on a continuous basis when Change Tracking is set to Auto Thanks for your help, Jason See inline. EXEC dbo . sp_fulltext_table @tabname = '[dbo].[Log]' , @action = 'start_change_tracking' GO -- If you have timestamp column on the table, start_change_tracking will start incremental crawl, otherwise, it will kick off a fullcrawl and set changetracking to manual. You should see the index is populated. EXEC dbo . sp_fulltext_table @tabname ...Show All

• SQL Server cannot create jobs on x64

  Hi all, Just installed sql 2005 x64 (DB Server + Client Tools incl. management tools) on a win2003 x64 server and encountered the following problems: 1) Could not create jobs Getting Error: Unable to cast object of type 'Microsoft.SqlServer.Management.Smo.SimpleObjectKey' to type 'Microsoft.SqlServer.Management.Smo.Agent. JobObjectKey '. (Microsoft.SqlServer.Smo) - Tried several different job types, always same result. - Installing SP1 does not help. - Installing with or without Integration Service does not help. Any help is highly appreciated TIA Dan Just as a checkup, have you installed SQLExpress before on thsi machine refer to KBA http://support.microsoft.com/kb/922214 for more ...Show All

• Windows Forms DataGridView new row at first position

  Hi everyone, I need my DataGridView controls to use the very first row for adding new rows. By default the DataGridView control appends a new row at the bottom to do this. I hope there is a way WITHOUT writing an own databinding sub-system. Thanks in advance. Patrick ...Show All

• Windows Live Developer Forums MSN PROBLEM

  ive recently bought a brand new laptop and installed msn messenger ( from the msn site). When i go to sign in it really lags alot, and it never actually signs in... Sometimes i get a error message 80040111 and sometimes it just asks me to try again. Ive tried uninstalling and reinstalling it hundreds of times not to mention deleting any addons or patches. Ive tried to update that DLL file aswell but still get the same message. Windows messenger on the other hand works fine... along with msn messenger on my mates laptop as i have no worries signign into that. Ive also took any firewalls off etc aswell its really pissing me off tbf now aswell.... carnt seen to find anything on net to aid me neither. any help PLEASEEEEE ...Show All

• SQL Server 400: Bad Request

  I am getting an "The request failed with HTTP status 400: Bad Request " Error in Report Manager Webpage. http://servername/Reports The Reportserver itself and reports works fine (http://servername/reportserver). Reports render OK and i am still able to connect to reportserver by management studio. The environment is a W2K3 Standard with SQL 2005 (Build 2153) - and the server is a domain controller. Reporting Service Configuration does not mention any issues - I have reapplied default settings - no change. There are no errors in the eventlog. I need some help - please HANNES I have already checked the following posts http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=284929&SiteID=1 (I did not understend the "RS ...Show All

• Visual Studio In Copy-Modify-Merge can you force a get if local version is not based on the latest?

  I'm switching to the copy-modify-merge model. As I understand it, if the version a file has been checked out against is stale, sourcesafe does the merge on checkin whereas in TFS and SourceGear Vault you are forced to get a latest version and do the merge locally before checking in. The latter seems to me to be a much better practice -- is there a way to get this behavior in sourcesafe In the event that you cannot do this, is there a way (even if through a third party add-in) that I can see a list of local files that I have made changes to that will require a merge on check-in (i.e., files that other users have updated since I last checked them out) At least this would allow me to exercise some care with the files that will be merged on ...Show All

• Software Development for Windows Vista SHFileOperation and 8.3 filenames

  Hi, I'm not a programmer or anything, so I'm quite new to the API and things. I have a complicated reason for needing to use 8.3 filename spec to remove some directories. My function has worked perfectly on 2000/XP, but it returns "2" on Vista. (Vista Enterprise 6.0.6000 N/A Build 6000, x64-based PC ) After looking around, it seems that winerror.h resolves that as "ERROR_FILE_NOT_FOUND". The file clearly exists, and a "dir /x" will give the 8.3 name that I'm using. Also, I believe DeleteFile works with 8.3 names, but not SHFileOperation. Can someone please confirm this for me I hope it's not a silly mistake on my part. (Note: I'm not natively coding these API functions, I'm using a plugin that makes the API c ...Show All

• Visual Studio VS 2005 Addins to right-click menu

  Hello guys, I try to create VS2005 addin to Team Explorer right-click menu. The idea is: When you open Source Control Explorer, choose the project and right-click on it you'll get the menu. You can choose: <Get Latest Version> and etc from this menu. My purpose to add my own command (Ex: Custom Get) to this menu. Most of the topics I've found in Google are describe how to add command to main command bar - like Tools-><Your command>, but I haven't found anything about right click menu. Please help.... Thanks I didn't get the method how to get context menu and add the custom command to it :( Addin wizard by default creates custom command in Tools menu bar:(:( and I don't see the way how to put my command to context menu ...Show All

• Visual Studio Team System How to add new folder to Team Query Hierarchy?

  Hello, I want to create (hierarchy) some folders inside Team Queries to orange the view in team explorer. How can I do this Thank you Unfortunately we do not have a feature to have folders in team queries, but we do know it is a most asked feature. One option is to use documents folder to store your queries as WIQ files. In team explorer you'll see documents as a node and it is used to store various document files, and wiq files could also be stored in a specific hierarchy. ...Show All

• Visual Basic DateTimePicker & Person's Age

  I want to show someone's age on a label (how many years and months he's old) based on what birth date he picks. how can i do that Dark Dominion, Dim diff As TimeSpan = DateTime.Now - UserInputDate Please check the above statement and make the DataTime Type format correct in order to get the right result by calculating. Here is an example on how to customize the DateTime string format: Dim MyDate As New DateTime(2000, 1, 1, 0, 0, 0) Dim MyString As String = MyDate.ToString( "dddd - d - MMMM" ) ' In the U.S. English culture, MyString has the value: ' "Saturday - 1 - January". MyString = MyDate.ToString( "yyyy gg" ) ...Show All

• Visual Studio Tools for Office Custom Assembly Message Driving Me Nuts!

  I'm using VSTO in Visual Studio.Net 2005.  My current project is a MS Word 2003 WordTemplate project.  It uses smarttags to identify autotext entries and to reformat the document when needed.  All the code is running well, and has been debuged.  Here is my problem - that did not start with this project - but keeps reoccurring with all Word Template projects: I have gotten a message, "The Customization Assembly could not be found or could not be loaded.  You can still edit and save the document.  Contact your administrator or the author of this document for further assistance.", a few times.  Usually when I get it I can start a new project and copy and paste my stuff into it.  When I do that t ...Show All

• Visual Studio Express Editions How do I test for nulls in a date column?

  Visual Basic 2005 Express: When a patient record is added to the SQL database table, the default date is being entered, but, if the user deletes it, the program aborts with a: System.Data.SqlClient.SqlException was unhandled   Message="Cannot insert the value NULL into column 'BirthDate'   column does not allow nulls. UPDATE fails. BirthDate is part of the primary key, so, I cannot specify "Allow DbNulls". I added 2 different "If" statements, but neither one of them is catching the condition: If IsDBNull(PatientBindingSource.Current( "BirthDate" )) Then    PatientBindingSource.Current( "BirthDate" ) = DefaultDate End If If PatientBindingSource.Current( "BirthDate" ).ToString = "" T ...Show All

• Windows Forms Draw on top of Image

  Hello. I have a custom control that loads a large image and displays it on screen (using scrollbars). The problem is that I want to draw on the visible part of the image (the part that is currently on screen) and I want to be able to modify the things that I'm drawing (i.e. if I draw a line on top of the image, I want to be able to remove that line later). I did something like this, with the help of this forum: (where Image image = Image.FromFile("picture.jpg"); ) protected override void OnPaint( PaintEventArgs e) {    e.Graphics.SmoothingMode = SmoothingMode .AntiAlias;    Rectangle src = new Rectangle (-AutoScrollPosition.X, -AutoScrollPosition.Y, this .Width, this .Height);    Rect ...Show All