Michael J Brown's Q&A profile

• SQL Server sql prob

  hi, i get Msg 208, Level 16, State 1, Line 1 Invalid object name 'a1'. i do have a1, what is the problem here thanks set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo] . [STP_InvoiceByPono] AS BEGIN SET NOCOUNT ON ; declare @Fieldname varchar ( 25 ) declare @stmt varchar ( max ) declare fields cursor for select amounttype from Inv_AmountTypes set @stmt = 'Select distinct a1.date_, a1.suppliercode, a1.invoiceid, a3.pono' open fields fetch next from fields into @fieldname while @@fetch_status = 0 Begin set @stmt = @stmt + ',(Select b3.amountfc from invoice b1 inner join Inv_Detailed b2 on b1. ...Show All

• .NET Development Error when running my app from a net folder

  I need to use some of the apps i build in my company through the network. When i try to run them locally, from my local hard drive, they run fine and i have no problem, but, when i finish developing them, i have to put them in a network forder that everybody in the company can see.. this folder is in the company's server and the problem is that, when i try to run the app, i get an error message that says something like this: The application tryed to perform a not allowed action because of the security directives. For giving this app the needed permission, get in contact with the system administrator or use the Microsoft .NET Framework configuration tool. If you click on continue, the app will skip this error and try to go on. If you click ...Show All

• SQL Server End 35 Million conversations quickly - production issue!

  We have a system that has 35 million conversations piled up. We didn't know to explicitly end the conversation once the processing has completed. Oops. Now, our production box has 35 mm sitting in the table, and we have run into the problem where the amount in sys.conversation_endpoints has exceeded memory and they are being dumped into tempdb, which is killing our disk space, thus bringing the box down. We have fixed the code to end the conversations, but we now have to end the conversations in a hurry. If we select one by one out of the table and end the conversation via END CONVERSATION, it is slow. Very slow. It will finish in a few months. :( Does anyone know how to get rid of these conversations in a hurry All of the messages hav ...Show All

• SQL Server problem with recursive cte query

  I am running into 2 problems with this cte query. First off, it's not returning the results in the right order. What I mean is that, as you can see from the graph, the first row (tabid=4) should be followed by rows 3,4 and 5 but it's throwing in a row between. No matter how I try and order the results, it's not working as it should. The tabindex field is a user defined field as to what order the tabs should show up for the user so I have to order by that field at some point. ParentTabId TabId Title Link TabIndex 1 4 Personal Info /Employee/employeeAdmin.aspx 1 1 5 Employment Info /Employee/positionInfo.aspx 2 4 8 Dependents /Employee/dependents.aspx 3 4 169 Emergency Contacts /Employee/Contacts.aspx 2 4 170 Demographics /Emplo ...Show All

• Software Development for Windows Vista Differenciate Vista 32-bit and vista 64 bit

  How can I differenciate Windows vista 32-bit from windows vista 64-bit, using GetVersionEx Is there preprocessor define I canu use for that purpose Thanks, it is very useful but if I run vista 32bit on a x64 processor, I will not get the right OS version. Any idea how I can differenciate Vista 32-bit and Vista 64-bit on a 64-bit machine ...Show All

• Windows Forms Hide close button

  Hi Is there away to make the close button false whitout say the controlbox = false I can say Maximize and minimize = false regards alvin Hi there, Check out http://www.vbforums.com/archive/index.php/t-368754.html it contains what u want ...Show All

