Mazzica's Q&A profile

• SQL Server Templates - Predefined parameter values

  I have created template that the dba team is going to use to generate consistant code. What I was wondering is there a way to save some of your parameter values so each time I open a template some of the parameter are already set for me... Ex. We have an author parameter. If I could set that to my name and save the parameter template then when I use a template I wont have to populate that value. Ex 2. DataBase parameter. We typically work on a project that interfaces with one db. If I could set the parameter value to MyDB then any time I use the template it would already be populted intstead of having to set the same parameters over and over when they will either never change or very seldom.... I did several searches with no ...Show All

• SQL Server Sql query for Master Detail Record in One Row

  I am having a table contains Nurse Detail like nurseid 1 address fname last name phone another table contains the exp detail in 28 different type of speciality nurseid specialiity year Exp. 1 icu 4 1 ccu 5 1 OPD 2 i need to display the record in datagrid as nurse Name ExamPassed Address MostExp SecondMostExp 1 toefl abc, india ccu icu if i use the select query to find the top two inside a datareader which collect the info. about each nurse this takes lot of time to complete this and many times gives Timeout error about(50%) is there any code to combine with the urse detail records as a column for speciality one and two. any stored procedure / se ...Show All

• SharePoint Products and Technologies Cannot upload a .exe file to a sharepoint site.

  Hi, I am unable to upload an exe file to a site created using MOSS 2007. Inspite of removing .exe from the list of blocked files in Central Administrator, I still cannot upload a exe file. How do i upload a .exe file Any information on this will be appritiated.. Thanks in advance, Regards, Sunit Pinto Probably the easiest way is to just zip up the file. SPS was not really meant to replace a file share so things like exe files are better left off of it. I believe Mike Fitzmaurice has a blog entry about just this type of thing. ...Show All

• Visual Studio 2008 (Pre-release) How does one express a many-to-many 3-table arrangement as an entity model?

  Take this schema: Authors (ID, First Name, Last Name, etc) Books (ID, Title, ISBN, etc) BookAuthors (BookID, AuthorID, IsPrimary) So, this is a representation of your standard "mapping" scenario where you map many rows of one table to many rows of another table via an interim "mapping" table that supplies the many-to-many relationship. In my experience, I encounter this table structure all the time and is considered extremely common and still satisfies 3NF. As a rule, using ADO EF, I should not have to modify my schema to de-normalize to produce a better relational model - the model should be object/relational and the schema should be 3NF - that's the whole point of an abstracted entity model in the first place. So, I w ...Show All

• Windows Search Technologies Find funtion

  I am having problems with Outlook 2003. The find function does not work. When I try to search for emails using the find function, either nothing happens or the program feezes and closes. Can anyone PLEASE help me get some bearing on this Thanks in advance. Hello drugshrink, The find function in Outlook is part of Microsoft Office Outlook. It is not part of Windows Desktop Search. If I knew the answer to your problem I'd gladly help, but I have to instead refer you to our Outlook experts. You might try asking your question here: http://www.microsoft.com/technet/community/newsgroups/server/exchange.mspx Paul Nystrom - MSFT ...Show All

• Visual Studio Tools for Office Trap ribbon click

  We need to trap the click on certain ribbon commands for Word, Excel, etc, and log that it happened. Is this possible without replacing the ribbon with a "fake" ribbon Hi Pat No, there's no object model that lets you trap click events on the Ribbon. You have to replace the Ribbon with one of your own, containing instructions for call-backs to your code. ...Show All

• Visual Studio Express Editions Splash Screen issues

  If this has been addressed, please believe me I apologize for the annoyance, if it has not, then well I must be an idiot, which is probably true, but anyway. I made a splash screen, actually I made a form that I want to use as a splash screen. I get either one of two things happening. The screen comes up and stays up. or it comes up and disappears so fast that you don't even see it. The application is not that big, but I'm using it just.........because it's just the norm. So how on god's green earth can I make this work. Essentially I got the form splash g = new splash g.showdialog(); g.close(); when I used the dialog it just stays up there. When I use the .show then it comes up and down so fast that you can't see it. So ho ...Show All

• .NET Development Solution for shared list

  Hello, I need to create server/client with such funtionality: Server has list, which is shared with alll clients. This means, that all connected clients see the same list. If any client removes item from the list, server and all other clients must imiadetly refresh their list. If not talking more about specific software functionality, I can list such things about comunication, what I need: Communication between applications would be through WAN (internet), so optimal solution for network bandwidth and server resources is critical. In the beginning there would be ~40 clients and this number can increase to 100. Communication channel must be secure, that no one could read or change traveling data. Author ...Show All

