AlanSimpson-Intel's Q&A profile

• SQL Server How to connect to AdventureWorks database

  I'm trying to connect to the AdventureWorks sample database, after just installing it from the SQL 2005 setup. I was expecting it to automatically appear in SQL Server Management Studio, but it's not there. H ow do I get it to show up there -Alex You may not have installed them. If you go through SQL Server 2005's setup, you need to select the sample databases option. Paul A. Mestemaker II Program Manager Microsoft SQL Server Manageability http://blogs.msdn.com/sqlrem/ ...Show All

• SQL Server Amazon Web Service Call with Web Service Task

  With the new improvments to the web service task, we can now use variables as arguments in web service calls. I am trying to setup a call to the amazon web service ECS. I am trying to do a simple sellerlookup. I have played with the settings and gotten nowhere. I get one of two error when I try to execute. I can always use a scripting task or write my own task, but I would like to use the built in task if it is possible. Has anyone used AWS with SSIS [Web Service Task] Error: An error occurred with the following error message: "Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: Could not execute the Web method. The error is: Object reference not set to an instance of an object.. at Microsoft.SqlServer.Dts.Ta ...Show All

• Visual C# How can you beautify your code?

  I am using Visual studio 2005 attempting to write some code in c#, I believe you can beautify your text Any help Ctrl-K, Ctrl-F only works for VS2003. For VS2005, the key combo is Ctrl+E, F However, unless my copy of VS2005 is defective, this feature appears to be broken, even when you select it from the Edit menu. It's a shame. IMO, there's very little to be excited about in VS2005. It's a new face lift where the doctor forgot to tie in all the loose ends. ...Show All

• Visual Studio Express Editions controlling volume level through code

  Can anyone suggest a way to programmatically increase/decrease your computers volume level thanks for any help :) hehe - no worries, glad I could help buddy! such things are not built into the .NET Framework - its out of scope for it and its more of a Windows thing therefore you need to P/Invoke (Platform invoke) meaning to use Windows dll's etc... and use the API's to do the task. ...Show All

• SQL Server Dynamic columns

  Hi, In my report i want to display dynamic columns.For displaying what are columns available to user,Iam displaying the columns names in one multivalued parameter.For example in my report i have Date,CaseId,Age,State as columns,and multivalued parameter name is "Columns". I wrote a custom function i.e ShowParameterValues(...) returns String s.If we select the Date and CaseID from the columns then s contain value:Date CaseID Public Function ShowParameterValues(ByVal parameter as Parameter) as string Dim s as String For i as integer = 0 to parameter.Count-1 s =s+ CStr(parameter.Value(i)) Next Return s End Function Now i want to show those two columns only.How to acheve this. Thanks in advance ...Show All

• SQL Server Report Explorer Title

  I tried to change the name of the title in report explorer of the webpart but I it could not be saved ..what happen Regards Alu ...Show All

• SQL Server Anyone know a self extracting tool for a zip file?

  I have a zip file that requires a password to extract the file inside of it. Is there away to do this automatically Can't find any software that does this. Mike   Does the file have to be added as an archive to 7-zip  Is this the only way that it will work   It gets all the way to the folder that needs extracted and stops.  Here is what my expression looks like:   7z x "C:\Documents and Settings\mroush\Desktop\Cnet Apps File\OSU.zip\usr" p-mr1   Mike ...Show All

• Visual Studio Express Editions Find and replace for textboxes!

  Hi, I'm fairly new to Visual Basic. I'm making a simple text editor, and I want to make atleast a Find box. Here a screenshot of the find form I've designed: any and all help is extremely appreciated! Dim textbox1 = Form1.TextBox1         textbox1.FindForm.Text.replace("me") how do i tell it to select the text in main textbox based on the text in the find form I dont understand your answer ...Show All

• SQL Server SSIS package design question

  We are downloading 4 large (500mb) zip files in the package. Those come from 4 different FTP sites. Sometimes the FTP download on one of those fails. Zip files contain images which need to be uploaded for existing listings. Each zip file is processed the exact same way. The question is how can I make the SSIS package so that each downloaded zip file can be processed immediately after the download - and not duplicating the processing logic Great suggestion - I liked it. However, after another look at our system - I changed the requirements - FTP will be in parallel BUT processing will be done serial in the for each (zip file) loop. Reason for this is since processing updates DB - doing it in serial will avoid deadlocks and UnZip in pa ...Show All

