Heino's Q&A profile

• SQL Server bar charts

  hi, I would like to have a bar chart with the values of each bar on the top of the bar. How can I do this. thanks, naveen Go to properties on the chart. Then choose the Data tab. Choose the value you want to show the value for and then Edit, In the Point Labels tab I think you will find what you are looking for. ...Show All

• SQL Server Exporting To .xls

  I did a move of reporting services to another server. This was a problem before but someone else figured it out. I have a report which should be around 6MB (it was on the other server) but it exports to .xls at 67MB and will not open in Excel. When I download it as .csv it is about 3-4 MB. I seem to recall something related to headers causing the problem. But that could have been another issue. Please give me any suggestions. I have some other reports which download, slightly larger than I think they should be but they work in .xls. No there are not any images at all. I am using the same database, same rdl file, just renamed the datasource and server name. This is very strange. It is about 1000 rows and 25 columns. Best Regards, J ...Show All

• SQL Server sql server 2005 database tuning advisor how to use it on full database[not a single table or query].

  I want's to sql server 2005 database tuning advisor.To see the possible tuning on a full database.[not a single table or query]. I haven't use this utility before.When I try to run it it ask for a table or workload file. How can i run Database tuning advisor on whole database Can I do it or not  True, it is the best place to start on the new topics. Also review http://www.microsoft.com/technet/prodtechnol/sql/2005/impprfiv.mspx , http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1161285_tax301334,00.html adg=301324&bucket=ETA ...Show All

• Windows Forms listview's header's event or function

  is there any method like below for listview's header.i want a function, that understand which header clicked by user and goes to function..like button! public void button1_Click(object sender, EventArgs e) { }        // this code doesn't work.         private ListView k;         private void k_ColumnClick(object sender,                  System.Windows.Forms.ColumnClickEventArgs e)         {             label1.Text = "sadfsdf";         } Sqnyy wrote: ...Show All

• SQL Server Upgrade issues

  Hi, I am trying to upgrade SQL Server 2000 Enterprise edition to SQL2K5 Developer edition. But it errors out without any detailed message. Is it because, even though the version is being upgraded the edition is downgraded, or could there be a different issue Anyone else facing a similar problem If I have to uninstall 2000 and install 2005 from scratch, what all things do I need to ensure so as no data is lost Thanks, Tanvi. Hi Tanvi, That's not a supported upgrade path (i.e. Sql2k EE to Sql2k5 Dev).  See the following link for supported upgrade paths: http://msdn2.microsoft.com/en-us/library/ms143393.aspx HTH ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Dx 101

  Wat new changes are made when the new version of direct x comes Read all about it here . ...Show All

• Software Development for Windows Vista WF Designer: Glyph provider is not being used by my viewer

  Hi all, I have a web page that displays the workflow image for a given workflow instance id. I based this code on the WorkflowMonitor in the June CTP SDK. To avoid CAS issues, my workflowViewer saves the workflow image as a stream which is returned to the web page for rendering (as opposed to hosting a designer surface directly in a web page). This is working fine, however I am unable to hook in the glyph provider to mark Closed and Executing activities, as is done in the SDK. Here's the relevant code extract: --- IDesignerGlyphProviderService glyphService = (IDesignerGlyphProviderService)designSurface.GetService(typeof(IDesignerGlyphProviderService)); WorkflowMonitorDesignerGlyphProvider glyphProvider = new WorkflowMoni ...Show All

• Visual Studio After installation of windows service, it didn't start automatically

  Hi, I am a newbie in .Net 2005. I have successfully created a setup wizard to install my windows service. However, after the installation, I found that the service is in "automatic" state. I have to reboot PC or manually start it then it will become "Start" state. What can I do in my setup project so that it will be in "Start" state after the installation Please kindly help, Urgent. I will grade you. Thanks In the Installer class for your service handle the AfterInstall event and use the ServiceController class to Start your newly installed service. ...Show All

• Software Development for Windows Vista Advanced Activity Design

  I have an already existing workflow in production that runs a call external method activity only and needs to be enhanced to run an optional invoked workflow on the other side of an added ifElse Activity that runs a new custom composite activity. I have chosen to create a custom Invoke Workflow activity that accepts a TargetWorkflow type at runtime, and I understand I need to use the WorkflowQueuingService to pass the data that the invoked workflow has completed. However the examples I've seen has a standard InvokeWorkflowActivity on a main workflow used and not a custom one. I can't seem to get my Custom one to work with this situation. I keep getting "Invalid workflow parameter value" when I try to Create the Workflow Instance ...Show All

