Aleks K's Q&A profile

• SQL Server Moving from 2000 to 2005: issue Accessing cursor returned by sp

  I have a number of triggers that call a stored procedure that returns a cursor. The triggers then use the results of this cursor to do other actions. My problem is that this works fine in SQL2000 but just won't work in SQL2005. When I try to access the results of the returned cursor, I get an error -2147217900 could not complete cursor operation because the set options have changed since the cursor was declared. If I port the code containe ...Show All

• SQL Server Indexed View issue w/ Duplicate Key Error on an update to an underlying table

  This is the error: Server: Msg 2601, Level 14, State 3, Line 1 Cannot insert duplicate key row in object 'CandViewONLYIndexed' with unique index 'CI_Cand_Indexed'. The statement has been terminated. OK ... let see if I can explain this coherently - lol for simplicity lets say my updatable view(UV) consists of 3 underlying table (A,B &C) The index, being 2 fields, on the UV consists of one uniqueidentifier from table A and one fr ...Show All

• Visual Studio Team System Team Build - Security

  Hi, we would like to implement multiple team-build types, but only certain users must be allowed to execute certain team-builds. I have not found a way to ristrict which users may execute a specific team-build. Will this be an RTM feature - or must we use alternatives for all restricted Team-Build functionalities The TeamBuild report shows who the build was was requested by. This is in the Requested By row in the Summary section. This name ...Show All

• Visual Studio Problems printing to network printers

  I am using SQL Server Reporting Services 2005 with SP1 installed. I am also using Visual Studio 2005 and the ReportViewer control. The application is a Winforms application – using LocalReport. Report property is set to 11In Width and 8.5In Height (should be landscape). All prints are performed by clicking the print icon, either on the report designer Preview tab or the ReportViewer toolbar. In all cases, the print dialo ...Show All

• Windows Forms TreeView XP style

  I have managed to get XP Styles in my app (its taken a long time to figure it out) but now the treeview doesn't seem to look right.  It starts off with a Win98 style scroll bar and once I resize it the scroll bar turns  ...Show All

• Visual Studio 2008 (Pre-release) my vs.net version

  i have Microsoft Visual Studio 2005 Version 8.0.50727.42 (RTM.050727-4200) Microsoft .NET Framework Version 2.0.50727 Microsoft Visual C# 2005 77626-009-0000007-41370 Microsoft Visual C# 2005 and I run Install Visual Studio IDE Support.cmd from \Program Files\LINQ Preview\Bin and completed successfully but my Visual Studio IDE still does not suuport so please help me I know that I am a disturber man I am sorry Please help! ...Show All

• Visual Basic VB6 TextWidth vs .Net MeasureString

  Ok - this should be simple - and it should work. I've been strugglingly for 2 hours to get this right, so I decided to whip up two simple examples to see if I could get the same figure from both VB6 TEXTWIDTH and .Net MEASURESTRING. In VB6 - I put this code into FORM_LOAD: Code: Private Sub Form_Load() Form1.FontName = "Times New Roman" Form1.FontSize = 10 Debug.Print Form1.TextWidth("abcdef") End Sub Returns a TWIP value of 54 ...Show All

• SQL Server Keep getting Virtual Memory errors

  Hello, I am wondering if there is a way to solve a virtual memory error We randomly get the following error when trying to run sycn over the http websync. Some clients have 512 MB running sql express, others are full instances that have 1.5 GB. The merge process could not allocate memory for an operation; your system may be running low on virtual memory. Restart the Merge Agent. Is this the error thro ...Show All

• Windows Forms How to get DataGridViewComboBoxColumn's selected value for validation?

  Hi. I have a bound DataGridView with a DataGridViewComboBoxColumn. I want to validate the value the user selects.  I'm working in the grid's CellValidating() event handler. How do I get the newly selected value of the item selected in the combobox    In the grid's CellValidating() event handler the DataGridViewCellValidatingEventArgs "e" parameter gives me the previous combobox value which is useless in t ...Show All

• SQL Server Package runs fine from BIDS, but same box running from dtexec gives "insufficient product level" error

  Running eval. edition of Sql Server Standard 2005. "Insufficient product level" error is thrown during validation phase of an OleDBCommand data flow task. This task type is not licensed in Sql Server 2005 standard The component runs a very simple sql update statement against a one row table in Sql Server 2005. If it works from BIDS, should it not work from dtexec.exe on the same box Does dtexec run under the security context of the logge ...Show All

• .NET Development How do i implement CustomCollection

  How do i implement CustomCollection I have Custom object Called Customer public class Customer { private string name = string.Empty; private string age = string.Empty; public string Name { get{return name;} set{name = value;} } public string Age { get{return age;} set{age = value;} } public Customer() { } } i wanted to implement collection of Customers. I know i can implement it using CollectionBase class like below public ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XNA Installation Problems?

  Hi there, I've gone ahead and installed the XNA package, following the instructions in the download. The prerequisite's, Visual Studio Partner Edt, and the XNA installer. I've however not downloaded the MechCommander2 package yet. I wanted to see if this was any bit usable without it. I fire up Visual Studio and attempt to make one of it's "content build", and am greeted with a number of exciting errors. Of note, the content build proj ...Show All

• Visual Basic How to put a picture into a picture box fetched from a website using WinHttp

  Hi,   I need to fetch an image from a website and put the image into a picture box using WinHttp in VB. I referred to the article in the following URL. http://msdn.microsoft.com/library/default.asp url=/library/en-us/winhttp/http/about_winhttp.asp It has the following code.But the code gives error. The lines that give error are marked in bold as follows. Private Sub Form_Load()     ' Create an instance of the WinHTTPRequest ...Show All

• Visual Studio WHAT'S THE STATUS OF THE BUG IN THE CLASS DESIGNER?

  The class details window is no longer accessible after you set it's autohide property.  The workaround you proposed, as far as I know, is: DO NOT SET THE AUTOHIDE PROPERTY. This was reported to you many months ago during the BETA cycle, and now the bug persists in the RTM. This is very annoying because I've become accustomed to the convenience of setting the autohide properties of most windows except the code and form designer.  B ...Show All

• Visual C# asp.net

  hello i have an asp form in which i have added checkboxes for a field "hobbies". now i want to retrieve the values of all the checkboxes that are checked, in another asp form. can anyone help me how i can do that thank you Im Sorry, but thats no help, searching the MSDN local and online help for CrossPagePostBack does not return any results. So the term might not be well known. ...Show All