david.r.johnson's Q&A profile

• Visual Studio Team System Schema compare adds existing role memberships

  Hi, We've got a recurring problem with Schema Compare. I can do a schema compare which picks up a new role membership, click 'Write Updates' and then click Refresh and it offers up the same new role membership. As such my RoleMemberships.sql file now looks like this: 1 2 EXEC sp_addrolemember N 'db_owner' , N 'ct\sysminerva-deploy' 3 GO 4 EXEC sp_addrolemember N 'db_etl' , N 'ct\sysminerva-etl' 5 GO 6 EXEC sp_addrolemember N 'db_svc' , N 'CT\svc-ifdsql-ppdm' 7 GO 8 9 10 EXEC sp_addrolemember N 'db_owner' , N 'db_etl' 11 12 GO 13 14 EXEC sp_addrolemember N 'db_owner' , N 'db_etl' 15 16 GO 17 18 EXEC sp_addrolemember N 'db_owner' , N ...Show All

• SQL Server Can't get Instanses of the Report Server through WMI using Non-Administrators access

  I'm trying to conncet to Report Server with Non-Administrator user through WMI in compliance with this document: http://msdn2.microsoft.com/en-us/library/ms365170.aspx When I try to get Instances from MSReportServer_Instance class I get an exception: In my C# project i have an exception: System.Runtime.InteropServices.COMException (0x8000000A) at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo) at System.Management.ManagementObjectCollection.ManagementObjectEnumerator.MoveNext() But, when I give the account Domain Administrators rights all works ok. What additional rights must I give to the account ...Show All

• SQL Server Calculated member with measure and dimension

  Hi, We have a little problem with our calculated member... in our table we have the total amount of a sale in 2 different currencies (US and CAN). In another field we have the currency (1 being can, 2 being US) Now I need to create a measure that will give me all the amount in CAN money and one in US money (depending on how users want to view the cube) but it's not working since my Exchange rate is not a measure and the type of currency isn't either, so the system isn't entering in my case. I tried to do something like this : case [Probill General].[Payeur Fund type] when 1 then ([Measures].[Probill Total] * [Probill General].[Us Exch Rate]) when 2 then ([Measures].[Probill Total]) end But it ...Show All

• Visual C++ A Couple Template Questions

  Hi folks, I have a couple questions about templates. I'm using Visual C++ 2005 Express Edition 8.0.50727.762. Is there a reason why this compiles fine: ------------------------------------------------ template <typename T, int I> struct C1 {}; template <template <typename T, int I> class C1> struct C2 {}; int main (int argc, char * argv[]) { C2<C1> TEST; return 0; } ------------------------------------------------ But this does not (replaced class C1 with typename C1): ------------------------------------------------ template <typename T, int I> struct C1 {}; template <template <typename T, int I> typename C1> struct C2 {}; int main (int argc, char * argv[]) { C2&l ...Show All

• Visual FoxPro Disappearance of Important Data

  Hi experts, I’m using the Visual FoxPro version 6 to implement the database system in the server. The database system is shared by all the users in my office. Sometimes, the server is down. I can see the users are not aware of it and continue working with the system. Is the reason of not capturing data properly and existing data are out of control when the server is down Please guide me. Thank you. Actually question is not clear. bcz if the server is down and if your database is in the server, immediately your click on save button should give an error. even if they are browsing the database and entering the data manually without any program (if the database is in server) then it should give an error. supp ...Show All

• SQL Server Odd Behavior in reverse() or syaltfiles?

  I originally posted this question on dbforums. Does this happen to anyone else http://www.dbforums.com/showthread.php t=1614086 The short of it is, install SQL Server 2000 to a non-default location that has a shorter path than the usual C:\Program Files\Microsoft SQL Server\blah\blah\blah. Say E:\MSSQL8. Now run these queries, and see if you get the same oddities I get: select filename from master..sysaltfiles where dbid = 2 go select reverse(rtrim(filename)), filename from sysaltfiles where dbid = 2 go select reverse(rtrim(filename)) from sysaltfiles where dbid = 2 I can verify this happens here too... that's pretty cool you found this (excluding the headache it causes). select Convert ( varchar , ...Show All

• SQL Server MDX - exclude certain members in a calculated measure in SSAS 2000-2005

  We had to implement measure which shows values accumulated until the current day in month. All days in the current month are totalized except special days like sundays or holidays. These have a flag ("IsWorkday") in the underlying database, which indicates this. The values to accumulate are saved on the first day of each month and data is only saved on the first day of each month. (forecast stuff) In SSAS 2000 we solved this in the following way: We implemented a calculated measure in the cube, which grabs the values from the start day of the month (OpeningPeriod). Then we used an IIF Function and a MemberProperty called "IsWorkday" to exclude the special days from the calculation by setting the calculated measure to ...Show All

