StephanieR's Q&A profile

• SQL Server Time Series -

  I m using the Time Series Algorithm to forecast sales across regions for various products. Assume the model is built with last 3 years data with the periodicity being monthly. Is it possible that sometimes I can make predictions based on just 1 yr or 2 yrs data for certain products alone or certain regions alone Can this be done without having to retrain the already built model Also, is it possible that using the model, i can predict week-wise / month-wise / quarterly sales as well Thanks for the clarification, Jamie. I have some more questions : 1. Using the same model, Can i make predictions week wise, month-wise as well as year wise 2. In the Adventure works forecasting sample, the model & region were clubbed in ...Show All

• SQL Server Restoring to a new DB - The basics

  Hiya, I've recently gotten into the administration side of SQL and am muddling my way through it as best I can. We have a DB server with three or four databases on it. Maintenance routines do a full backup of each one nightly and weekly and put all sets into one backup (.bak) file. I've never had to restore them, but I thought I'd put myself through a test run since this is unexplored territory for me and I would prefer not to have to learn in an emergency. A scenario I can foresee is where I'd have to restore just one table, perhaps to a new location (i.e. not overwrite the live db, just bring up a copy of part of it elsewhere so I can do a data dump from some old data). But when I go to 'restore database' or 'restore file/filegr ...Show All

• Windows Forms Changing size property

  How do I enable the changing of size of a control like combobox Thanks. regards Alu Sorry for the unclear statement. What I mean is that to change the size 'height' property of the combo box during design time. The box could be extend but not able to enlarge the height. Thanks. Regards Alu ...Show All

• Visual Studio Team System Possible to aggregate results in a one-to-many way across TFS projects?

  I have a general question regarding management of multiple TFS projects. I've been working with TFS to get acquainted prior to the kickoff of a new project at my company. The project will be large with many facets. I would like to organize several TFS projects to support several subsystems, and a single "master" project to provide reporting for all subsystem projects.... Best practices state that it is preferable to have a single (or fewer) TFS projects rather than many. On the other hand, I can see how having several projects would be of benefit: * You could logically limit scope and security for a subsystem, while having the benefits of a separate portal and repository for developers * You could have work items managed at ...Show All

• Visual Basic Update requires a valid UpdateCommand when passed DataRow collection with modified rows.

  First lets start with, I downloaded the 2005 Visual Studio beta 2 ver. and I am programming in Visual Basic. This is my first project with this language and I let the wizards do all the work. To my suprise the automatic wizard code fail to write the correct code. Steps I made a connection to a access database. I installed a dataview grid and then tried to correct data. I got the following error when I tried to (save data). Update requires a valid UpdateCommand when passed DataRow collection with modified rows. Look at the Public Overloads Overridable Function Update( ByVal dataTable As SubContractorsDataSet.SubContractorsDataTable) As Integer Return Me .Adapter.Update(dataTable) End Function I read some other ...Show All

• SQL Server Subscriber database MUCH larger than publisher

  I have replication setup between our main site and a remote one, and have recently noticed that the database at the remote site's .MDF file is about 3 times as large as the main site's. This doesn't seem to make sense since essentially all of our data is replicated between the two servers. Can anyone suggest why this might be happening and what is safe to do to shrink the remote file TIA Ron L Are you comparing the file size or the actual data storage size in the database You should really look at the size of the allocated space, you can try running sp_spaceused in the two databases and compare. Are you on SQL 2005 There are some nifty reports that you can run in SQL Workbench that can drill down and show you table sizes. ...Show All

• Software Development for Windows Vista SetStateActivity - set TargetStateName during Execution of Statemachine

  Hi all, I have a statemachine. In several states I can get into a "special" state. From the "special"state I have to go back to the state I came from. Now there is the Statemachine property PreviousStateName available. I wanted to set the Dependencyproperty "TargetStatename" of the SetStateActivity to that PreviousStateName by a codeactivity. But setting the targetstatename of the setStateActivity is only allowed during DesignTime... Now I tried to reflector the SetStateActivity(in order to create my own SetState) but its quite a deal of effort since its got a helper procedure tail in several workflow helperclasses which are internal. Are there already any activities around which fullfill the requirements abov ...Show All

• Visual Studio Does Visual Studio Help System work on Vista?

  I rebuilt a machine with Vista and installed VS 2005 Team Suite. But, the Help System does not seem to work like it did on XP. It's slow searching, and I only can get two tabs - one Search and one results. Is VS Help broken on Vista or do I have something broken on my machine. Thanks, rich Hi WildRich, You may be running into .Net Framework compatibility problems. In order to get VS2005 in line with Vista's .Net Framework 3.0, have a look at the Visual Studio 2005 Extensions for .Net Framework 3.0 (WCF & WPF) November 2006 CTP. The download address is here: http://www.microsoft.com/downloads/details.aspx FamilyId=F54F5537-CC86-4BF5-AE44-F5A1E805680D&displaylang=en Also, if you have ...Show All

