Rob Kenny - MSFT's Q&A profile

• SQL Server INSERT EXEC Statement cannot be nested

  i have a 3 or 4 cursors, and in the inner cursor i am inserting into a table from a sproc. i keep getting the error An INSERT EXEC statement cannot be nested. heres the actual insert code: set @SQLString = 'EXEC ScoresGetlines ' + cast ( @customerID as char ( 10 ))+ ',' + cast ( @programId as char ( 10 ))+ ',' + '"' + @period + '",NULL,NULL,0' INSERT INTO reportData exec ( @sqlString ) ive tried just a simple : insert into reportdata exec scoreGetLines @customerId,@programID........... that still doesnt work. same error. how can this be sorted ...Show All

• Visual Studio Team System Shared auto-generated stub file in Source Control?

  We have a solution which contains a web service project and multiple client projects.  Rather than using a Web Reference generated by VS2005 we use wsdl.exe to generate the .vb file, then there are some manual modifications we make to that file.  We stick that stub file into a DLL project so it can be shared by the different clients. We have shared checkout for .vb files turned off in our Source Control to make life easier for our dev's.  The web service is split up into multiple .vb files, and multiple dev's may be working on different .vb files at the same time.  Since multiple dev's will be working on the web servic ...Show All

• Visual Studio How can I programmatically load a solution?

  I have see (and used) the rather nice interface for working with Projects.  It is quite easy using Visual Studio 2005 and C# to open a project file (using VCProject from VCProjectEngineObject ) and to get the collection of configurations the project contains.  And from the configuration, it is fairly simple to update virtually any setting.   But what I’m wanting to do starts at a level higher.  I would like to be able to open a solution file and get the list of Projects it contains.  Unfortunately, I’m not finding this documented anywhere (at least not with the other extensibility classes).   ...Show All

• .NET Development Understanding Synclock

  Hi, I am having a difficult time understaing MSDN documentation of Synclock statement. I cant understand what is "expression" for in Synclock dim temp as string Synclock ME temp = "something" End Synclock What do we use "ME" for MSDN says "When the thread reaches the SyncLock block, it evaluates the expression and maintains this exclusivity until it has a lock on the object that is returned by the expression." But I cant understand how does it prevent several threads from changing value of temp I mean I cant understand the relationship between using "ME" with ...Show All

• Visual Studio 2008 (Pre-release) Can i create DataTemplate in code-behind?

  Normally I can create DataTemplate by XAML code but i cannot find the way to create DataTemplate in code-behind. Is it possible Someone has worked on this/ This should work. Havent tried it though. FrameworkElementFactory fef = new FrameworkElementFactory( typeof (TextBlock)); Binding placeBinding = new Binding(); fef.SetBinding(TextBlock.TextProperty, placeBinding); placeBinding.Path = new PropertyPath( "Name" ); dataTemplate = new DataTemplate(); dataTemplate.VisualTree = fef; ...Show All

• Software Development for Windows Vista workflowloadingfailed in asp.net

  web.config: < WorkflowRuntime UnloadOnIdle = " true " > < Services > < add type = " System.Workflow.Runtime.Hosting.ASPNetThreadingService, System.Workflow.Runtime, Version=3.0.00000.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 " /> < add type = " System.Workflow.Runtime.Hosting.SqlTimerService, System.Workflow.Runtime, Version=3.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 " ConnectionString = " Initial Catalog=wwf;Data Source=localhost;uid=sa;pwd=; " /> < add type = " System.Workflow.Runtime.Hosting.SqlStatePersistenceService, System.Workflow.Runtime, Version=3.0.0.0 ...Show All

• Visual C++ VS2005 porting issue

  Hi, I am using VS2005 Beta2 to compile the sources for x64 platform. I am getting following error: >D:\Program Files\Microsoft Visual Studio 8\VC\PlatformSDK\include\mapidefs.h(1142) : error C2371: 'BOOKMARK' : redefinition; different basic types 1> D:\Program Files\Microsoft Visual Studio 8\VC\PlatformSDK\include\sqltypes.h(283) : see declaration of 'BOOKMARK' I tried to refactor code little bit. But it didnt help. I cannot get rid of any one of the listed header file. Is there any solution for this problem Or is this a bug with platform SDK header files THanks, Sujata. Hi Martin, This workaround wo ...Show All

