Roman S.'s Q&A profile

• SQL Server Larger than expected 'User Connection' Alert from named instances of SQL Server 2005

  We have a none production server with several instances of SQL Server 2005, which are monitored for the number of 'User Connections' via a standard alert within SQL based on the performance counter for that instance. Now the number of User Connections is grossly exaggerated on each of the named instances (not the default). Example while sp_who2 is showing only 58 connection, the performance counter is showing 3647 and these instances are all limited to only 200. This is my last stop before opening a PSS call. So as any one else come across this and maybe the solution ...Show All

• Visual Basic HScrollBar and AutoRedraw

  HScrollBar From the toolbox, the HScrollBar does not seem to be working (as it did in VB6) It does not fire on "Gotfocus", no matter where you click There is no "Mouseup" event for ending the scroll. Is this tool being phased out, or are there known bugs Related to this problem is Auto-redraw. I use the Scrollbar to help make a selection. As the user pulls the cursor, I have a floating textbox to provide information as the scrollbar passes the choice in question. In VB6 the AutoRedraw of the form avoided erasing stuff in the pathway of the textbox. I read that AutoRedr ...Show All

• Visual Studio I forgot the source safe passward

  Hi, I Don't remember adding a password, I think I left the password empty. Anyway, I have to add a user. What do I do Thanks, Udi Raz Hi Udi, If you didn't use any password for Admin user, try leaving the password fields empty and pressing Enter in the login dialog. If you had a password and you forgot it, for legal reasons Microsoft cannot help you to recover it. Try searching the net and see what other users did in the same situation... Alin ...Show All

• SQL Server DBSTATUS_UNAVAILABLE with OLEDB Command

  Hello, I have an issue with the OLEDB Command in a package of mine where it used to work and now it doesn't.  I had 4 different packages where I was bringing in a flat file, massaging the data, and calling 1 of 4 Stored procedures using the OLEDB Command.  Everything was working great, then we decided to use the SSIS EBCDIC conversion in the flat file connection rather than converting to ASCII outside of SSIS.  This wasn't a problem for 3 of the 4.  The one I have an issue with seems to be somehow corrupt, I keep getting the error "Invalid character value for cast specification", as well as "DBSTATUS_UNA ...Show All

• Windows Forms Special Characters

  Where can I find a composite list of special characters that I can use when printing out info on a windows form  For instance, if I wanted to tab over, what would I use  What about a carriage return/single-line break >but what's your opinion on it, Seth Well, speaking just for myself (as opposed to some kind of "Official MSFT&nbs ...Show All

• Visual Studio Team System Plugin error text: “TF30272: Template not found on the server”

  Hi there, I'm getting this error when trying to create a new team project.. Kinda lost, I guess my next step is to try reinstalling again. Error TF30170: The plugin Microsoft.ProjectCreationWizard.Portal failed during task SharePointPortal from group Portal. Explanation Plugin error text: “TF30272: Template not found on the server” User Action Contact your Team Foundation Server administrator. Warning TF30144: The New Team Project Wizard attempted to roll back all of the steps taken to this point but was unsuccessful. Contact your Team Foundation Server administrator for further instructions. ...Show All

• Visual Basic How to: Custom Implicit/Explicit conversion in VB.NET 2003

  Hai .....,          I would like to define some custom Implicit conversion function within my VB class. How can i do that. I have seen samples in C# but not in VB. Can anyone please help me on this Hemant, Jay provided you with this link as a resource: http://msdn2.microsoft.com/library/yf7b9sy7(en-us,vs.80).aspx ...Show All

• Visual Studio Team System add a default permission to an area

  Hi, I've seen that it's possible to - create default areas in a process template - add group's permissions to areas after the creation of a project (for example : authorizing "Readers" to read a child node but not to its parent) my question is Is it possible to add DEFAULT permissions to the default AREAS (and not for the global project) directly in the process template i hope you undertsand what i mean thx and sorry for my french english :) ++ I think it's not possible, but better check it in the documentation about process templates in the Visual Studio 2005 SDK, ...Show All

