fsv's Q&A profile

• SQL Server Inner Join problem

  Merit, The best way to understand joins is read BOL. There are several algorithms to perform a join, such as inner loop join, merge join and hash join. Each of them needs thorough coverage that is impossible to provide in one post. I will give 2-word description of each type of joins, but, yet again, you need to read BOL to understand everything in detail. Inner loop join works like you guessed-it devides the tables to be joined to inner and outer tables. Then, it iterates through outer table, and for each row in outer table performs index seek/scan/table scan in the inner table to find matching rows. Merge join sorts the tables by the ...Show All

• SQL Server And/or filter field not enabled in the group filter tab

  Howdy, I have a table that has a group. In this group, I want to filter by 2 different expressions, concatenated with an OR. BUT I can't change the "And/Or" column value for the first entry because it is grayed out. The column will automatically change to an OR value if both my expression column fields are the same (which I don’t want) but if I put any other value in to the expression field of the second row, the "And/Or" field of the first row automatically changes to an AND. PLEASE! How do I get the And/Or field "ungrayed" so I can change it to what I want The 2 filters I and using check the UserID ...Show All

• Visual Basic Ordinary users can't update MDB files installed in same directory as app

  I'm using Windows Installer 3.1 to put my VB 2005 application on user machines. The destination folder is C:\Program Files\my company\my app\. The application uses an Access DB that I have been putting in the same folder. The application and data are to be accessible to all users and the DB needs to be able to accept new data and modifications. All is well as long as the user is a power user or administrator. Ordinary users sometimes find that the default installation won't allow them to update any of the files since the folder, being under Program Files, is created without the necessary permissions. This yields the ever-popular "Ope ...Show All

• SQL Server Linked Server slow query return

  Hello can some one explain this to me and give me some advice. I have sqlserver1 and sqlserver2 I have a linked server set up [ipaddress] on both servers. When I pass a variable to the stored proc or the query it takes up to 20 seconds to return 1 row but if I replace my varibles like email='sqlboy@coxnet' and firstname='ted' and lastname='clien' it returns the one row im looking for in about 2 seconds but if I pass email =@email ,fname=@fname,lname=@lname I get the 20 second thing. The query is a stored proc being called from an asp app. I get the same results when I run this in query analyzer. Here is the query. DECLARE @email VARCHA ...Show All

• SQL Server INSERTs given me the BLUES

  cstring = cstring + "VALUES('%" + txtWatchID.Text + "%','%" + txtcenter + "%'" & _ cstring = "INSERT INTO tblNEW (watch_id, service_center_num, repair_envelope, store_number" cstring = cstring + "date_purchase, transaction_num, cust_fname, cust_lname, product_code" cstring = cstring + "value_watch, failure_date, service_date, failure_code, repair_code" cstring = cstring + "service_request, store_number_senditem, register_number, street_address" cstring = cstring + "city, state, zip_code, area_code, phone_num, product_desc, service_center" ...Show All

• Visual C# DataGridView, simple question.

  Hello, I have a DataGridView, and one of the columns is ComboBox. I have a collection of items that is a datasource for the ComboBox column. The question is: If a user selects one of the dropdown items from a ComboBox in one record, then that item from a drop down list in ComboBox will be no longer available in the other records. Do I have to create a custom event to do that Thank you. ...Show All

• Visual Studio Express Editions saving an answer

  ok. how can i make vb ask a question and save the answer in a text file so i can access it with this code. Dim Instring As String Dim stream_reader As New IO.StreamReader("textfile.txt") Instring = stream_reader.ReadToEnd() stream_reader.Close() That's a pretty broad question. Try breaking it down into logical steps, and asking for the steps you can't answer yourself. Where do the questions come from Why do you want to store the answer at all ...Show All

• .NET Development Compatibility problem using Microsoft.mshtml with .NET Framework 2.0

  Hello everybody, I have an application that runs with no problem using the .NET Framework 1.1, in this application I'm using the Microsoft.mshtml component to host a browser in my Windows Forms. If you run the same application in a machine only with .NET Framework 2.0 (.NET 1.1 not installed), the following error message appears: System.InvalidCastException: Unable to cast COM object of type 'System.__ComObject' to class type 'mshtml.HTMLInputElementClass'. COM components that enter the CLR and do not support IProvideClassInfo or that do not have any interop assembly registered will be wrapped in the __ComObject type. Instances of this ...Show All