• Visual Studio Team System Work itens access by Execel 2007 Beta 2

  Hello all!  I would like to know if somebody had success when tried access to workitens using Excel 2007. It’s is possible Thanks,   Works ok for me - even makes the table look a bit prettier. All the options live under the "Add-Ins" ribbon. Sometimes the "drop down" type selections don't work very well and you have to manaually type stuff in.  It's not as seemless as the older version of Excel but is fine for me day to day.  (I wouldn't recommend you gave it to a customer, but if it is just for yourself then it is worth giving a try to see what you think) ...Show All

• Visual Studio Team System if i open a project, got latest version then deleted a file in my local folder

  if i open a project, got latest version then deleted a file in my local folder next i want to delete the file also from the tfs server so that my project on the server doesn t include the file i deleted. how do i do that. The pb is when i delete the file locally and i do check in, it says, couldn t find the files i deleted Thank you Maybe the only way for this problem, is to apply undo pending changes, did you try this test with this, but  know that you lost all change that you did to the file. Ray ...Show All

• Visual Studio Team System Strange Problem with Hebrew PageCode

  Hi, I have been working on building a service using C# (VS ver 2.0), that would connect to certain Hebrew websites and download/save them on local computer using WebClient component. I am using Windows-1255 Encoding to save it in Hebrew Codepage format. Everything is working very well, except that when I am opening the downloaded HTML file from the local computer in a browser, Hebrew words are displayed in reversed order. Does anyone have any idea why this is happening and how to fix this I need to search through the downloaded local HTML page to look for certain Hebrew words and maintain log in my database. But if the words get reversed then I can't search properly. Given below is a small example of the problem:- Text Displayed in Origi ...Show All

• .NET Development SQLDataSource update using parameters not working

  I'm passing a parameter to a stored procedure stored on my sqlserver, or trying to atleast. And then firing off the update command that contains that parameter from a button. But it's not changing my data on my server when I do so. I'm filling a dropdown list from a stored procedure and I have a little loop run another sp that grabs what the selected value should be in the dropdown list when the page loads/refreshes. All this works fine, just not sp that should update my data when I hit the submit button. It's supposed to update one of my tables to whatever the selected value is from my drop down list. But it doesn't even change anything. It just refreshes the page and goes back to the original value for my drop down list. Just to ...Show All

• Visual C# Properties.Settings.Default.Save(); does not save a user.config file.

  I have settings that are in the user scope and I can update them at runtime. When I call the save method,nothing gets saved. Any ideas If your App.Config file is stored with the program under Program Files somewhere, a normal user (non-admin, non-power user) will NOT be able to write to that file. Something to be aware of... ...Show All

• SQL Server Is SQL Server CE really the solution?

  Hi,   So far, with other programming platforms, I used to have the facility, embedded within application .exe, to:        1- Interface with already existing "multi-user" database (ex: Oracle, Access, etc.)        2- Create/access "local"/"Single-User" files for processing purposes.  (try to minimize network trafic...)   So far, I've read a lot about SQL Server products (SQL Server, Sql Server Express, SQL Server CE), at least all articles I could find, and would like to have your opinion on what would be the best approach        1- What SQL version to use for "multi-user" databases &n ...Show All

• Visual Studio Express Editions pulling data from one table then saving to another?

  Hello World, As the title suggests im populating textboxes and comboboxes from a table in an ms access db, I have created another table in the same database and i would like to save the data im pulling from table1 to table2.. this means that my data will be repeated in the new table so is probably not the best idea performance wise so im stuck on how i do this i need the data in table2 (invoice data) to work together with table1 (customer data) im I doing this the right way or is there an easier way to go about this Any help in this matter would be great :) I understand the basics of the code but the insert and the reference to an sql connection, is that for MS Access as well Thanks! ...Show All

• Visual C++ Runtime Error Abnormal Program Termination

  I get a small footprint box that pops up when I start my webcam in Yahoo Messenger. The box is titled "Microsoft Visual C++ Library". In the box it states: Runtime Error, Program:CProgramFiles\MicrsoftLifeCam\Lifetray.exe, Abnormal program termination. I have just installed a Microsoft LifeCam VX-6000 and nothing seems to work right every since. I have uninstalled it sseveral times and reinstalled it the same amount of times. I finally got the Cam to work, but I keep getting this error. Could someone help me Thanks! Try install and latest version http://www.microsoft.com/hardware/digitalcommunication/DownloadResult.aspx prod=NX6000&os=xpsp2NX&lang=en&driverVersion=LifeCam%201.3%2032-bit%20for%20Windows%20XP%20SP ...Show All

• Visual Studio 2008 (Pre-release) WPF Beginner Question

  our user base currently uses an ASP.NET web application. they are really happy with the 'look and feel' of the web pages. we want to move our users over to a .NET smart client application. however, my main concern is that our users will view the user interface as taking a step back from the existing web page layout. is it possible to build a .NET 3.0 application which has a friendly, scrollable user interface which looks closely akin to our existing web page layout, so that the users will not be put off or is this not recommended practice is this not standard practice where can i look at some demonstrations showing some recommended practice user interfaces for .NET 3.0 apps thanks These links ...Show All