Alvin Kuiper's Q&A profile

• SQL Server Pending Reboot Requirement

  I just installed SP2. I wanted to install the AdventureWorksDW database as part of the Database Engine Tuning Advisor tutorial. It said my install was not finished and I had a "pending reboot requirement." I shut down, and 8 different updates ran. When I tried to install the AdventureWorksDW database again, I got the same message. I'll see if there are still more updates to run. We do a pending reboot check to see if we can safely apply a patch. If the flag is present then we block install as recommend that you do a reboot first before contining with the installation. It sounds like that is what you saw. Michelle ...Show All

• SharePoint Products and Technologies SP Designer Change Workflow

  Is there a way on a "Change" workflow using designer to be able to compare the original value to the "changed" value ...Show All

• .NET Development Change conection on the fly?

  I have developed an app with SQLExpress. Can I somehow choose the DB to connect to during run time i.e. I would like to use data in another directory than the application directory. The path is not known before run time. Can I adapt the path during run before connecting Thanks for a hint Hi, I'm having the same problem see this post: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1132655 I cant get it to work Yet. ...Show All

• SQL Server Report Parameters creation via Code

  Hi, I have a report that that needs to be filtered by StartDate, where StartDate is the first day in the week of a specific year. The values will be each week of the year (52 weeks = 52 Start Dates) and the range of years is between 2006 (current year) back to 2003. My questions is how to generate these values for the StartDate parameter. I don't want to define actual database tables to store these values, as it seems like something I should be able to easily generate via some code. After trying it out for while and searching the forum, I'm starting to think I will need to statically store these parameters. Can anyone offer any advice on how to solve this parameter value generation issue Thanks, - Jim ...Show All

