navrichard's Q&A profile

• SQL Server Hardware issues for database mirroring

  Hi guys, can I know for mirroring, is it both principal and mirror server's hardware spec needed to be same in order to best performance during mirroring I am just curious about it. Thx. Best Regards, Hans NO, they don't have to be Although you might want them to be, as the mirror server should be capable enough to be your primary server when needed Plus, you can set them up identically, or try different settings to see how performance changes It's likd RAID, you don't necessarily need same brand, same model, same size HDDs, but people always recommends it ...Show All

• Microsoft ISV Community Center Forums Excel Advanced filter critera Question...

  Hi Guys, Just a quick one here... use advanced filters all the time and usually with data containing over 30,000 rows. I don't know of any way to use criteria such as 'Not equal to' or 'does not contain' etc. This is available along with many other advanced criteria in the auto filter > custom filter however this only works with upto 1000 rows. Any ideas how i could implement these to my filters I am familair with the syntax used in porgramming like !== etc... Many thanks Hi Andy, yes thats what i am wanting to do but when i put <> into the cell it isn't recognising it   Do i have to add something to it   I type in for exampel <>*Mr* and it should filter out all entries tha ...Show All

• .NET Development Problem with path to DTD when calling CreateDocumentType in C#

  Dear Community-members. I got a problem while creating the document type of my target xml file. I' ve written a console application. If i start it this way in C:\w2d\w2d.exe /f:filename.doc, the call to create the document type for the output xml file fails. The call is: _doc = new XmlDataDocument(); ... XmlDocumentType doctype = _doc.CreateDocumentType("map", "-//OASIS//DTD DITA Map//EN", "../dtd/map.dtd", null); The code tries to find the map.dtd in C:\dtd\map.dtd, but my dtds are at a completely other place. After creating the xml files, i am going to copy them into the right place. For example: c:\myfiles\xmls, where in c:\myfiles\dtd the dtds are placed. The question is now, how to create the documenttype ...Show All

• SQL Server No such interface supported

  I receive "No such interface supported" in SQL Server 2005, when: 1. on server, from my desktop client: attempting to create a maintenance plan within Management Studio without the wizard (with the wizard, works fine) 2. trying to copy, using SMO, an entire database from the server, to my local machine, from again, my desktop client. Any thoughts it's been a while, several installations ago, several months now, since I've had this issue, sicne applying SP1 I believe ... ...Show All

• Smart Device Development error help please...

  this is my error Error 1 Deployment and/or registration failed with error: 0x8973190e. Error writing file '%csidl_program_files%\smartdeviceproj\system.dll'. Error 0x80070070: There is not enough space on the disk. Device Connectivity Component i dnt know wat to do.. when i run the application without datagrid its running good.. but when i place datagrid its showing me this error i dnt know how to fix this.. help me Just as the error message reads - the device has run out of space. This may be because you are referencing some desktop DLL by mistake or because the device has truly run out space. ...Show All

• Visual Basic Perminently update a dataset without SQL command?

  Hi, Is it possible to perminently update a dataset without an sql command. I am trying to edit a data table programmatically, and write my changes to my dataset. Something like this: dim dt as new datatable dt = me.dataset1.table1 dt.rows(1).item(1) = 5 dt.AcceptChanges() me.dataset1.table1DataAdapter.Update(dt) But, after i run this, the table in my dataset does not seem to be updated with the new values. What do i need to do differently Thanks in advance. Pete M Pete_M, DataSet table is stored in the memory and is different from the real table in the database. The following two methods shows the difference between update the dataset and the database tables: Refresh ...Show All

• Visual C++ How to get the local time in miliseconds

  Dear All, using win32 C++, I just want to know what is the usual way to get the local time in the format "hr:min:sec.milisec" Your help is much appreciated regards Bassam Thanks four your respons. What header files should I use in order to implement your code snippet. I have used another way to get the local time, unfortunately, it doesn'r give the milisecond. I wounder if you can help me with a coherent code relevant to mine because it is more understandable and uses the the same header file "ctime.h". My code is: #include <iostream> using std::cout; using std::endl; #include <ctime> const unsigned short timeBufferSize = 12; c ...Show All

