Keith Brown's Q&A profile

• SQL Server Is SQL 2005 memory limitation <= OS memory limitation?

  If I install SQL 2005 Standard on Windows 2003 Standard, is SQL limited to 4 gigs of physical RAM I'm planning a new system that will run SQL 2005 Standard edition on a Windows 2003 Standard platform. The spec calls for 8 GB of RAM. My experience would lead me to suspect I need to install Windows 2003 Enterprise to take advantage of all the installed memory. You can’t get around the OS limitation. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual Studio Team System BUG: Certain extended properties won't add

  These were all from one table and were added to ScriptsIgnoredOnImport.sql EXEC sp_addextendedproperty N'MS_Description', N'Instructor Created Homework Assignments', 'SCHEMA', N'dbo', 'TABLE', N'homework', NULL, NULL GO EXEC sp_addextendedproperty N'MS_Description', N'user_id of creator', 'SCHEMA', N'dbo', 'TABLE', N'homework', 'COLUMN', N'creator' GO EXEC sp_addextendedproperty N'MS_Description', N'0 - type A 2 - type B 3 - type C 4 - External', 'SCHEMA', N'dbo', 'TABLE', N'homework', 'COLUMN', N'homeworkformat' GO EXEC sp_addextendedproperty N'MS_Description', N'0 - type A 1 - type B 3 - type C 4 - type D 5 - Unknown', 'SCHEMA', N'dbo', 'TABLE', N'homework', 'COLUMN', N'exerciseformat' Nothing about them stands out that I can see a ...Show All

• Visual Studio 2008 (Pre-release) Problem of creating xaml projects in .net framework 3.0

  I m unable to create xaml new project in .net framework 3.0. there are 19 files in xaml brower application project in vs 2005. but in my system 18 files are created only in new project folder. in my system i m unable to create XAMLBrowserApplication1_TemporaryKey (*.pfx personal information Exchange) file.and bcoz of these i m not able to create the xaml browser application.can any one tell me the possible reason. error i got while creating the project is "System cannot find specified file". Can you try creating the certificate for that XBAP project using the UI provided in Visual Studio's project properties pane Alternately try using makecert.exe which ships with the SDK. If you have ...Show All

• Smart Device Development contact editor application doubt

  Hi All, I am working an smartphone application which is running .Net compact framework 1.0. I am trying to create contact application which has add, edit and delete functions. I've seen one control in smartphone contact application which is using it for Birthday and Anniversary. In that control we can edit date, month and year. Actually I am looking for that kind of control but I could not find it. I want to put the same control in my application. Thanks Tan ...Show All

• Visual C++ Converting from C to .NET C and to .NET C++?

  Newbie here. Not sure I have lost track. But I am really confused now. I have a C program and have open it with .NET VS2005. Some conversion has automatically done and now it is successfully compiled under the .NET environment. However, the file is still remained as a *.c file. I am not able to use some .NET functions like Console::WriteLine. I supposed I need to further convert it to a *.cpp file What should I do to fully convert an ANSI C program to a full .NET C++ program Please enlighten me. I promise to grade your posting. Thank you very much. How can I resist You now get the command line arguments handed to you using the System::String type. To convert this particular one, use th ...Show All

• Visual Basic On error...

  I want a message box to popup when error occurs. What is the code for that you should use try catch blocks to catch exceptions in .NET then handle it if you can, if you cant then perhaps show the user the error but it will be ugly try 'do something here which may produce an exception catch ex as Exception MessageBox.Show(ex.ToString()) 'this will be shown to the user if there was an exception in the try block end try you should also catch specific exceptions like FileNotFoundException or IndexOutOfRangeException then finally the general exception. ...Show All

• Visual Studio Express Editions Copy image/graphic from panel/drawing surface to richtextbox

  I have the following code which allows freehand drawing using a mouse. It uses a panel as drawing surface. I will add the ability to load background images on the panel so can draw on that bmp. Now after all the drawing, I want to ensure its one image, a bmp, copy to clipboard then paste it into a richtextbox on another form in the program. Now attempting this I have tried several approaches. None have worked at all. The online tutorials or samples to study I can find are many years old and many version of basic ago. None work of course. Here is my base code for drawing. Any advice, or directing me to a tutorial, sample, or a reference book would be greatly appreciated. From what I read, this should work. There wa ...Show All

