Dietz's Q&A profile

• SQL Server Extended Properties

  I am having some wierd behavior that I can't seem to correct regarding exteneded properties. Via a T-SQL statement, I have added several exteneded properties to a table, for example: exec sp_addextendedproperty N'AP121ID', @value = 'AP121 Primary Key', @level0type = N'Schema', @level0name = dbo, @level1type = N'Table', @level1name=ap121, @level2type = N'Column', @level2name=AP121ID; GO This statement runs successfully. I can even query the sys.extended_properties table and see the entries. However, if i look at the properties of teh table to which I added the exteneded properties, they are not listed. Nor does it allow me to add one via that properties page. Any ideas Thanks... Scott Looks like you are adding extended propertie ...Show All

• SQL Server Service startup failed on SQL Logon, Error: 18456, Severity: 14, State: 16

  Hi, I have a service using SQL 2005 Express database, the service is started automatically on system startup, most of the times it can logon to the database successfully, however, sometimes, I got the following error: "Error: 18456, Severity: 14, State: 16" Any suggestions Thanks in advance! Yuxi 2006-11-22 11:09:49.90 Server Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) Apr 14 2006 01:12:25 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2) 2006-11-22 11:09:49.92 Server (c) 2005 Microsoft Corporation. 2006-11-22 11:09:49.92 Server All rights reserved. 2006-11-22 11:09:49.93 Server Server process ID is 1956. 2006-11-22 11:09:49.93 Server ...Show All

• SQL Server Non-Report Hyperlinks on Report Manager Home Page?

  Is it possible to add hyperlinks to the Report Manager Home Page that link to other aspx pages I have created some associated data entry aspx pages that I want to enable access to from the Report Manager Home Page (if possible). Thanks! Thanks for the replies... The end user is already fairly comfortable with the Report Manager front end, so I am kind of stuck with it as my launching point. The only thing I have come up with is an "empty" report accessible from the main folder that only includes the hyperlinks for the "Data Entry" aspx pages. A little kludgy though. ...Show All

• Windows Forms Adding help to an application

  I have used HelpStudio lite to generate help content but I can't figure out how to add it to my application. The help keeps talking about adding / registering it to Visual Studio, but I just want it to be relevent to the application I am developing. How do I display the help window How do I get the help content being displayed to be the help content I produced Thanks, John Is there a class like Help but that deals with Help 2.x files Help seems to be for Help 1.x (chm) files instead of Help 2.x (hxs files). ...Show All

• SQL Server Connection

  iam using an execute sql task ineed the connection to be daynamic ,changed at run time .. how can i do that Hi, Using follwoing in Script tasks will retrieve value from registry Imports Microsoft.Win32 VarValue = Registry.LocalMachine.GetValue(<Registry Key>) After getting the value you can set this in SSIS variables using Dts. Variables ("DBServer"). Value = VarValue will set the value from registry Thanks Mohit ...Show All

• Visual Studio 2008 (Pre-release) How can I prevent double clicking on a TreeViewItem collapsing/expanding it?

  In another thread we figured out how to respond to double clicks and [enter] events on TreeView items: http://forums.microsoft.com/MSDN/showpost.aspx postid=1023387&siteid=1 But now there's another problem: whenever I do that, the TreeViewItem collapses or expands. Is there a way I can prevent this I've tried extracting the whole Style and ControlTemplate for TreeViewItem using Expression ID, but there are no triggers that respond to double clicks (or Activations as they used to be called in WinForms) that I can tinker with. Any ideas Thanks, Rei Wow that's a lot more complicated than I thought! Usually when things get this hackish you run into a fatal problem along the way. I'm ...Show All

