LouArnold's Q&A profile

• SQL Server XPstar90.dll error when trying to create new database

  Please HELP!! I have installed MSSQL server 2005 & MS SQL Server Management Studio Express CTP, but I receive a lot of errors when trying to perform actions in Management Studio. The most immediate problem is the creation f a new Database. When trying to create a new DB, I receive the following error. Can anyone help An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo) Could not load the DLL xpstar90.dll, or one of the DLLs it references. Reason: 126(error not found). =================================== Cannot show requested dialog. =================================== An exception occurred while executing a Transact-SQL statement or batch. (Microsoft ...Show All

• .NET Development Creating processes in a suspended state?

  I need to use Win32 job objects to corral a bunch of child processes. First problem is that there is no concept of jobs in the BCL. Strike 1. Why not Ok - not that big a deal - the stuff I want to do isn't that hard to pinvoke a bunch on - mostly just IntPtr handles anyway. Second problem is that there is no way using the Process class to create a child process in a suspended state so that the handle is valid, but it isn't running yet. Strike 2. What a mess - the existing code I have to modify heavily uses the Process class. and that little addition to the ProcessStartInfo of a bool CreateSuspended would have been so handy. Argggh. The obvious solution is to P/Invoke CreateProcess() so ...Show All

• Software Development for Windows Vista Installing Visual Studio 2005 Pro on to Vista Beta2

  hi I am currently trying to install Visual Studio .net 2005 Pro on to my vista beta 2 machine and its comming up saying that Windows XP SP2 is missing and its a min requirement. could this be becuase i am installing Visual studio that i got free for attending the Ready to launch tour here in the uk warmest regards Kenneth Yes, I was. Find and install Microsoft Document Explorer (MDE) from the disk. From memory it is in a folder called MDE. When this is installed VS will work fine. William Penington ...Show All

• SQL Server How many reports will a DDS (data driven subscription) run in parallel?

  What is the logic behind how many reports that RS will launch in parallel when processing a data driven subscription Observations: Using RS 2000 and a 2 CPU box, a data driven subscription appears to always launch 4 reports in parallel. Using RS 2005 and a 4 CPU box, a data driven subscription appears to also launch 4 reports in parallel. I would have expected RS to take advantage of the larger server to launch more reports in parallel... Is there any way to configure how many reports get launched in parallel What controls the number Thanks for any insight- Matt Update on this thread. RS2005 appears to launch 4 reports for every CPU. So a 4 processor server will launch 16 reports ...Show All

• Windows Forms String to int, Visual C# 2005

  Hey, How do you make the value of this: pictureBox1.Width = (maskedTextBox1.Text); pictureBox1.Height = (maskedTextBox2.Text); an integer becuase I get an error saying can not convert string to int...     Thanks :) Hi, If you missed the first chance(one tick) to write the number in the two mask text box, you'll have to check the radiobutton5(throws format exception), input the number in mask text box and re-check the radiobutton5. ...Show All

• Software Development for Windows Vista starting workflow programmatically using SPWorkflowManager.StartWorkflow method

  Sometimes this works fine and the status of my workflow is "in progress" other times the workflow status gets gets stuck on "starting". The weird part is, when it works fine an exception is thrown when I call StartWorkflow(), when no exception is thrown the status get's stuck on "starting". Anyone have any ideas Thanks, -Somsong Since this post is specific to SharePoint you should ask your question at on one of the SharePoint forums found at http://www.microsoft.com/office/community/en-us/FlyoutOverview.mspx#15 . ...Show All

