Lee Walters's Q&A profile

• Visual Studio Team System Switching Between CREATE and ALTER

  Can some one tell me if the following development pattern is correct: I edit a stored procedure (for example) and when I execute it I get an error stating that the object exists. So I change "create" to "alter" and rerun it and it compiles OK. But then when I do a build it complains about the "alter" and I have to change it back to "create". Is there some way to avoid this constant switching between "create" and "alter" Cheers, Frank J. Reashore, MCSD.net, MCDBA Vancouver, Canada You should not be manually executing the <mysproc>.sql inside of the DB Pro Project. The SQL File is a creation file that is designed to ...Show All

• SQL Server Optimising Merge Replication for both server and client subscribers

  I need to merge replicate data to two different types of subscribers: Clients subscribers which will have a very small percentage of the data from the central database. The data on these machines will be managed using dynamic filtering on host_name() Server subscribers which will manage a copy of all the data from the central database There will be far fewer server subscribers than client subscribers. As I see it I have two options for the configuration 1) Use two separate merge publications – one which is filtered and one which isn’t 2) Use a single merge publication and setup the filtering so that the server subscribers receive all the rows Which option is likely to lead to better performance ...Show All

• Visual Studio Express Editions Problem binding Combo boxes to BindingSource

  I have a form which includes 6 combo boxes each box has been bound to different feild in the same table(SettingTbl) Using Combo Box tasks I added the setting as below to each combo box. Datasource SettingsBindingSource Display Member settingf1 Value Member settingf1 Selected Vaule SettingsBindingSource - settingf1 ect Once all the combo box where Bound to the same binding source and differnt feild names I exicuted my program and found that combo boxs all populated but when you change the value of one of them other box also changed there values . I spoke to a friend who suggeted that I need a fill and get select statment for each combobox and so I create them and tryed again . unfortunatly I have not been able ...Show All