• Visual Studio Team System Error on CROSS JOIN functions

  I am getting an error (o_nam5 is not a recognized table or a view hint.) when creating the view below. The function is in a seperate database but I have created it in the same instance along with the validation database. I am hoping this is one of the SQL2005 database functions that haven't been quite been finalized yet. CREATE VIEW [dbo].[AccountAddressCLX] AS SELECT * FROM dbo.ProductCLX clx WITH ( NOLOCK ) CROSS APPLY ODSMetaData.dbo.ShawAddressParser(o_nam5, o_zip) AS Matches; Support for APPLY was just added to recent builds.  Your code should work in our current builds and in the upcoming CTP6; I've verified that we are parsing APPLY now.   &nbs ...Show All

• Microsoft ISV Community Center Forums ms access

  folks..any ideas on how to enable an Ms Access database to send an e-mail when it is updated is it easier to do from within access or via a .NET app ( doing a simple check on the db tables to look for changes) any ideas thanks I know you can do this in SQL Server, in MS Access you could probably use VBA. I'll move this thread to the VBA forums for the experts to help you on this, to see if you can send an email after an update/insert of data in the access database ...Show All

• Smart Device Development System.IO.FileNotFoundException when accessing resources

  I have recently upgraded a project from VS2003 to VS2005 and am having some trouble getting the thing to work. Whenever I try and access an item from a resource file i get a FileNotFoundException. I moved all the strings to the built in project resource file and used My.Resources.ResourceManager to access it but still no joy. I have also seen the error when a form is being loaded that contains a picturebox with an image. again when it is trying to access the resx to get the image. Any ideas This is really frustrating! This is a bug, I believe. I have a very similar issue... I have seen this where the My.Resources.StringName which is defined in VS2005 project just fine, will for NO OBVIOUS reason ju ...Show All

• SQL Server MDX Hierarchy help

  I have two calendar hierarchies in a 2005 SSAS cube. I have to make some calculations based on the date level, but of course, my calculated measures dont work when the wrong hierarchy is chosen. I have tried to look at the .hierarchy and hierarchy() function but am unable to really understand how they work and I haven't been terribly successful looking online for info on them. Has anyone had a similar issue How did you test for the current hierarchy Here's an Adventure Works example, when either the Calendar or Fiscal hierarchy is selected on rows: >> With Member [Measures].[DateHierarchy] as Axis (1). Item (0). Item (0). Hierarchy . Name select {[Measures].[Order Quantity], ...Show All

• Windows Forms How can I make a default value for my DataGridViewCombobox

  Hi guys, Greetings! I setup a datagridviewcombobox programmatically, my problem is how to set a default value for my combo box, how will I do this Thanks, You need to set the index ComboBox1.selectedIndex = -1 means nothing is selected. 0 means the first item in the collection is selected. When I'm adding items to the collection, I do something like this; for ( int i = 0; i < DataSet1.Tables[ "TableName" ].Rows.Count; i++) { ComboBox1.Items.Add(DataSet1.Tables[ "TableName" ]. Rows[ i ][0].ToString().Trim()); if (DataSet1.Tables[ "TableName" ].Rows[ i ][0].ToString().Trim() == DefaultValue) { ComboBox1.S ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. DreamBuildPlay is up!!!

  Now go register!!   Actual contest details to come the week of Feb 5th The site is live and yes we realize there are a few things that haven't quite propped properly. We've got people looking to get these fixed asap. To be clear, yes you will be able to register outside the US as this is a global competition. And yes, the missing states will be re-annexed shortly. Apologies for the wrinkles in the rollout. --dave ...Show All

• SQL Server forms in reporting services

  Is there a way to insert forms in reporting services. If so, how would this be done> Are you using Sharepoint or Report Manager You will probably have to write a custom web app or web part to enter data into a sql database, or use the sql web data administrator tool. There is no facility for creating a data entry form in reporting services. regards, Andrew ...Show All

• SQL Server matrix column grouping

  Hi, I have a requirement from my users to be able to drill down for a single column in a matrix. I've been able to implement drilldown for all of the measures (all columns grouped at the same time) in my matrix but they now want to be able to group different columns independently of each other. In other words they want to be able to group the data in different columns by different things. An example might make my question clearer, the report would need to look like this:  Client Name Sales - Costs + Revenue - Client A + Europe + Middle East + Asia Pacific + $12,000,000 Products + Investments + $12,000,000 $8,000,000 $4,000,000 $10,000,000 $22,000,000 ...Show All