• Visual C# Blocking Related Functions In A Class

  I'm probably missing something very simple, but I'm writing a class for moving a spaceship around on screen. The class is starting to grow very large, and I want to block related functions. Here is an example of what I have: class object3D {         void Rotate(float i, float j, float k) {...}         void ApplyThrust(float u) {...}         void MoveLeft() {...}         void MoveRight() {...}         void MoveFoward() {...}         void MoveBackward() {...}         void MoveTo(float x, floa ...Show All

• Visual Studio Express Editions Trouble with compiling simple C# script

  Hi I am a beginner trying to compile a simple C# hello world script using a command prompt. I am unsure how to do this but have tried typing run then cs.exe or cs and the error comes up - 'cs.exe is not recognised as an internal or external command.' I have also browsed to the .NET Framework in Windows and tried to run this file which opens for a split second then closes. Can anyone explain what I am doing wrong I am running Windows XP SP 2 and Visual Studio 2005 Express Edition Many thanks for any pointers E because you need to give it switches to compile with - read the initial response which contains the switches to use in order to compile your code :-) could I ask - why do you no ...Show All

• Audio and Video Development About the method of loading Original Sink.

  Hi all! Please give me some pieces of advice on  how  to serialize Original Sink to MIG Process.   Because the method of making general IMFActivate doesn't exist, IMFActivate for original Sink cannot be made. I would like you to teach the way of serializing original Sink to MIG Process.   My Best Regards. Thank you for your answer. 1.----> May I return My MediaSink object when IMFActivate::Activate() is called And, though I don't have any more data for IMFActivate, Should I implement IPersistStream::Load() and Save() In the last answer, you advised me that the two methods were options, so ...Show All

• Visual Basic How to create an instance of a C DLL.

  Hi. I want to know about creating an instance of a C DLL and how to use that instance in a VB function on VB6.0. Thanks in Advance.   satya999 wrote: Hi. I want to know about creating an instance of a C DLL and how to use that instance in a VB function on VB6.0. Thanks in Advance. What your asking for is completely possible but these forums are for VB.NET and there are better places to find answers for older versions of VB such as VB6. Maybe the VB6 newgroups - http://msdn.microsoft.com/newsgroups/default.aspx dg=microsoft.public.vb.general.discussion&lang=en&cr=US or the VB6 resource center http://msdn.microsoft.com/vbrun/ or web sites such as www.vbcity.com ...Show All

• Visual Studio Team System Any sign of CTP6?

  Hi all, Can you tell us when CTP6 will be appearing I have a decision to make early on this week on my current project and the answer to this question will affect my decision. I don't expect you to answer but I thought I'd ask anyway. Thanks -Jamie ...Show All

• Visual C++ Error in creating Handle for HandleDestroyed

  I am trying to create a handle for a custom handle when the window is destroyed I am using the code: this ->HandleDestroyed += gcnew System::EventHandler( this , &cheat::HandleDestroyed); I have this placed in the InitalizeComponent event of my windows form. When the compiler reaches this line it tells me that i need to point to a member function. I think I am doing this wrongly, so could anyone please point me in the right direction. Thanks in advance. :-D I worked out that the event that I acctually want to use is OnClosing(): I am using... this ->OnClosing += gcnew System::EventHandler( this , &cheat::OnClosing); Except that the System::EventHandler class uses a different set of objects to the OnCl ...Show All

• Visual Studio Programattically render pdf from ReportViewer

  I have created several embedded ReportViewer reports in asp.net 2.0 (using VB). Love the ReportViewer. Used Cognos SDK up to 3 wks ago, but not any more! When my app's user pushes a button, 8 diferent reports come up in separate browser windows (e.g. Response.Write("<script>window.open('../Reports/rptOversale_Compare.aspx ','_OverSaleCompare');</script>")). What I want to do is have the reports come up in pdf format. Is this possible The ideal objective for this app would be to have the 8 reports come up as pdf inside a tab control, but I can't find any code or direction anywhere on how to programmatically spit out pdf instead of ReportViewer default display. I'll worry about the tab part after getting pdf to ...Show All

• SQL Server Next Measure

  Lets say I have a set of measures that go like this: Date, Payment October 3, $3 October 6, $4 December 6, $5 December 8, $4 My problem is that I need to get the next payment date and amount. So if for example I am standing in October 3, I would have to get (October 4, $4). If I was standing in october I would have to get (December, $9). Assuming I have a measure called [Payment] and a [Date] dimension ([Year], [Month], [Day]), How can I do this with MDX Thanks in advance Both formulas look for the next time period in the Time hierarchy. If the current time period is Year - they will go to the next Year, if it is Month - they will go to the next month. Jan07 is the next month after ...Show All

• Smart Device Development how to create calander and Data saving

  Hi, Thank you for everyone's help first. Again, i got this question in mind that I hope some one can help me with. I am trying to make a program that can record data. The data is a daily bases. I just wondering how can I create a calander to allow the user to get the data that they saved last month or like yesterday Also, I want to save the data in a monthly bases to memory. example: I start using the program on Jan and everyday I did a record. During Feb, I want the program to auto save the Jan month infomation and start a new one on Feb. The data will be save to memory storage and I can access to Jan if I want to. example2: I start using the program on Jan and everyday I did a record. Now is jan 23 and I want to see what I have don ...Show All