ScottyWakefield's Q&A profile

• SQL Server Who has updated cube's schema?

  Hi, How to obtaine information, who has updated the scheme I can do like this (I am using AMO) Cube.DataSource.ImpersonationInfo.Account But this is only information for data source Thanks! Indirectly means by using additional tools. For example, if you keep the full trace of what was happening on the server, you can analyze it and find out exactly who did what etc. It would be non-trivial task to automate it, but for manual verifications it should be OK. ...Show All

• .NET Development How can I get CPU core clock speed?

  subject You can use the managed WMI classes found in the System.Managment namespace to obtain the # of CPU, speed, stepping, etc... System.Management.ManagementScope ms = new System.Management.ManagementScope( "\\\\localhost\\root\\cimv2" ); System.Management.ObjectQuery oq = new System.Management.ObjectQuery( "SELECT * FROM Win32_Processor" ); ManagementObjectSearcher query = new ManagementObjectSearcher(ms, oq); ManagementObjectCollection queryCollection = query.Get(); foreach (ManagementObject mo in queryCollection) { if (3 == Convert .ToUInt16(mo[ "ProcessorType" ], System.Globalization. CultureInfo .InvariantCulture)) { foreach (PropertyData prop in ...Show All

• SQL Server Can't launch executable from SQL Server Agent Job

  I'm trying to launch an .exe from SQL Server Agent Job and basically nothing happens. I created a job, with 1 step, type is Operating System (CmdExec), run as sql agent service account, and in the command box I typed "start notepad" (no quotes). The job owner is set to administrator. I manually start the job, it processes successfully yet notepad does not launch. I've tried with other .exe's and result is the same. Any advice Thanks! It's part of an I/O process. I create a data file from a db and have to launch the .exe to import the data. I've decided to do it through an SSIS package...But thanks for your suggestions! ...Show All

• Visual Studio Express Editions Buttons to be pressed!

  Hi i am really new to Visual Basdic, and fairly new to programming, but i do know the basics :D. I want to make a basic calculater with the buttons "1,2,3,4,...and +, /,-,*". Now im stuck in the codeing part. I have writen for when one gets pressed... Dim Button1 As Boolean If Button1 = True Then TextBox1.Text = "1" Now this code was written for the texbox that the numbers you press appear in. And looking back at the code, i can see its wrong because it makes button 1 a variable, not a object. So is there a way for somthing like this to happen "if button1 is pressed, make 1 appear in textbox1." Thanks in advance for any replies! You need to read some introd ...Show All

• .NET Development Using a MS Access database

  Hello, I look for some articels and examples about read and write to a MS Acess database(on my website). Diii The following should get you started: Walkthrough: Creating a Web Page to Display Access Database Data ...Show All

• SQL Server Can't see the SQL Server Express Instance on SQL Browser

  Hi All, I am using SQL Server Express to connect to the network using VPN on a local machine. I have done the following.. a.) Enabled the remote connections for the Express Instance and rebooted the machine. b.) Connected to the machine with Express Edition locally and can also connect other SQL Server instances from it to verify connectivity. c.) Yes, SQL Browser Service is running. d.) Firewall is not turned on, so I do not have to configure any exceptions. Now here is the big problem: When I browse for SQL Servers on the network the machine does not show up on the list, i.e "macinename\SQLExpress". I had uninstalled and reinstalled the Express edition and rebooted the machine several times with no luck on t ...Show All

• Visual C# Problems with function ?

  Hi There is a problem I am facing at the moment. I have a base class called A; I have 2 classes that inherits from it . B and C. I have a method with 3 overloads . 1 for A ,1 for B and 1 for C. public void DoSomeWork(A a){} .... On calling the method It goes to the proper one by its parameter. Now, My problem is that I am using a factory to get the proper Object for a specific case and I then assign it in an A object (base class). I then want to send it to the method and expects it to go to the proper one but it goes to the one with A no matter the type returned. I always get "in A1" //Base class A1 a2 = new A2 (); //Call the proper function DoSomeWork(a1); public void DoSomeWork( A1 a ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Translation of 'Getting Started' sample into IronPython

  Just a simple line-by-line translation. This runs out of the box, no special mojo needed. import clr clr.AddReference('Microsoft.Xna.Framework') clr.AddReference('Microsoft.Xna.Framework.Game') import Microsoft.Xna.Framework.Game from Microsoft.Xna.Framework import * from Microsoft.Xna.Framework.Components import * from Microsoft.Xna.Framework.Graphics import * class MyGame(Microsoft.Xna.Framework.Game): def __init__(self): self.InitializeComponent() def InitializeComponent(self): self.graphics = Microsoft.Xna.Framework.Components.GraphicsComponent() self.GameComponents.Add(self.graphics) def Update(self): self.UpdateComponents() def Draw(self): if not self.graphics.EnsureDevice(): return self.graphics ...Show All