• Windows Forms How do I copy a file to specific folder??

  In my application I have used an openFileDialog. And user can select picture file from his/her hard disk. I want to copy this file to Resourse folder of my application. Does anybody know how can i do that pls help.... since the File.Copy support the relative path, you can use this feature to specify where the Resources directory is, i.e. up 2 levels of the Current Directory where the exe locates. Here is a sample code may help you OpenFileDialog openFileDialog1 = new OpenFileDialog(); openFileDialog1.RestoreDirectory = true; if (openFileDialog1.ShowDialog() == DialogResult.OK) { string filepath = openFileDialog1.FileName; string filename = filepath.Substring(filepath.LastIndexOf( ...Show All

• Architecture In a large project ,if I build a class diagram and what is the next step,the work has to divide into serval parts , framework

  In a large project ,if I build a class diagram and what is the next step,the work has to divide into serval parts , framework should come first at this stage How large is your project Do you have one large "class diagram" (how many classes ) The decomposition of a problem into the major components and their relations is usually called "architecture" the division into those parts is driven by a lot of factors : requirements : performance, security, availability etc . Technological : the language /tool (e.g. .Net vs. Java, web vs. winforms etc ) Organizational : how many teams , are they collocated, do they have specializations these and others all come from the ...Show All

• Visual Studio Express Editions error (0xc000007b) when running ssmsee.exe manager program

  I have been getting this error lately (about 4 months) and can't figure out why. Full error text is 'The application failed to initialize properly (0xc000007b). Click on OK to terminate the application'. Nothing like giving a reason why! When I do a 'repair' re-install it works again. Will fail again whenever I reboot the system. Any ideas on how to solve this problem would be appreciated. I have run virus scans by Symantec and BitDefender and computer seems to be clean. My sql server 2005 express edition was update to sp1 when it came out. I don't know of any other updates or patches. ...Show All

• Windows Live Developer Forums Why are all the pushpins in the SDK demos misplaced?

  I am curious why the pushpins in all of the Interactive SDK samples are not properly handled. As you zoom in and out on the map, the point that the pushpin is pointing to moves. For example, bring up the Interactive SDK and select Use pushpins->Add a default pushpin from the left menu. A pushpin is placed on the map pointing near the northern border of Nebraska. Now zoom out once. The pushpin is now pointing to the center of Nebraska. Zoom out again and the pushpin is in Kansas! The reason is because it is positioning the center of the pushpin image, not the "point". This is easily fixed with CSS styles, which can be embedded in the HTML sample code. The same occurs on all the other samples I have looked at. I am using Firefox ...Show All

• Windows Forms ReportViewer, problem with subreport??

  I Have got a ReportViewer that has a business object bound to it that displays order details, I bind a the business object "_order" to a BindingSource: this.OrderBindingSource.DataSource = _order; this.reportViewer1.RefreshReport(); This works fine and when I pass an "orderID" to _order it shows the correct details of the order, ie CustomerName and OrderID etc. What I now want to do is have a sub report that lists the order items. This is where I'm having a major problem. I have created another report "reptItems" that contains a table with the ojects from my "OrderItems" business object eg; productName, qty, price etc... I have set up the ReportParameters to be "OrderID" O ...Show All

• Visual Basic Me.Suspendlayout

  Hello Everybody! I very new in this forum! my english isn't very well. I hope you understand me. ok, i want to increase the width of my form, but slowly, and, to left side. i tried this: (t.Interval = 10) private Sub t_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles t.Tick Static i As Short If i < 50 Then Me.Left -= 10 Me.Width += 10 Else i = 0 t.Enabled = False End If i += 1 End Sub but it look very bad. if you try you will understand why. it is not has to be like this. if you resize the form manually it's not happend. hope you understand me (: about the function me.suspendlayout: How do i use the function me.suspendlayout I tried this co ...Show All

• SQL Server [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

  trying to install sql server2005 on a windows 2003 server box. getting msg below at the sql server . i looked at other posts on trying to uninstall SQL Native Access Client and norton antivirus. i could never find the snac on the add - remove programs and this server does not have a virus protection program yet. here's the history of the installs on the server: wanted to test a 2005 upgrade so: 1) installed sql server 2000 then sp4 then restored some databases to it - all OK 2) tried to upgrade to sql 2005 but ran into problems and left it at that. had a disk drive crash on the d drive so lost the installs but not the operating system when the drive was replaced, left alone for a while then wanted to test a straig ...Show All

• Windows Forms using applicationsettings/propertybinding to save form size etc.

  I want to be able to save the following: The last position and size of the form when not maximized and the last windowstate. ie if the user closed the app maximized, next time I want it to open maximized, but if the user sets it back to a normal window, I want it to display using the save size and location (as Microsoft Word does). I have created three user settings with the appropriate type. If I bind these to the form properties, it seems to really screw up (it works ok until I add the windowstate, but I need this setting. Otherwise, if I maximize the form and then close and reload the app, the windowstate is set to normal, but the size is set to the whole screen). I have also tried setting these properties in the constructor and ch ...Show All

• SQL Server Proactive Caching

  Hi all, I have two questions about Proactive Caching in MSAS 2005: 1) If the option "Drop outdated cache" is activated with MOLAP storage mode and "Bring Online Immediately" is checked, I have two variants of system behaviour in my mind and can't understand what is the wright one: - When the cache is dropped, any queries can be answered from the relational data source until a new cache is created. ( by "Microsoft SQL Server 2005 Analysis Services Step By Step") - When the cache is dropped the server switches to real-time ROLAP while the MOLAP objects are reprocessed in a cache. (from http://msdn2.microsoft.com/en-us/library/ms175646.aspx ) ROLAP - is a relational but special olap structure a ...Show All

• Visual Studio Microsoft TV Plugin for VS 2005

  Hello, Is there any plugin for microsoft TV application development for VS 2005 Please help me on this. Thanks Sajal Mahajan ...Show All

• Software Development for Windows Vista Question about FileRender

  Hi, 1. How can I play a YUV file with format YUV 4:2:0 2. Can I render from file that I am writing to at the same time (with delay of-course) Thanks, Yaniv Thanks for the answers.   How can I change the output pin media type Here is what I want to do: 1. Add source filter to the graph builder (with a path to .yuv file) using AddSourceFilter method 2. get the output pin of this filter 3. change its media type (set to sub type to MEDIASUBTYPE_YVU9 and change the format block according to the resolution and the frame rate) 4. render this output pin.   Thanks, Yaniv ...Show All

• SQL Server Microsoft Association rules importing to web form

  hi I am using Microsoft association algorithm to find the association between PATIENT CITY ---> likely Disease. I like to know how can i import association model after creating from SQL Server BI studio to use in my ASP.NET web form such a way when the user enters PATIENT CITY, system prompts associated Disease. I do have Data mining with SQL Server 2005 book, could't find any resource for my objective. Please suggest best source or tutorial how can i do your help and insight is highly appreciated. Raju Please see Bogdan's suggestions on this thread: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=650506&SiteID=1 ...Show All