• Windows Forms MessageBox in .NET 2.0

  I am using VS 2005. I am writing a DeskTop application. I want to create a messagebox to display some information. The compiler does not like my using statement: using System.Windows.Forms; Have the classes that encapsulate the MessageBox method changed Here is the compiler error message I am getting: Error 1 The type or namespace name 'Windows' does not exist in the namespace 'System' (are you missing an assembly reference ) C:\Inetpub\wwwroot\StFT\SF\Source\DataServices\Test\test.cs 2 14 DataServices Perhaps you haven't added a reference to system.windows.forms yet ...Show All

• SQL Server performance and tunning

  hi. i have a new question.. how can i make my cube browsing faster since i processed like a million of records into my fact table.. browsing the cube has become really really slow... is there anything i can do to avoid this delay First- try building aggregations for you cube. Million records is not a lot of records.Try to monitor processor utilization at the time of the query. See how busy is your harddrive. See how much memory your machine is using when you browse you cube. Edward. -- This posting is provided "AS IS" with no warranties, and confers no rights. ...Show All

• Visual Studio Report View won't work?

  Where have I lost it I’m just trying to do a real simple report. Dropped a CR Report viewer on a panel on the form. mytable = New DataTable("MyTable") With Mytable .Columns.Add("Field1", GetType(String)) .Columns.Add("Field2", GetType(String)) .Columns.Add("Field3", GetType(Int32)) .Columns.Add("Field4", GetType(Int32)) .Columns.Add("Field5", GetType(Int32)) .Columns.Add("Field6", GetType(Int32)) .Columns.Add("Field7", GetType(Int32)) .Columns.Add("Field8", GetType(String)) .Columns.Add("Field9", GetType(String)) End With MyTable.PrimaryKey = New DataColumn() {MyTable.Columns("Field1")} Put some stuff into the table Dim oRpt as New Crystal ...Show All

• .NET Development All versions of Framework?

  I'm not sure which forum to post this question in ... none of them seem right. We are migrating our 1.1 WinForm app to 2.0. Our app uses a few third-party .DLL components. At least one of these is compiled under the 1.0 Framework. I have two questions, I guess. First, will an app that was compiled under 1.1 run under 2.0 I was under the impression that it would not, so I wanted to load the 2.0 runtime on a clean machine and see if the app would still run ... IOW, I wanted to see by loading the 2.0 runtime (as if I were an end-user), if the 1.1 and 1.0 runtimes were also loaded. (Which is my second question). Unfortunately, I ...Show All

• SQL Server Package still referencing old parameters from an old connection

  I deleted and created a new OLE DB connection string then set all my connections to that string in my components in my SSIS package however below where it talks about EBN_TEMP1, that's an old database table that no longer exists after I unistalled and reinstalled SQL Server on this box.  Why is it still refrencing old stuff   Is there some sort of refresh I have to do on my entire package due to the fact that I 1) Reinstalled SQL Server 2005 2) Deleted an old OLE DB Conenction my package was using (based on an old database that was in the previous SQL Server install) and createad a new OLE DB Connection in my package to point ...Show All

• Visual C++ CGdiObject error C4482

  While compiling a project that 100% clean compiles under VC6, I am getting the following error: e:\program files\microsoft visual studio 8\vc\atlmfc\include\afxwin.h(259) : error C2248: 'CObject::operator =' : cannot access private member declared in class 'CObject' e:\program files\microsoft visual studio 8\vc\atlmfc\include\afx.h(540) : see declaration of 'CObject::operator =' e:\program files\microsoft visual studio 8\vc\atlmfc\include\afx.h(510) : see declaration of 'CObject' This diagnostic occurred in the compiler generated function 'CGdiObject &CGdiObject::operator =(const CGdiObject &)' There is no reference to the line o ...Show All

• Visual C# runing a program from C# code

  Hi I'am trying to make a C# program that can run any program I what to run like IE command prompt and so on but I can't find the keyword that C# uses to start an exsternal exe can anyone help me Thanks Arnar V Arnar, try the method: System.Diagnostics.Process.Start () HTH --mc   ...Show All

• Visual Studio Express Editions Advanced Web Browser

  Hi, I'm a novice at VB and I wanted to know the code for a web browser/IE clone from File to Help to tabs and compatilbity for programs like Google Web Accleartor. I'd really appricate it if someone gave me the code one by one. Thanks.   We are here to help you learn. Why don't you pick a problem and we'll help you solve your problems... one by one. ...Show All