• Visual Studio Team System TFS says KB913393 is not installed when it is

  Hi, I am trying to install TFS on a single server running Windows 2003 R2. Setup reports that ASP.NET 2.0 QFE KB913393 needs to be installed. However, I have now installed KB913393 several times and it doesn't appear to make any difference. When I run the KB913393 setup I see a message asking if I want to install the Hotfix. I then see a Licence Agreement screen followed by a progress bar as something is installed. However, I don't see any further messages to say the hot fix was successfully installed. Maybe this is normal but TFS setup still reports that the hotfix needs to be installed. Any help would be greatly appreciated as this is driving me mad :) Thanks, Aaron By default the wrapper for the patch logs to a dire ...Show All

• SQL Server Duplicating databases in SQL Server 2000

  I am using SQL Server version 8.00.0760 - the only method I have found for replicating a database on the same server is creating a new one and importing data. If I follow those instructions and copy all objects it doesn't like one of my users so it terminates. If I change the options to not copy over users or user level permissions it complains about an invalid object name dbo.get_login_name. In both these scenarios it copies over the tables but none of the default values in some, but not all, of my tables. Is there a better way of duplicating a database Would upgrading to SQL Server 2005 make a difference (both for client only upgrade and server & client upgrade) ...Show All

• Visual Studio Team System Fxcop IDE in VS 2005

  From all the sites i have looked at on the web if i have installed FXcop1.35 on my machine and VS2005 then i should beable to enabled intergrated Fxcop checking on My Projects by simply clicking o the checkbox on the build properties page. Yet its not there. What am i missing i would appericated any help you guru's can give me Cheers Simon Cheers for the info David.. that explains why no matter what i did i could not get it to apper . have resorted to adding it in as a externall tool. Simon ...Show All

• Visual Basic BITBLT not working?

  I have 2 bitmaps in memory; one is an original copy of a picture and the second I intend to block out parts of, and display it. my bitmaps are named b1 and b2. b1 is loaded from a file (and converted to a 32bpp bitmap along the way) b2 is created with the same height, width, pixelformat, horizontal and vertical resolutions. (but empty) I then attempt to copy part of b1 into b2 using BITBLT. (I don't want to use Graphics.DrawImageUnscaled - the reason being that I intend to copy parts of the image in the future) I assign b2 to a picturebox, but it displays a blank image. Here is the code which doesn't seem to work: pbox2.Image = Nothing Dim g1 As Graphics = Graphics.FromImage(b1) Dim hdc1 As IntPtr = ...Show All

• Windows Live Developer Forums scopingBar_separator undefined?

  I'm getting a JS error: 'scopingBar_separator' is undefined ...when loading a map that adds a collection from local.live.com. Works in FireFox, but not in Internet Explorer. Was working and then stopped spontaneously, no code changes. Page can be viewed here: http://www.downtownwilmington.com/Nightlife I've tried it on a couple machines, emptied browser cache, etc... Any ideas Error appears in IE6 at line: var taskAreaHeight=document.body.clientHeight-(scopingBar_separator.offsetTop+scopingBar_separator.offsetHeight)-footer.offsetHeight; I've never seen this before, a quick look at your code doesn't reveal anything abnormal. I would start removing functionality to identify what line of your js code is causeing ...Show All

• SQL Server AS2005 Slow initial cube opening

  Hi We are having a problem in our AS2005 cubes that the initial openeing of the cubes is exceptionally slow. When the user connects though ProClarity, or I open the cube in the designer, the first report or first display of data takes about 2 minutes to return. Once it is open, the next query that you run is fine. If you exit the application, and go back in, you have to wait again for the first report. This is very annoying to the users and frustrating for me as I cannot see anything that could be causing this. We are running Windows Server 2003 x64 edition SP1 with SQL AS2005 x64 SP1. Has anyone seen this before or can point me in the right direction where to look to solve this issue. Thanks Michael Are ...Show All