SQL Server Management Studio's Q&A profile

• Visual Basic passing a function's name to another function (or sub)

  Dear all when programming in FORTRAN I was used to pass the name of a function to another sub or function. With VB.NET I have some problem. Suppose I have several functions, named F1,F2, F3,.., and that I have to perform some common task on these functions (for instance numerical integration). Well, I wish to manage things in such a way to have a library function or subroutine (to do integration) and to call it passing various parameters 'and' a function name ( e.g. F3 ) to perform the integration of F3 . In other words I wish something similar to this fragment of code to work (declarations and initialization omitted): module main integ1= integration(a,b,step,F1) integ2= integration(a,b,step,F2) end module m ...Show All

• Visual Studio Team System Multiple vsmdi files

  Hi, We are getting multiple vsmdi files.Everytime someone runs a unit test the solution is automatically checked out and a new vsmdi file is created using the naming pattern MySolutionName1.vsmdi, MySolutionName2.vsmdi, etc. I've compared the files and they are the same. They live in the solution root and always have. The workaround that we have is to undo checkout on the files in question and then it works fine unti one next restarts the IDE. Any ideas anyone else getting odd behaviour with vsmdi files I've C&P'd the XML contents below:   < xml version="1.0" encoding="utf-8" > - < Tests >   < edtdocversion branch =" retail " build =" 50727 " ...Show All

• Software Development for Windows Vista Setting permissions for a file on Longhorn

  I use the ACL API's SetEntriesinACL and SetNamedSecurityInfo to set ACLs for a file. I am denying write access to the users group. This piece of code works perfectly on Win2k3. On Longhorn, i am not able to access this file even as administrator. On checking the ownership tab of the file from the GUI, administrator does not have ownership. I did not modify ACLs for Administrator. Why is this happening I also tried to run icacls filename /setowner administrators from inside my code. This command fails. But if I run this from a command prompt, it passes. Is this related to any permission issue Can you post some of yor code, how you are trying. I had used SetNamedSecurityInfo to deny acc ...Show All

• Visual Studio Team System Create a new filter in reports

  New bee in creating reports ! I need to add a new filter called Issue Type to all existing reports. How do I do this Thanks Srikanth Hi Srikanth, Were you able to figure this out If not, try looking at this msdn doc about adding a parameter to a report: http://msdn2.microsoft.com/en-us/library/aa337432.aspx basically what you'll need to do is add the parameter to the report, and then also modify the query for the dataset for that report. mauli ...Show All

• Visual Studio Team System Development Project Plan not picking up all information

  When I open the Development Project Plan and load all the work items, the start dates and end dates are not loaded. Which may or may not lead to that the blue bars on the right are not shown. Why isn't Microsoft Project picking up the start dates and end dates /Chris I am wondering if that is because the field mappings to project somehow got incorrect. Did you verify the mapping for start/end date fields Mapping info is at: http://msdn2.microsoft.com/en-us/library/ms404684.aspx ...Show All

• SQL Server Issues With SQL 2005 Encryption

  Are there any pitfalls i should look out for when using the encryption in SQL 2005 I'm using Create symmetric Key EncryptTestbase with Algorithm = AES_128 encryption by Password = 'password' to create the key. to Open the key I use Open symmetric Key EncryptTestbase Decryption By Password = 'password'. and to Alter the Key I'm using Alter Symmetric Key EncryptTestbase Add Encryption by Password = 'new password'. ...Show All

• Visual Studio Team System How to Import/Export WorkItems in TFS-RTM

  I have two projects and I need to use Workitems from one in another. Does anybody know how to perform Export/Import operation between two projects on different TF Servers Dmitry, Are you trying export/import work items themselves This can be done with some coding using work item tracking object model. You can create new work item using the object model and copy the fields from other workitems. It is tricky though because of field dependencies and revisions. If you know the field dependency order, you can copy the values of fields accordingly and save it programmatically. There are many samples on work item tracking object model with the product and SDK. ...Show All

• Visual FoxPro A grid by a cursor

  Please tell me, how can I build a grid (in a formular) by a cursor. Relate me the steps. I tried, but don't work. I set at RecordSource and RecordSourceType something, but... sorry. Thank you. In short - Create cursor in form's load event - At design-time you can design grid adding columns, setting RecordSource (to cursor alias) and setting columns' controlsource. RecordSourceType is 'Alias'. Enjoy! ...Show All

• .NET Development Taskbar alternative

  Where to look fo info about making an alternative taskbar somrthing you load instead of explorer.exe * handleling notify icons from third party program * current tasks * and stuff ... There are existing open source shell replacements available, why don't you have a look at them as a start. See for example GeoShell at www.geoshell.org .   ...Show All

• SQL Server Microsoft Neural Networks Question

  1) Scaling of Inputs Is the standarization of the inputs done automatically when running the Microsoft Neural Network algorithm or I should be transforming the variables before running the algorithm 2) Predicted Probabilities How do I create a table with the actual predicted probabilities of the model for each observation In the Mining Model Prediction tab the output would be either 0 or 1, my question is how can I obtain the actual value of the estimated probability 1) Yes, using z-score ((value -mean)/StdDev), so there is no reason for transformation. 2) Use a prediction function. PredictProbability will return the probability of the actual prediction. PredictHistogram wil return all the probabilities (f ...Show All

• SQL Server New SSIS Mini-Webcasts

  You may be interested in a number of videos that are posted on SSIS here for free. There is one on getting started, checkpoints, the data flow and the script transform. http://www.jumpstarttv.com/Channel.aspx cat=c871236d-8554-42e3-8683-4d422356c0bd Brian ...Show All

• SQL Server sum report item

  Is there anyway to sum a value that resides in a textbox ie; =Sum(ReportItems!MyTextBox.value) Thank you for the reply, Just briefly reading the post, I see that there appears to be an issue using this approach with SQL 2005 & .NET 2.0. Do you know if that is the case before I move forward Is there any logical reason that you cant simply sum a calculated or static value ...Show All

• Visual Basic what s a good practice for date fields

  Hi, What s a good practice for fields that will hold dates. Should we declare them as string in the class properties or as dates. And in SQL server, is it better to declare them as char(...) or as DateTime Thnaks datetime of course. Why make life hard trying to parse one format into another when there will be chances of errors happening and inefficiency of converting one form to another - there is no need. If there is an object/data type field of the type in question, always use it. ...Show All

• .NET Development Connection String in Client / Server Application, Strong typed Dataset

  Sorry bout the subject, but it is my conundrum. I have a solution (C#) that is fat clients (winforms) talking to a database (SQL Server 2005). Our solution uses a strong typed dataset for all of its operation for the various benefits gained therein. I have used untyped solutions, and when you write the dataadapters, its very easy to customise the connection string. However strong typed, you must specify the connection string at design time. Our server deployment must be hands off, and thus my problem. I have created a customised database installer that obtains information entered by the Administrator on how to connect to the database, and I have a way to take that information and put it into a string. What I need is a writa ...Show All

• Visual Studio Express Editions Carot Position in a TextBox

  Hi all! I'm having a bit of a problem with a textbox - I need to get the position of the caret in a textbox called TextBox1. The reason for the above is that I want to insert some text at this position. I've tried everything I could think of, so I'd appreciate any help. Thanks in advance! Johannes Hi, TextBox1.SelectedText = "this" -- SvenC ...Show All