FoxyNet's Q&A profile

• SQL Server run sql query on multiple databases

  I need to run a same query on 15 different databases and union the results. Does any of the experts know how to do this with good performance Any help is appreciated. Phil....the only reason i posted in T-Sql is because i will be using this query in reporting services :) Thanks Rafael, could you tell me what toolbox item to use for "call the package 15 times, passing each time a different connection for the source..........." Thanks ...Show All

• Visual Studio Tools for Office Unable to find customization

  I have all the files required to run a VSTO app in a folder C:\Test including a manifest 'Test.application'. I create a brand new workbook, manually add 2 custom document properties Name=_AssemblyName Value=* Name=_AssemblyLocation Value=C:\Test\Test.application Save the workbook, close it and open it back up, the workbook attaches to the dll specified in the manifest, everything works fine! Now if I do the exact same thing as a user on a citrix machine, I get an error that the customization is not found, even though I can browse to the folder containing the manifest file. Any ideas I am able to open other customized workbooks as the same user on citrix, looks like it is not able to resolve any workbook that have the _ ...Show All

• Visual Studio Tools for Office Menu Bar - Horizontal Divide

  Hey, should be a fairly easy solution, and its not a life saver, but i've got a customer menu bar in outlook, and i just want to divide buttons, like buttons are divided in other menu bars, such as file and edit. Just can't seem to find it! Thanks ...Show All

• SQL Server Now() function in MDX not returning correct time. GMT vs System Time.

  The time on my machine reads: 9:43 am and I am in Mountain Time (GMT -7) But when I run this MDX script: WITH MEMBER [Measures].[Date] as 'now()' select [Date] on columns from [Sales] I get: 2/1/2007 4:43:12 PM So, it looks like the now() function is returning the GMT time when I'm expecting the system time. Is there a way to convince now() to tell me what the system time is ...Show All

• Visual Studio Express Editions how to Creating a user control

  i want to create my textbox that accept only numeric data as a user control. how can i add textbox events,methods properties in my user control All of these events have protected members whose name starts with "On". You can override them to handle the event before the base control gets it. Or you can just handle the event like you always did before. This example demonstrates both techniques: Imports System.Windows.Forms Public Class NumericTextBox Inherits TextBox Protected Overrides Sub OnGotFocus(ByVal e As System.EventArgs) '--- Select the text so that typing replaces it Me.SelectionStart = 0 Me.SelectionLength = Me.Text.Length MyBase.OnGotFocus(e) End Sub Private Sub NumericTe ...Show All

• Visual Studio Mutliple DSL Installation

  I know there is no support for mutliple DSL intergration yet. But, it will be great, for those ones that are developing the integration "by hand", to have, at least, an only installation project. There is a way to achieve this with the current version Thanks in advance... You would need to aggregate multiple MSIs into a single one. You can do so via writing your own setup.exe bootstrapper. If you check out major authoring tools on the market, they provide a bootstrapper which does what you want. HTH Patrick ...Show All

• Visual Studio Steps to fix error 32003 for Visual C++

  This information was taken by Looooooka . I just make this information easier so people can understand it. Step 1: Go to My Computer Step 2: Move your cursur(mouse) to the File Edit View Favorites Tools Help shown on the top of address bar and the back button. Step 3: Go to Tools and click Folder Options... Step 4: Go to the View tab / Advance Settings: Step 5: Go to the very bottom and you would see Use simple file sharing (Recommended) Uncheck it. Click OK Step 6: Go to your Microsoft Visual Studio 8 Folder in Program Files Step 7: Locate the file you had problem with for example (vsvars32.dat, sdkvars.bat , etc.) Step 8: Right Click on the file and go to Properties and go to the Security Tab. Step9: Find your user name and chec ...Show All