• SQL Server Service Broker Tables

  Hi, We have a customer whos database just grows and grows. Not the customers own tables, but the: sys.sysconvgroup sys.sysdesend sys.sysdercv And these tables are linked to the Service Broker, and according to http://msdn2.microsoft.com/en-us/library/ms179503.aspx these tables exists in every database and are used by the Service Broker. Now to my questions =) HOW do I delete rows from these tables How come these tables hust grows and grows, could it be any setting in the SQL 2005 Server or is it the customer who has programmed his application wrong Please respond as soon as possible. Best regards .Henrik ...Show All

• Visual Basic Connecting to sql server on a network

  hi i have two computers on one of them i have sql server 2000 and i have a copy of theprogram and it runs ok ,but on the other Pc when i tried to connect to the sql server on the other pc it alwys faild i put the connection string to point to the other pc but it did not work plz tell me what i can do the message which appers says sql server does not exist I went through the same thing when trying to connect to SQL Server 2000 over a home network and I finally figured it out. First, on the computer that has SQL Server, you need to either disable Windows Firewall or set an exception to the SQL Server ex ...Show All

• Visual Basic Hooking to find flaswindow in VB.Net

  I just started messing around with API's yesterday. So far things have come easy, well until trying to learn hooking. I have a pretty good grasp on it, I just need to know which hook to use to find when a flashwindow msg is sent to a window. For my expiremental app I am making a msn mesenger notifier. The app scans for open messages ands makes a list of hwnd's for each of the conversations, now how can I place a hook on them to intercept the flashwindow command that is sent to them when a conversation receives a new message I'm thinking something like this, only probably more complicated if hookWH_CALLWNDPROC.message = FlashWindow then 'do s ...Show All

• SQL Server TSQL Function in Execute SQL Task

  Hello, I'm trying to call a simple TSQL Function I wrote from the Execute SQL Task.  I seem to be able to call the function ok but I can't figure out how to get my result set back.  I'm just returning a boolean value from the function, but it gives me an error when I try to say this will return a result set.  I just use the "Single Row" option as I only have that single value returned.  I know that when you try to use a Stored Procedure and return a result set you have to have the Result Name specified exactly as it's returned from the SP, but a Function doesn't really have a Name returned, right Any idea how a ...Show All

• Visual Studio Team System Possible bug(?): LinksControl as a required field

  Hi all, I have a LinksControl field on my form and I made it a required field (Before a task can be added, it must be linked to an SCR). But even after I add a SCR to the control, it still doesn't recognize that the field is no longer empty; therefore, I can't save the task. Does anyone know if there is a workaround or if this is a bug Thanks in advance. Sorry for the problem you are facing. Link fields are Core fields and can cannot be modified, In the sense that RelatedLinkCount cannot be made required. Can you please post you work item definition, So that I can take a look and see what exac ...Show All

• Visual Studio Team System Logon with the object model in RC

  In beta 3 I used a NetworkCreditials object to create a conenction to a TFS server.   NetworkCredential objNetworkCredential = new NetworkCredential (strUserName, strUserPassword, strDomain); TeamFoundationServer objTFS = TeamFoundationServerFactory .GetServer(strVstsURL, objNetworkCredential); But in the RC version the factory uses a Microsoft.TeamFoundation.Client.ICredentialsProvider in the GetServer method. In Client applications I can used the UICredentialsProvider, but what about Server applications Is the only way to logon to a TFS server in server application to use the current users credentials &n ...Show All

• SQL Server HIERARCHY

  i have a problem.. which is the procedure to establish the hierarchies in my dimension.. the dimension wizard sends a message that the relationships were checked but did not create any hierarchies is there any propertie i should checke before running the wizard The cube and dimension wizards will attempt to create hierarchies based on relationships between tables and relationships found when sampling data. However, it may not discover many relationships, especially when the amount of data in the table is small. You can manually create hierarchies in the dimension editor by dragging attributes onto the "Hierarchies and Levels& ...Show All