Alan Jr's Q&A profile

• SQL Server SQL Replication Vs SQL Service Broker (SSB) for SQL 2005

  Hi I am presently working on a requirement involving a central SQL store replicating data with 600+ stores. Presently the no of stores is 300 and it would eventually more than 600+ shortly. What would be the best option to use in this scenario I am told that for more than 600 stores the replications would serioulsy impact the performance and SSB would be more advisable. Now i am newbie on SSB and would like to know from the experts whether its a correct way of implementation TIA Paritosh With 2400+ subscribers, you will really be pushing merge replication to the limits... but I'm not an expert on SQL replication and cannot tell you for sure how scalable replication is and whether it c ...Show All

• Visual Studio 2008 (Pre-release) Install Problem - VS 2005

  I am having an Orcas install issue I have not seen in the forums yet. At the end of the install there is a step that seems to launch VS.2005 in the background and eventually it crashes and I get the "Relaunch VS.2005 - Send Error to Microsoft" dialog. After that the Orcas install rolls back. I ran the Microsoft .Net 3.0 Uninstaller before attempting the .NET FX RC1 install and have uninstalled / reinstalled VS.2005. .Net FX 3.0 apps do run fine on this machine (Microsoft Max and other programming samples) Any ideas or install switches I can try Adam Hill This gets a little tricky without have a repro machine I can put in front of a Dev. What sku of VS 2005 are you ...Show All

• SQL Server Will Debug.WriteLine work in a script component?

  I have traditionally thrown message boxes while developing SSIS packages and removing them when finished, but wish to move to something more appropriate. From my understanding, Debug.WriteLine is supposed to output to the console while debugging. In various places I'm calling System.Diagnostics.Debug.WriteLine("Stuff") but nothing comes up in the output console. Am I using this the wrong way Debug.WriteLine method has ConditionalAttribute("DEBUG") applied to it, the DEBUG macro is not defined when compiling the scripts, so this method does nothing. Use Darren's code instead. ...Show All

• SQL Server Upgraders: How much did tempdb increase after upgrade?

  I came across a passage in a book stating that the SQL 2005 version of tempdb requires "significantly" more disk space than previous versions of SQL Server. I'd like to have your opinion of how much tempdb space increased as a percentage, and what operations you see using tempdb now that didn't in previous versions I'd like to gauge feedback to estimate future growth needs and general concern. Thanks for any info! It depends on your workload and whether you use new SQL 2005 features like snapshot isolation (which uses TempDB for its version store). Personally, I have eight TempDB files (one per processor) that are all 4GB each, with autogrowth turned off, for a 2.5TB OLTP database. This ...Show All

• SQL Server SSIS FTP Task problems

  We are unable to retrieve a file from an FTP server using SSIS FTP Task. With the settings indicated below: IsRemotePathvariable: False RemotePath: /home/ftpu/test.csv IsLocalPathVariable: False LocalPath: working_directory (with Connection Manager entry setup for this) Operation: Receive files The following error is produced: Error: 0xC0029183 at FTP data, FTP Task: File represented by "/home/ftpu/ns_test.csv" does not exist. Performing a manual ftp works fine, hence suggesting a fault with the SSIS TFP Task. Has anyone else successfully used an FTP task, and if so, any ideas on what's going wrong Thanks Neil When editing the RemotePath value within FTP Tas ...Show All

• Visual C# Controlled Shutdown of a Consol Application

  Sorry if I have posted this in the incorrect section, but I wasn't sure where to post it, and as I am coding in C# I decided to put it here. The Issue I have several console application which need to perform a controlled shutdown. I create the Console application form code and store Process objects for each process created. I need to be able to tell if the process is still resoponding and hope to use the call Process.Responding to determine this (after first calling a Process.refresh()). When the creating application is told to it needs to shutdown the application in a controlled manner to allow for tidying up of resources and closing sockets. As such I am hoping I can call Process.CloseMainWindow. In both cases I have made the assumption ...Show All

• Visual Studio 2008 (Pre-release) Call mysteriously hanging

  Hello, I'm calling a WCF service method from my client using the net.tcp binding and the client just hangs until a timeout exception is raised. At which point the client terminates and the service then receives the call and seems to process this perfectly normally. The method is correctly defined in the contract and was bizarrely was working OK a day or so ago and I'm at a loss to explain what has changed in the meantime. All other methods on the contract are called fine and there are no timeout issues. The mystery deepens when looking at the message traces. The client receives a SecurityVerifiedMessage and then sends a SecurityAppliedMessage to the service method as expected, however the server receives no message until more than a ...Show All