• SQL Server deriving a new column from another derived column

  In a Derived Column data flow transformation, why can't I refer to a derived column (added in that same transformation) in the expression for another derived column It seems I am forced to chain 2 DC data flows, just to do something as conceptually simple as: a = x + y; b = a 2 On a related note: Can I define a variable that is scoped to each row Can I bind a variable in an expression to avoid creating a new row, e.g. let a = x + y; a 2 as the expression for new row b   Kevin Rodgers wrote: I haven't used the script component before -- I haven't even written any scripts.  Could you show me a simple example of generating row accessors etc. as you've suggested Thanks! Just add a script ...Show All

• Microsoft ISV Community Center Forums Ideas for storing results from multiselect listbox

  I need to store the results from listbox where the user may make multiple selections, any suggestions Hi Did not realise that you longer term storage, I was thing of short terms storage for VBA use. If possible us Access to store your data. Access can be used from any office app in VBA. You can also use an Excel sheet and use AODB to access it as a table; I am sure Derek Smyth replied to a post with an example of doing this in this forum. ...Show All

• SQL Server Mirroring Partial Failover

  I'm testing mirroring in a high availability mode and getting some odd results. If I kill the SQL Service (or reboot the machine) fail-over works quickly and correctly. If I unplug the Network cable though I will get some of the databases failed over and some of the databases will either be Mirroring / In recovery or Principal / In recovery and never go live. Right clicking on them and going to properties lists there error that the database is unable to communicate with the Partner or Witness. The databases that this will occur on seem to move around (i.e. it isn't always the same databases, but will often be many of the same databases). If I reboot the databases that will not fail over tend to change fairly dramatically. I've seen instanc ...Show All

• Visual C++ Running a very simple Win32 app... / VS2005pro & MFC: Same thing?

  Hi! I have installed VC++ 2005 Express and the Platform SDK according to the instructions on MSDN: http://msdn.microsoft.com/vstudio/express/visualc/usingpsdk/default.aspx Compiling and running the following program on the dev computer works like a charm: http://www.winprog.org/tutorial/simple_window.html I then changed to release-mode, turned off debugging in the project properties and copied the .exe to another computer without VC++ 2005 Express on. I pretty much expected problems, so I wasn't very surprised when I got the error message saying that there was something wrong with the program configuration, like the one here: http://forums.microsoft.com/msdn/showpost.aspx postid=23371&siteid=1 I have since then combed this forum and ...Show All

• Visual C# Easy way to copy a DataTable

  Is there no easier way of copying a DataTable than this int i = 0; foreach ( DataRow newRow in newTable.Rows) { DataRow drCopy = oldTable.NewRow(); drCopy.ItemArray = newTable.Rows .ItemArray; oldTable.Rows.Add(drCopy); } This returns an empty table: oldTable = newTable.Copy(); Hi; Usually DataTable.Copy() works fine for me. Try doing newTable.AcceptChanges() before doing the copy. If you need to copy only the structure then use DataTable.CLone(). Shivam ...Show All

• SQL Server Interesting article comparing SSIS to Oracle Web Builder

  http://www.tdwi.org/News/display.aspx ID=8100 Yeah, Sunopsis looks like a good tool. We have been talking to them lately as well. They preach the gospel of ELT rather than ETL which means they're all about using the power of the database and that is a bit closer to DTS than SSIS (that's my take on them anyway). Sunopsis is alot more adanced than DTS though. -Jamie ...Show All

• SQL Server what errors normally should i log for my SSIS package?

  I got an SSIS package that first "truncate the product table" then populate the table with new rows....if there is an error then i will invoke the send email task. However in the "truncate the product table" task, the sql i put "truncate dbo.product" instead of "truncate table dbo.product" but this error is not captured in the text file that I m going to send an email to the appropriate personnel. Under logging, and when i go into "truncate product table" tasks , "Details", i saw "OnError", "OnWarning" and other error handlers...which should i tick in order for the text file to ONLY show errors I encounteered during the running of the SSIS packa ...Show All

• Visual Studio 2008 (Pre-release) Are there tools to convert a Windows application (.net 2) to WPF windows application

  Are there tools to convert a Windows application (.net 2) to WPF windows application. ...Show All