• Visual Studio Refer to reportviewer textbox from code

  Hi I would like to set the value of a text box in a local reportviewer rdlc file on page load, and button click events. How do I refer to specific textbox that is sitting in the header section of a report from an event...I have an aspx webform that contains the reportviewer control, and am successfully binding and changing the underlying datasets for my reports e.g. Dim rds = New ReportDataSource( "Dataset1" , dsClosedCompany.Tables(0)) Me .ReportViewer1.LocalReport.DataSources.Add(rds) but I can't seem to find out how to change a textbox value in the same report. Thanks in advance Nigel. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Install the managed DirectX files from the redistributable Package

  Hi I'm try to install the DirectX redistributables but the installer don't install the managed files. In the help file of the SDK is written to use the command line "DXSetup.exe /InstallManagedDX". When I do this I get the error message invalid command line switch. I am using the  Update for June 2005 and August 2005. Has anyone got an idea what's wrong or an idea how to install the mananged files Thanks   Firobo wrote: Thank's for the help, the problem was that the OS was an embedded XP with a installed DirectX 9.0c (without managed wrapper). In this environment the Setup does not ...Show All

• SQL Server User-Defined Aggregates on 2 Columns

  I'm wondering if it possible to create a user-defined aggregate that operates on two columns instead of one. Basically, I want to do something like a weighted average where I multiply two columns in each row, sum up the results, and then divide by the sum of one of the fields. For example, if I had a table that had two columns, call them SuccessRate and TrialSize, and I want to find the WeightedAverageSuccessRate, assuming that the larger the trial size of each data-point, the heavier its success rate would weigh. Hopefully I'm making sense here. I'd love to just be able to do something like: SELECT WeightedAVE(SuccessRate, TrialSize) ...Show All

• Visual Studio Express Editions Adding a data source

  Finally got the Northwnd.mdf file to work.  Now when adding it to an application, the dataset doesn't appear in the "Data Sources" window on the right.  It is listed in the Data Explorer on the left but not on the right.  So,,,, no drag/drop feature on a form.  This is with the latest download, not the beta version. I had the same problem (used the book to), and found a solution here :   MSDN Visual Basic >> Visual Basic IDE >> Re: DAta Sources Toolbox functionality reversed Thread Starter: JoshSommers    Started: 04 Nov 2005 12:29 AM  http://forums.mic ...Show All

• Visual C++ To increase memory size for my program

  I am a student currently working on large datasets. I am reading data records from a text file and storing them in arrays. I am unable to store more than 450 records.       I am working on visual c++ win32 console application. If I increase the size of array its giving me an error ' stack overflow' . I tried even by changing stack size & heap size to MAX value : 2147483647 in the projects properties -> linker -> system . And when i changed size of array to 500 its giving me a different error 'unable to start debugging '.....'unable to start program c:/......./projectname/debug ...Show All

• Windows Forms Duplicating the Print. . . and Send To functionality

  I have read through a few threads dicussing printing the active window form.  I also would like to to do this plus duplicate the Sent To functionality where the form could be sent to a printer or an email. The threads I saw were not very encouraging.  It appears, it would be better to render the form as a report and print or email&n ...Show All

• Visual Basic vb.net app and store procs

  Hi guys... I have a question to you... I have created a vb.net app, which connect to sql server 2000. I have created a setup; running the app.exe, the installation process creates lots of store procedures. Because there are several store procs, which of them are quite long (several rows....more then 500 rows), they are saved in sql files (*.sql) into a folder shipped with the setup. When the installation runs, osql tool (inside vb.net app) is called and install *.sql files. My problem is this.... SQL files (*.sql) are in text, so everyone can read it and modify. I didn't write the store procs in vb.net project beacuse are v ...Show All