• SQL Server How to fail when ForEach File Enumerator doesn't see files

  I have a ForEach file enumerator that executes a data flow for every source file in a specified directory. If there are no files in the directory, the package executes with a result code of 0. I need the package to fail if there aren't any files found in the specified load directory. Is there a simple way to do this with the SSIS component, or will I have to script the entire file enumeration process inside script tasks to handle this requirement Thanks in advance for any assistance with this question. Please post replies to this forum. -Doug Yes, we need to fail it because the job scheduler we use will provide the appropriate notification or take appropriate action to try and resolve the situati ...Show All

• Visual Studio 2008 (Pre-release) How to scroll in a ListView and select the next item?

  Hi, I have a derived ListView and ListViewItems with focusable elements in it. If one of theese elements is having the focus and I'll press PageDown, the ListView should scroll one page down and set the focus on the next element inside the ListViewItem. I get the ScrollViewer of the ListView with "VisualTreeHelper.GetChild(this,0)" and when I'm calling it's PageDown()-method, the ListView scrolls down. But how do I set the focus on that element which is inside of the ListViewItem greetings, cheesenhomer it's easy you only have to do this: Me.listview1.Items(Me.listview1.Items.Count - 1).Selected = True Me.listview1.Select() Me.listview1.EnsureVisible(Me.listview1.Items.Count - 1) this scroll to ...Show All

• Visual Studio 2008 (Pre-release) Can you Unit Test XAML?

  Done some Googling on this one but not really thrown up any real answers. How does XAML fit in with Unit Testing I understand that XAML should be seperating the presentation from the code (which is great) but are there any problems with Unit Testing XAML apps, anyone got any hints or resources on the topic Cheers in advance. Pete You might want to check out Dan Crevier's blog posting on his DataModel-View-ModelView pattern. We are using it here and it works very well for unit testing. http://blogs.msdn.com/dancre/archive/2006/10/11/datamodel-view-viewmodel-pattern-series.aspx Let me know if you have any other specific questions Neil ...Show All

• .NET Development Move File

  how to rename and move file from one location to another. i m using rename(oldpath , newpath) function but it is giving an error "system.argumentException: Procedure call or argument is not valid can any buddy rectify Try System.IO.File.Move() instead. ...Show All

• Software Development for Windows Vista TabletPC and Video Drivers

  I have a Toshiba TecraM7 tabletPC.  The display adapter on it is the nVidia Quadro NVC 110M.  Currently, Vista Beta build 5472 is installed with the latest of Windows Updates.  After the updates, the video display in the device manager is showing up as only "standard VGA."  I've talked with nVidia, who has this display adapter's drivers on hand, but they are only good for desktops [only].  I've talked to the tech support and they say that it is the manufacturer's responsibility for notebook and tabletpc drivers.  I then talked to Toshiba's tech support, and they have been almost no help at all.  The last response I got from them is "the driver must not be available yet."  Wel ...Show All

• Visual Studio Team System Local VSTFS install and local user rights

  Hi, I was able to install TFS locally (since we don't use AD), and everything seems to be working ok. However when I set up the local accounts for the users I noticed that to let them connect from the client to the server they needed local administration rights on their local account on the server. I'd like to have them at most as power users but so far I can't get that to work. Thanks for any help, - John B The Team Foundation Server groups can be accessed either via the "TfsSecurity.exe" command line utility or through the Team Explorer client. We don't add any Windows groups, but rather handle our own permissions and group lists internally. You can find more information on managing users ...Show All

• Gadgets file is .gadget but IE downloads as .zip

  I have packed my gadget files in a zip file. I then changed the name to *.gadget. The icon changed to a gadget icon and double-clicking it installs it. I then uploaded the file to my webserver and it is there are a gadget file. I then linked to it as a gadget file. When I click that link it downloads a .zip file and asks where to save it rather than downloading as a gadget file and installing. What am i doing wrong I would click OPEN and nothing would happen. I restarted and now it works. Although it adds a ".~0001" after the file and prompts with a "Not a valid gadget file." ...Show All

• Visual Studio Unable to Debug using VS 2005/Remote Debugger 2005

  Hi There, I have created a small simple ASP.NET application on my development machine. Using VMWare with Windows Server 2003 on my remote machine I have deployed the application and it is running fine. I have installed Remote Debugger 2005 on my VMWare machine and started it successfully. Within VS 2005 on my development machine I have attached the processes " w3wp.exe" and set the breakpoints. The remote debugger console has displayed a message to inform me that I have connected However the problem is within VS 2005 at the breakpoint it states that the breakpoint will not be hit as no symbols have been loaded. Any suggestions Gary Gary, Please check out the FAQ at ...Show All