• Visual Studio Express Editions Form, getting a picturebox to be able to move the form.

  This one may be complicated to explain how I mean. But ill try anyway. Lets say I have a Form thats is FormBorderStyle = None, and I want to make my own drag feature witch will use a Picture box as dragging place. So that the user can place the mouse over the Picture Box and then move the form around. Is that possible That is horrible Renee - not your usual standard at all. Try this: Public Class Form1 Dim DragForm As Boolean Dim XOffset As Integer Dim YOffset As Integer Dim FormLocation As Point Private Sub PictureBox1_MouseDown(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles PictureBox1.MouseDown DragForm = True XOffset = Windows.Forms.Cursor.Position.X - Me.Left YOffset = ...Show All

• SQL Server some nobish tutorials

  hi there Can someone post some very good tutorials about MS SQL 2005 working with c# please Thanks guys.. Yes, I am from the Microsoft SQL Server team. Microsoft encourages all employees to participate in forums like this one. In fact, it is a part of our yearly evaluation. Thanks for posting! Buck ...Show All

• Visual Studio proxygen - using an external type as a base type and generics

  Hi, This is a VSTA question, so this seems the closest forum for it. I'm trying to pass a class MyObjectList: List<MyObject>{} from the host to an Add-In, but (as it states in the documentation) proxygen doesn't support generics. So, changing by base type to ArrayList, proxygen then complains that using an external type as a base type won't work. Great. What is the suggested method for passing a list of some sort from the host to the addin Is there a way to use Add-Ins without requiring a proxy so as to retain all the flexibility of .net code and still have an Embedded IDE that can debug those add-ins in a seamless non-destructive way Many thanks, Alec ... a bit more I ...Show All

• .NET Development .NET class info to controls

  i'm trying to retrieve the name of a class of the .NET framework in a textbox, and it's properties or methods in a listbox, i'm doing this in C#, but the problem is not language, how can i specify this action , i mean, is there some class that contains information about all the .NET classes so i can just pick the info and pass it to the control or how could i do this i'd appreciate any help :) Hi, I think that you may find this article useful, it is explained step by step http://www.dotnetdevs.com/articles/ReflectionDemystified.aspx Hope this helps! ...Show All

• Visual Studio Tools for Office Office 2007 Add-in permission problem

  Hi, I've written an Outlook 2007 Add-in with VS2005. When I used VS to deploy the add-in, everything was fine. Now I tried to deploy the add-in on a machine where no visual studio is installed. I're read this and I placed the dll file to a folder and got through the granting wizard of .Net 2.0 configuration. But when I tried to add my VSTO add-in via COM add-in browser, I got this message: <myadd-in.dll> is not a valid Outlook add-in. What else should I do A couple of possibilities: - Did you use the default Setup project that is included with your Outlook project to deploy the add-in If not, then make sure that you have performed all of the tasks that the Setup project does for you: namely, copying the assembly and the ap ...Show All

• SQL Server Move and Rename File with File System Task

  Hello I want to move and rename a file and embed the date/time into it, so that each time the package runs a new file is created. For example MyFile_20060712_150000.doc. Can someone give me a hint how to do this with the File Systen Task SSIS Control Flow Item Thanks for an early reply Regards Chaepp Hello Thiru I have seen the information before, but I like to add actual Date/Time to the file. Now I have created a stored procedure and it works perfect. With the stored procedure I can use the Execute SQL Task. It's working well. The stored Procedure: DECLARE @TodayDate as nvarchar ( 10 ), @TodayMonth as nvarchar ( 10 ), @TodayYear as nvarchar ( 10 ), @Tod ...Show All

• Visual Studio Team System Can't branch from a 'moved' folder

  When trying to create a new branch in source control, I'm getting the following error: SQL error 2627 Violation of PRIMARY KEY constraint 'PK_tbl_PendingChange'. Cannot insert duplicate key in object 'dbo.tbl_Pendin I've read several posts regarding this error and most seem to be related to earlier Beta versions of TFS. This is not the case for us - we are running the GA version. This branching attempt created five entries is the Application Log, one of which indicated a crash report is being prepared for Microsoft. Hmm... Here is what I did: Migrated a project from VSS to TFS "project A" (no errors) Moved the source within TFS from "project A" to "project B" (no errors) Checked in my c ...Show All

• SQL Server How to display Dimensions with changed name with diferent Client when browsing Cube?

  Basically I am working on Data Warehouse project in which my client has multiple Clients data and I want to give facility when particular client browse the cube he can get only there data. So there will be not only filtering the data required but alose Renaming of Dimensions\Hierarchy\Attributes also. How to do.. One way to restrict to Client to perticular Dimension/Hierarchy/Attribute is Perspectives. But I've read that it can restrict at Member Level but I looks data only Attribute level in my Perspectives. So how it will show Members also. And other one is Naming as per Client ...Show All

• SQL Server Whats the best tool to edit SQL script files? VS or mgmt studio?

  I want to be able to easily browse around my SQL creation script source, so I can quickly jump to specific SPs or UDFs using a document outline or object browser sub-window. I'd also like support for different file extensions (we use .R5SQL for instance), and for these to be recognised as SQL scripts. Note that our scripts contain more than just a single object. ...Show All