• Windows Search Technologies Outlook 2007 search problem

  OK, now I have seen everything. I have tried every remedy suggested to get my search to work. NOTHING!! Then, as a desparate last try I did unselect the data file to be searched. I couldn't believe it. IT WORKED. I had to do this a few times to believe it. Tools >> Instant Search >> Search Options >> "uncheck" the data file you want to be searched Ok, let's take this a step further.... 1. Turn on Outlook logging (Tools -> Options -> Other -> Advanced Options -> Check "Enable logging" -> Reboot Outlook 2. Go to your Notes folder and modify a note. This will re-trigger indexing for that item. 3. Use Outlook's Indexing Status to wait for the count to get ...Show All

• Visual C++ Help Me Please

  Hi im learnig VC++ 2005 and something wierd is goin on with my compiler.. when ever i build and run my projects an error pops up saying "This Application Has failed to start because MSVCP80D.dll was not found. Re-installing the Application may fix the problem." but here is the wierd part the file MSVCP80D.dll is present in my C:\WINDOWS\WinSxS\x86_Microsoft.VC80.DebugCRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_f75eb16c folder i can see it but how come VS is not detecting it and i even tried re-installing the software but it doesn't seem to work can someone please help me!!! Thanks im sorry it does not seem to work here is what i got in the debug dialog Debugger:: An unhandled non-continuable STATUS_ ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Faster rendering method

  Hi, I've been wondering for a while now which method is faster for rendering: > Use a shader (effect) to apply textures, materials, etc > Or use the fixed function for materials, textures, etc and then apply effects as neccisary I find it easier to just use effects for everything. Also is it possible to apply more than one effect to a mesh, on top of each other Or do I have to write a specific effect For example I write a simple effect to texture a mesh and then write a different shader to make it slightly reflective or whatever. Thanks If you know what you're doing, shaders will always be faster. Besides, if you look at the DX10 papers and presentations, they focus almost entirely on ...Show All

• Visual Studio 2008 (Pre-release) WPF Extensions for VS2005 Problem

  I have downloaded .NET 3.0 final edition and installed VS2005 but the WPF extensions setup says it did not detect .NET 3.0. Does anyone know when there will be a release of WPF Exts. that supports the final .NET 3.0 nat1192 wrote: I have downloaded .NET 3.0 final edition and installed VS2005 but the WPF extensions setup says it did not detect .NET 3.0. Does anyone know when there will be a release of WPF Exts. that supports the final .NET 3.0 I have the same problem ...Show All

• SQL Server Simple MDX question

  Hi, This is a newbie question. I want to obtain a top-level aggregate, but filtered by attributes at the lowest of the data. An equivalent example from Adventure Works is this: select [Measures].[Sales Amount] on columns , filter ([Promotion].[Promotions].[Promotion]. Members , STRTOVALUE ([Promotion].[Promotions]. CurrentMember . Properties ("Max Quantity")) <24) on rows from [Adventure Works] This gives the following results: Sales Amount Mountain Tire Sale (null) Half-Price Pedal Sale (null) Mountain-100 Clearance Sale $250,927.70 Mountain-500 Silver Clearance Sale $25,899.14 Road-650 Overstock $49,986.08 LL Road Frame Sale (null) Touring-3000 Promotion $458,091.20 Touring-1000 Promotion $612 ...Show All

• Customer Care Framework Is it free to write and deploy a CCF application?

  Hi, Is it free to write and deploy a CCF application or is there a license cost I already have Visual Studio. Thanks Giles CCF is a Licensed product,  You can contact your Microsoft account rep for pricing. Matt B- MS   ...Show All

• Visual Basic DAODBEngine

  G'day After a VB6 to VB.NET 2.0 upgrade I am left with an IBM DB connection problem. The original version works. The upgrade doesn't. They are both running on the same PC and are configured the same. Original Code: Public dbIBMHost As Database Set dbIBMHost = Workspaces(0).OpenDatabase("", False, False, _ "ODBC;DSN=ValidDSN;UID=ValidUserID;PWD=ValidPassword;") New Code Public dbIBMHost As dao.Database dbIBMHost = DAODBEngine_definst.Workspaces(0).OpenDatabase("", False, False, _ "ODBC;DSN=ValidDSN;UID=ValidUserID;PWD=ValidPassword;") and the upgrade kindly supplied the following Module to define DAODBEngine_definst Module UpgradeSupport Friend DAODBEngine_definst As New dao. ...Show All