• .NET Development Can you send me the code 2, pleace

  Hi, Im using a custom UsernameTokenManager in WSE 3.0 but it always authenticates when it should'nt. I'm missing something but don't know what.     my Web Service code is: using System; using System.Web; using System.Web.Services; using System.Web.Services.Protocols; [WebService(Namespace = " http://tempuri.org/ ")] [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)] [Microsoft.Web.Services3.Policy("usernameTokenSecurity")] public class Service : System.Web.Services.WebService {     public Service () {         //Uncomment the following line if using designed components         //InitializeComponent();   &nb ...Show All

• .NET Development Automation Error Raised by VB6 App on a .NET component ever since installing .NET 2.0 Framework

  I noticed that a VB 6 app is no longer able to properly call a .NET component exposed with a COM interface that was compile via Visual Studio 2005, it raises an Automation error . Setting the application configuration file to point to the .NET framework v2.0.50727 does not help the situation. However, when the .NET component is compiled via Visual Studio 2003 it works provided I have the infamous application configuration for the VB6 app set to: < xml version ="1.0" >  <configuration>     <startup>          <requiredRuntime version="v1.1.4322"/>          <supportedRuntime version="v1.1.4322 ...Show All

• SQL Server XML DOM Document

  Hi, I created some DTS packages in sql server 2005 and this morning I am getting errors. I am able to open the packes to edit. Following are the errors: Error 1 Error loading MCDMS_Load_Key_OCRepair_Extract_TST.dtsx: Unable to instantiate XML DOM document, please verify that MSXML binaries are properly installed and registered. E:\SCRIPTS\MCDMS_Scripts_System_Test\MCDMS_Load_Key_OCRepair_Extract_TST.dtsx 1 1 Error 2 Error loading MCDMS_Load_Key_OCRepair_Extract_TST.dtsx: Unable to load from XML. E:\SCRIPTS\MCDMS_Scripts_System_Test\MCDMS_Load_Key_OCRepair_Extract_TST.dtsx 1 1 Error 3 Error loading MCDMS_Load_Key_OCRepair_Extract_TST.dtsx: Error loading a task. The contact information for the task is "". This happens when ...Show All

• Visual Studio Team System Deleting all workspaces of a certain name

  I have a build server where different developers log in and update the code from TFS. I'm working on a bat file that will automatically look for a workspace of a certain name on the system and delete, then recreate it as the user that is currently doing the get latest. This is sort of a workaround to the fact that there are no shared workspaces. I have two command line scripts that work well. The first below retrieves a list of all the workspaces with that name. This can be used to see what developer currently owns the workspace: tf workspaces [workspacename] /server:http://server:8080 /owner:* The following will delete a workspace for a specific user: tf workspace /delete [workspacename];username /server:http://server:8080 /noprompt Bu ...Show All

• SQL Server online index rebuild and update statistics

  Hi .. Please advice whether i have to do update statistics along with Index rebuild (online /off line) Thanks in advance This depends on the traffic on your DB. IF its an OLTP/heavily used DB you might keep this for off peak use. Your Index scripts could be scripted to either update or do not update stats. You dont *have to* update stats. Its optional. But generally its good to keep updated stats. Again, depending on your Db size and usage, you can turn Auto Statistics ON or OFF. ...Show All

• Software Development for Windows Vista Registering DLLs with RegOverridePredefkey not working

  The application that I maintain consist of several COM dll and ocx files. When the main exe starts up it loops through all of these files and registers them. In order to do this without administrator privelages it calls RegOverridePredefkey first to map HKEY_CLASSES_ROOT to HKEY_CURRENT_USER\Software\Classes. This works fine under 2000, XP and 2003, but not under vista. How can I make this work to register updates to those files I'd rather not have to change system settings as the client machines are not usually under my controls. I'm noticing the same behaviour, with Vista RC2. The RegOverridePredefKey function no longer works the way it is supposed to. Not only does this break programs that use it for performing per-user COM registr ...Show All