• Windows Forms data updates from datagrid control

  i actually want to do the dml operations by using datagrid control.So plz if possible then send me reply when using datagrid control for updating the data with the use of button inside the cells of datagrid control.like if we go to datagrid then right click then property builder then we choose buttons --and then (edit,update and delete) option. Plz tell me with examples and in code as well as design mode steps in details.what all code we have to write for editing data with above mentioned options. Akash Chaudhary PolatPinar wrote: Hi Akash, I am afraid .NET 2003 has no support in design time for your question (I don't know if .Net 2005 does). So you have to do some coding. The datagridview has a button ...Show All

• .NET Development .NET Framework 2.0 question

  I appologize in advance if some of my  questions to the forum is a little out of place. I am not a programmer or developer, just a gamer, system builder, and network administrator of a home network. After installing .NET Framework 2.0, Direct X9.0c's Diagnostic shows that one of the two system.dll files is missing. The one that is listed belongs to 1.1, so logic dictates that it is the one for 2.0 that is missing. However it is in the .NET 2.0 folder! Some other symptoms are that logging into .NET sites must be done manually (being signed in with MSN Messenger does no good), and Auto-Scroll function for IntelliPoint 5.2 does not function. The computer this is on is a new install of all software, updated. This may be ...Show All

• Windows Forms DataGridView contextmenu strip issue

  I have a dataGridView whose columns have a contextmenu strip. When a cell is being edited I don't want to display a context menu on right click. I am using contextMenuStrip_opening event to set the options on contextmenu depending on the row that is clicked. Suggestions will be very much appreciated. for for my DGV contextmenustrip, I use the event: dataGridView1.CellMouseDown+=new DataGridViewCellMouseEventHandler(dataGridView1_CellMouseDown); then in that function I determine if it was a right click and where the click was. So you can easily check to see if that cell is in edit mode and then set the DGV's contextMenuStrip: private void dataGridView1_CellMouseDown(object sender, DataGridView ...Show All

• SQL Server VOTING/RATING SYSTEM: HOW TO ADD POINTS AND UPLOAD SQL VALUE?

  I am trying to build a voting system. Website visitors will rate a pictures from 0-10. This value should update the amount of points already stored is SQL. I think the way to do it is passing the value of a field to a varible, performing the operation and updating the database, but I don't know how to capture a value in Sql and pass it to variable... Does anybody there could post a piece of code or point to a link where I could find this information thanks Jens, thanks again for helping! If you don't mind I would like both. I am really enjoying learning SQL and would like to try different things and decide what to implement. I appreciate your help. Rubens Cunha ...Show All

• Visual Basic Databases

  Hi there, I have my connect to my database alright and sucessfully filtered it. I know there will be only one row left so how do I get the contents out of one of the columns to put in a textbox Thanks, AliQ Hi, In case of using SqlCommand and SqlConnection, you should use OleDbCommand and OleDbConnection. Also change the connectionstring. The rest remains the same. Greetz, Geert Geert Verhoeven Consultant @ Ausy Belgium My Personal Blog ...Show All

• SQL Server Some .Net assemblies cannot be referenced in script task

  I'm creating a script task that needs to reference the Visual Studio Team Foundation Server assemblies, but I'm unable to setup a reference. (Note: the Team Foundation assemblies are part of the VSTS SDK installation.) When designing the script, if I select Project, Add Reference, the .net assemblies for the Microsoft.TeamFoundation namespace are not listed -- even though the assemblies do show up if do the same in a Visual Studio.Net project for C# or VB. I've also tried to add a reference in a Custom Component Set -- View, Object Browser, Browse, Edit Custom Component Set, and selected a specific assembly. But I get the following error: --------------------------- Microsoft Visual Studio for Applications ------------------------ ...Show All

• SQL Server SQL2005 cluster setup failed due to task scheduler and native client

  Hi all, I am trying to setup the cluster SQL server, say ServerA and ServerB. While I start the setup in ServerA, it prompts, 'Setup failed to start on the remote machine. Check the Task scheduler event log on the remote machine.' But I found that there is no remote logon to both nodes and the service task scheduler is running in both node. On the other hand, I try to install the SQL via ServerB, it prompts for valid Native client package 'sqlncli.msi' and caused the setup failed finally. However, the Native client was setup successfully as a prerequisite once starting the setup. Any advise Thanks in advance!! Hello everybody, It's unbelievable!!! I tried for hours.... I was logged on on the second node...Af ...Show All

• SQL Server Variables in Script Task

  I recieve the below error when I attempt to execute a Script Component in a Data Flow Task: The collection of variables locked for read and write access is not available outside of PostExecute. This is the code I used: Imports System Imports System.Data Imports System.Math Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper Imports Microsoft.SqlServer.Dts.Runtime.Wrapper Public Class ScriptMain Inherits UserComponent Public Overrides Sub Input0_ProcessInputRow( ByVal Row As Input0Buffer) Output0Buffer.AddRow() Output0Buffer.BillerId = CType (ReadWriteVariables( "CustId" ).Value, Int32) Output0Buffer.UserAccount = CType (Row.Column0, String ) Output0Buffer.UserS ...Show All

• SQL Server Insert image using clr stored procedure

  I tried to insert a row using a clr stored procedure where a field was a varbinary(max) and the data was a jpg file. The data was truncated to 8000 bytes. A similar T-SQL sp did not truncate the data even though the parameters were identical. With the clr sp I tried varbinary, variant and image for the parameter type. The variant gave an exception. The others worked but the data was truncated. I used sqlpipe.executeandsend. Someone asked elsewhere if the pipe had an 8000 byte limit but was told it had not. Any ideas Thanks, John IMHO, i don't think either of these replies are on topic to the original question, since the original question dealt with a varbinary(MAX) column and effectively a byte ...Show All

• Visual Studio Tools for Office Optional Parameters and overloading in a C# Managed Automation Add-in for Excel

  I have successfully built a managed automation add-in for excel which exposes a couple of user-defined functions that can be called as a worksheet function from Excel - it works great, however.... It now needs to be a bit smarter, by being able to handle an optional parameter, or handle different types of parameters. For example, I would like to be able to have a couple of forms of a function as follows: public double ListPrice(string productid)... public double ListPrice(string productid, string option)... public double ListPrice(Excel.Range r)... public double ListPrice(double configid)... My guess is that COM doesn't understand overloading, because calling one of these forms returns #VALUE (assuming an exception occ ...Show All

• Windows Forms System.Windows.Forms.WebBrowser .GoBack history

  I know about the history folder in the users profile, but is there a way to access the history the the WebBrowser.GoBack() users for UI purposes Like when the client clicks the go back button and at the time of go method is there a way to retrive that url thanks erik Yes...you can create your own history list everytime the user navigates to a url.... store it.... Dim History As New List ( Of Uri ) History . Add ( wb . Url ) ...Show All