• Visual Basic Smtp Email Question

  I was just curious if anybody knows how to set the username and password on an account in order for the smtp client to be able to send an email... Thanks All... Theres just a wealth of information on here - sometimes its just searching through to find it and as the .NET uses a common framework for all languages its worth checking the other language forums as well. Glad the port seemed to be the solution - I knew I'd seen stuff specific to gmail before. ...Show All

• Visual Studio Express Editions Registering Express probs

  I have installed both VB express and Web Developer Express today. When i go to the help -- Register product the window telling me to click the link to register comes up. I click on the link, IE6 launches great but no Page comes up. There is no URL either in the address box. This is the same for both products. I got into registering the web express by a URL that someone had on this site, but the key i got didn't work. Can anyone help please. Geoff Well i found the problem. I think this may work for a few of you with URL problems. I changed my default browser to FireFox and tried again the register process, low and behold it all worked, i logged in with my passport and go ...Show All

• Visual Basic strategy to get around slow application startup...

  as long as I dropped controls onto the form designer, the application starts up pronto. Imperceptible flicker/painting as the form loads up with tab controls, toolstrips, text boxes, etc. InitializeComponent within Mainform.designer.vb works. The problem is when I add usercontrols in Form_Load. The startup performance degrades noticeably and precipitously with a dozen controls. OK, I am not in Oz or statically linked exe's anymore...the code compiles on the fly. As an experiment I thought I would move the ResumeLayouts/ PerformLayout to the end of the form_load instead of at the end of InitializeComponent. That helped somewhat but it threw into a tizzy some SplitterContainer splitterdistance preperty settings. It's getting comp ...Show All

• Windows Forms Form's - Border Color

  Hi, How can I change form’s border color Or is there any method to hide/show form’s border at runtime. Either one will work for me. Ex: If user wants to keep background green, border also should change to green color. Best % V High profile operations like MSN spend a lot of resources on making their products stand out from the crowd. Customized window appearance is common for them. To do this yourself takes a similar amount of effort. You'd have to simulate your own window borders and caption bar. Start with a borderless form and the Region property. From there, replace all of the mouse handling that a window now gives you for free. ...Show All

• SQL Server Search column name in database?

  Hi all: what i am trying to do is search one column name in whole database. i used to achieve this by using Query Analyzer . Can anyone tell me does this function available in SQL 2005 Thanks Nick Hi Nick, Sure: you can get this info from syscomments. So, to find "HelloWorld", you would: select object_name ( id ) from syscomments where text like '%HelloWorld%' Cheers, Rob ...Show All

• Visual Studio Express Editions calling a batch file when button click occurs

  Hey all, I am brand spankin new to VB and am wondering how to call a batch file when a button click occurs. I have the batch file written, and it works through command prompt. It seems like all the example code I can find on button click events just displays a message. Can anyone point me in the direction of where to look for examples on calling batch files Thanks. My first post in the link below shows one way to launch a batch file. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=618707&SiteID=1 ...Show All

• Visual C# Casting List<base> to List<ireadonlybase> where base implements ireadonly

  Hi All, I'm having problems implementing a readonly interface to a set of classes. Heres a simplification of the code: interface IreadonlyBase { // Does gets only on base class } class baseclass : IreadonlyBase { // Does gets and sets as usual } interface IreadonlyDerived : Ireadonlybase { // Does gets only on derived class & base class } class derivedclass : baseclass, IreadonlyDervied { // Does gets and sets as usual } class container { private List<baseclass> baseclassitems; public ReadOnlyCollection<Ireadonlybase> ReadOnlyBases { // Should return a readonly version of the baseclassitems that can be traversed get{return new ReadOnlyCollection<IReadOnlyEntity>(baseclassitems)}; } } Problem is the compiler refuses to ...Show All

• Visual Basic Reading a textfile into a listbox

  Using VisualBasic 2005, I am trying to save the items of a list box into a textfile so that the next time I load the form, I can read the items from the textfile back into the list box. My code, as shown below, gives me no errors, but the only thing that shows up in the listbox is “System.Windows.Forms.Listbox+ObjectCollection” I have spent hours researching and trying other methods, but this code is the closest I have come to being successful. I will appreciate any help or insight that someone can offer. Private Sub SaveChanges_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles SaveChanges.Click Dim FileToWrite As System.IO.StreamWriter Dim indexnumber As Integer ...Show All