• Visual Studio Tools for Office VS 2005 Pro, VSTO and Office 2003 Professional Enterprise Edition

  anyone, i'm sorry if you've answered this question a hundred times. i looked through all your FAQ's and comments and the web in general on the compatibility of these programs and tools. On my work computer supplied by Intel, I'm running Office 2003 Professional Enterprise (has Infopath), VS 2005 Pro and VSTO (trying to run). i'm aware from your requirements from the MS Product Info page that you need the standalone versions of Excel, Word and Project or whatever since i'm running the Enterprise version of Office 2003. i don't understand why you need a less powerful version of Office 2003 with the integrated versions of those apps for this to work. is there a config, a fix or patch to downgrade my Office 2003 Pro EE (remove InfoPat ...Show All

• SQL Server Sort component sets unknown state

  Hi Forum, I'm using several sort components in my dataflow task (for all now saying uuhh, in normal flow they are all not used, only in lookup failures). I know that the sort component is more than slow and deprecated. So when I find some rows with a foreign key not yet in my dimTable, I throw them in another branch and sort them / aggregate them for insertion. After that, I wanna lookup again. So I have to wait for all inserts to complete. So I use the sort component, which has to wait for all rows, and sort for my business key. All rows inserted and sorted I lookup again. This scenario worked for me in a lot of packages with a lot of rows. So why do I post :-) I now hav another package. As of processing the stream, 1796 ...Show All

• Architecture Thin client vs smart client

  We are moving from a VB6 to a .net world. We are about to finish our business components and now its time to start thinking about the UI. Well, there it comes the doubt: should we choose a smart client path or a thin client one We develop backoffice financial apps; they are used in several ways (users that operate it to process information, board of directors that access it just to analyse information, end customers that access it to get information on balance account etc). The chance to have someone using a non windows OS (accessing the system as client) is remote, but exists. If we choose a webbrowser client, then we would have to buy some good components (specially grid component and menus) that could "replicate" desktop exper ...Show All

• Smart Device Development unable to open emulator pocket pc 2003

  hi, i'm new in embeded mobile device programming. current i'm trying to set up the programming environment. when i try to execute the "hello world" tutorial, EVC prompted me that "One or more files from the Emulator for Windows CE installation is missing. Please reinstall Emulator for Windows CE and try again." I have installed EVC 2.0 with SP4, pocket pc 2003 sdk and i have tried to reinstall EVC again and again. Besides that, i have follow the installation steps exactly same as README file. Please advice. Thank you. Have a nice day. If you are new and venturing out SmartDevice programming, I would suggest you use Visual Studio 2005 with SP1. Thanks, Ga ...Show All

• Visual Studio I need VSIP 7.0 installable.

  Hello All, I need VSIP 7.0 installable to work with Visual Studio .Net 2002 Extensibility. Please help me with the location from where I can get it. I have VSIP 7.1 and .Net 2005 SDK with me but I need VSIP 7.0 only. Any help would be appreciated. Thanks in advance. You can download the VSIP SDK for Visual Studio 2003 from http://www.vsipmembers.com . It should work for VS 2002. thanks, James Lau Program Manager, VS Ecosystem ...Show All

• SQL Server AS2000 only using 2GB even when /3GB is activated

  I've done everything to enable the use of more than 2GB memory for AS 2000 according to http://support.microsoft.com/kb/295443 Still, according to the task manager, the process msmdsrv.exe stops growing around 1 996 000 kB. I've added the /3GB in boot.ini and set the Memory Conservation Threshold in Analysis Manager to 2.7 gb. I've also checked that the HighMemoryLimit was set accordingly in the registry. OS: Windows 2003 server Enterprise Edition Memory: 3 GB AS2000 sp4 Any other settings/limitiation I've missed Actually, later today the memory usage finally past 2GB, obviously it wasn't needed until then. I stayed at 1.9 so long even though users were querying it heavily so I thought it d ...Show All

• .NET Development System.Web.Mail works fine but System.Net.Mail won't send email

  Hi, I am updating an existing VB.NET 1.1 app to 2.0. The existing app uses the System.Web.Mail namespace to send emails and it works fine, but when I try to update to use the System.Net.Mail namespace it stops working. Has anybody any ideas why The following is the existing code that works: Dim msg As New System.Web.Mail.MailMessage msg.From = "me@work.com" msg.To = "me@hotmail.com" msg.Subject = "Subject" msg.Body = "Body" System.Web.Mail.SmtpMail.SmtpServer.Insert(0, " <<SMTPServerName>> " ) System.Web.Mail.SmtpMail.Send(msg) I've changed the code to the following: Dim client As New System.Net.Mail.SmtpClient( " <&l ...Show All