• SQL Server Why the node_distribution.PROBABILITY greater than 1 in Clustering algorithm?

  Hi, all experts here, Thank you very much for your kind attention. I am having a question about the node_distribution.PRABABILITY . Some of the attribute values though have a small number of support for the specific node, but why it has a big node_distribution.probability even greater than 1 How can the node_distribution.PROBABILITY be greater than 1 How dose SQL Server 2005 data mining engine calculate the node_distribution.PRPBABILITY for its Clustering algorithm Really confused and need guidance for that. Thank you very much for your help. With best regards, Yours sincerely, Support can be non-integral because cases have a probabilistic membership to a cluster. I believe the other issues are related to the dim ...Show All

• .NET Development <?xml version='1.1' . . .

  ...and .NET Framework > Well, I'll BEA monkey's uncle. It's a deceptively short grammatically incorrect question with an exceedingly short answer. Try it in IE7/FIrefox/VS2005, the answer is apparently "no." Nothing in MSXML 6.0 about XML Schema 1.1 Opinions, gripes, thoughts, theories, and even, "w.t.f. " appreciated. I've read the rationale here . Check. Fresh ink. I understand the burning desire...to break competitor's code. Check. But why would someone in the same company do this now to break their own code That's my current "w.t.f. " Frediano wrote: ...and .NET Framework > Well, I'll BE ...Show All

• Visual Studio Team System Problem creating correct Unit Tests for Exceptions

  I am using VS2005 Team Suite. I created an exception (code sample 1 below) and followed the sample in the CA1032 Code Analysis example http://msdn2.microsoft.com/en-us/library/ms182151.aspx . When I right clicked on the class and auto-generate the unit tests, remove the inconclusive asserts and run the tests ( code sample 2 below) , the test that tries to call the protected method fails with the following error. Test method TestClassLibraryTests.GoodExceptionTest.ConstructorTest1 threw exception: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.ArgumentNullException: Value cannot be null. Parameter name: info. I tried to initialize the SerializationInfo class ...Show All

• Software Development for Windows Vista where can I get the XPS Reference RIP sample code

  Dear all:          where can I get the XPS Reference RIP sample code will microsoft public XPS Reference RIP  sample code         Thanks very much That depends what you mean by "sample code". The SDK is available at http://www.microsoft.com/whdc/device/print/RRIP.mspx . Microsoft can't make the source code to that available because it's not theirs, it's from Global Graphics. There's a contact form to request more information etc available at http://www.globalgraphics.com/purchase/purchasecentre.nsf/becomeOEM - you'd want to select "Harlequin RIP" from the product list. Thanks ...Show All

• Visual Studio Team System Unit test AppDomain names and custom performance counters

  I'm getting a really strange InvalidOperationException exception when trying to invoke a web service method from within a unit test. The message from the exception is "Instance names used for writing to custom counters must be 127 characters or less."  You can imagine my bewilderment at the message because I do not use custom counters in my unit test or in the web service. Looking at the stack I see a call to System.Diagnostics.SharedPerformanceCounter's ctor.  And to my surprise I see parameters like: (string catName = ".net clr networking", string counterName = "connections established", string instanceName = "unittestadapterdomain_forc:_documents and settings_XXXXXX_my documents_visual studio 2005_projects_XXXXXXXXXX ...Show All

• Visual Studio Visual Studio 2005 compiling ASP.Net website to 1.1 framework

  Hi There I have an ASP.Net website written in Visual Studio 2005 and I need to publish the website for a server that only has .Net framework 1.1. Can anyone help please ...Show All

• Smart Device Development Is there any memory leak tool available?

  Hello I'm currently using VLD (Visual Leak Detector) when doing mockup applications in win32. My problem is that I don't know of any tool I can use to find memory leaks for smartphone. Is there anything available Many thanks, Martin Malek Hello Sorry for not being clear from the start. I use unmanaged code and the examples in the article use .NET CF. Since it is not possible to mix unmanaged/managed code for smartphone I can't use the tools provided in the article. Is there any other way to do this Perhaps by using some C++ classes from the SDK or a tool written entirely in unmanaged code Many thanks, Martin Malek ...Show All

• Visual Studio Visual Studio 2005 Empty Projects After succesfull Instalation

  Hi, I have this problem - I have installed succesfully (with absolutely no errors) Licensed Visual Studio 2005 Proffesional on my Windows XP maschine. Then I tried to create a simple project by clicking File>>New>>Project Selected Visual++ then MFC and "MFC ActiveX Control" (I tried later on different project types) - then followed thru the wizard clicking next (selecting all default). Wizard created a project that had no class and there were only few project files - but basically no source code - I have used Visual STudio 6.0 and I never had something like that!! I have updated my instalation with ServicePack1 but that did not change anything - I still have no source files. I'm not sure if that is normal I had the ...Show All