• SQL Server Keep package alive forever

  Hi there, Does anyone know how i can keep an ssis package used for real time reporting alive no matter the amount of errors it gets So for instance the server im streaming to is shutdown for maintenance, and the connection dies, its needs to just keep re-trying. In other words the maximum error count is infinite. i dont just want to set max err count high, i want it out of the picture all together. Thanks replication should be able to catch up with that change. anyway. just stay for more suggestions. how about scheduling the package to run regularly using a Sql jobs or windows task scheduler ...Show All

• SQL Server SSIS Parallel processing of packages

  Hi, I am facing some problem's while using the FOR loop container to execute 7-10 packages in parallel. The main package has 7 FOR loop containers say F1-F7. Each FOR loop container has 2 task's T1==> exec child package C1 T2==> exec delay task Delay1. The idea is to run child packages c1-c7 in parallel ...delay for some time and then run again since there are in the FOR loop container. I am facing someproblems. 1. The execution of tasks T1-T7 is not guranteed. This means SSIS picks up any 6 tasks of T1-T7 randomly to start with. 6 is the max it processes whereas i have more than that. Can i change this setting 2. Its not guranteed that if say Task t1 of FOR loop F1 is executed the subseque ...Show All

• Windows Forms Treeview dragdrop event ignores exceptions! HELP

  Hi, I have a windows.forms application in C# using a treeview with dragdrop capability, however I have found when an exception occurs in the DragDrop event and is unhandled, .Net ignores it (instead of showing the exception dialog) Attached I have some test code where I explicitly throw an exception in the DragDrop event, nothing happens! Any ideas thanks Brian public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void treeView1_DragDrop( object sender, DragEventArgs e) { throw new ArgumentException (); } private void treeView1_ItemDrag( object sender, ItemDragEventArgs e) { DoDragDrop( "!" , DragDropEffec ...Show All

• Internet Explorer Development ActiveX Modal Dialogs do not work in IE7

  Our product is suffering some pretty severe problems because of IE7. We've starting getting calls that dialog windows become hidden. We've heard this is a threading issue. We found out that the problem is actually much worse. Modal dialogs don't seem to function correctly in IE7. You can recreate the problem using VB6 by doing this: 1. Create an ActiveX UserControl project. 2. Add a form to the project (form1) 2. Put a button on the user control (usercontrol1). 3. Add this code to usercontrol1. Private Sub Command1_Click() Dim objForm As Form1 Set objForm = New Form1 Call objForm.Show(vbModal) End Sub 4. Build the project as an OCX somewhere on your hard drive. 5. Find your control's CLSID in regedit. I ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Visual C++ : Going from 2D to 3D Drawings

  Hi,   I finished an application in Visual C++ 2005 which draws and manipulates different figures on screen using GDI+.  Now, I would like to go a step further and draw those same figures in 3D.  Is there any articles available on the subject   Where should I start   A couple weeks ago, I remember having read something on using DirectX library for this, or maybe something else related.  If it is the right step to take, does anyone have any infos on which library would be the best to use and how to use it   Any example Thanks in advance, Stephane Hi Jonathan, Thanks for the link. Really appreciated. I understand that I must download and inst ...Show All

• .NET Development Designer toolbar

  hello guys I have this silly question, Im trying to create a new web application(2003), and I cant find the "Web Forms" nor "Html" tabs in my toolbar, i tried show all tabs but still I cant find them, is there any way that i can get them back without having to add each control one by one Thank you Hi, You can reset your toolbar by doing the following: right click in the Toolbox and select "Add/Remove items..." click the Reset button (at the bottom next to OK, Cancel) This should do the trick. Greetz, Geert Geert Verhoeven Consultant @ Ausy Belgium My Personal Blog ...Show All

• Visual Studio Express Editions Work on Visual Basic Express IDE without visual styles

  I like to keep switching between visual styles(themes) for my XP. But i dont want it effect the IDE. Every theme gives a totally different look to the IDE. Is it possible to avoid the Visual Style from effecting the IDE. I want it to always have the windows standard theme. I did check the MSDN and found a page on how to disable the Visual Style by going to the properties of the project unchecking the enable Visual Style box. But it did not show any result. This is probably only going to effect whether you project when run will use the themes or not. It will have no effect on the Visual Studio IDE. The whole idea of themes is if you change the theme you applications will look different. If you ...Show All