Yustme's Q&A profile

• SQL Server What decides on the tables available for a partition?

  Hello, I am using the Partition Wizard. On the first screen (Specify Source Information) there are two tables listed. They are called: QMR_610_MembersOther_GrAmountAnalysis QMR_610_MembersOther_ReinsShareAnalysis Only one of those (the first one) is used as the fact table for the measure group that I am creating partitions for. So what I don't understand is why its making these 2 tables available for my partition. Can anyone explain how the Partition Wizard determines which tables are available for the partition Thanks Jamie Hi Jamie, think that the partition wizard only is doing the things his developers expected him to do - therefor the answer will be "this behaviour is by design"... ;-) ...Show All

• .NET Development Database file tied up after connection closed

  Hi, I am writing an application that: 1) downloads a database file 2) connects to the database file that was downloaded and then updates another database with it Once the update is done, I want to delete the downloaded file but I cannot seem to do this - it seems to be tied up by the sql server express instance Is there any way to be able to free up this file I am using VS2005 on a pc with windows xp pro. thanks -Barb the databases are each in their own physical file the app.config has 2 connection strings - one for each database I have reduced the program to have no other database activity except to try and "drop" or free up the database. It seems that as soon ...Show All

• Visual Studio Team System Release date?

  Any news yet on when VSTE DBPro will be officially released and out of CTP According to this thread there will be CTP5 and CTP6 and RTM and they plan to deliver before end of this year. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=612948&SiteID=1 ...Show All

• Visual Studio Team System WebTest showing no errors, but results missing DB changes

  I've just been introduced to the WebTest features of VS2005 to crack a problem we've been having with its use on our company's ecommerce store. It seems that recording a complete purchase life-cycle, from entry page to check-out summary, everything appears all green when I re-play the recording. But when I check the database, only the recording session actually gets recorded in the database. None of the play-backs actually result in an insert of data into our database. Reading through the technotes I have found so far, I see a lot of suggestions for when you get errors on the play-back, referring to client-side JavaScript redirects, dynamic data and various things like that. But in this case, the pages coming back are different than ...Show All

• SQL Server custom log provider - not recognised.

  Hi All, I have a tricky one for you... 1. I create a custom log provider on machine A. 2. I deploy the signed assembly to the../../DTS/90/LogProviders directory & the GAC on both machine A & machine B. 3. I create a new package on machine A & go to enable logging for this new custom provider: I find it in the drop-down list of providers, and I can add it successfully. 4. I create a new package on machine B & go to enable logging for this new custom provider: I find it in the drop-down list of providers, but I can't add it . I get the following error: '... failed to create log provider...the log provider type "_" specified for log provider "_" is not recognized as a valid log provider ty ...Show All

• SQL Server Default Report Server Web Page

  I've only just started working on Sql Server Reporting Services 2005, My role is mainly that of administrator (some other unfortunate sole will be doing the development) However, I'm having some problems configuring the "Welcome" screen on the server. Currently it looks like a default web directory, I can click through to Data Sources and a directory containing the current test reports: Looks like: Wednesday, January 10, 2007 4:14 PM <dir> Data Sources Wednesday, January 10, 2007 4:14 PM <dir> Test Reports Clicking on Test Reports gives: [To Parent Directory] Wednesday, January 10, 2007 4:14 PM 15193 Basic Test Report Question is: Is there an XML (Or XSL) file somewhere where I can define how the websit ...Show All

• Software Development for Windows Vista How can I add "Copy to" & "Move to" buttons to Vista's Windows Explorer toolbar

  Hi all, Does anyone know how to add a button to the new Explorer toolbar (Views, Organize...) Thanks in advance. I think it's safe to say that you do not understand the question... Or else your windows Vista works different than most other peoples..( ) Since someone else suggested the same thing on another forum (at: http://www.msdner.com/dev-archive/109/24-117-1092843.shtm ) - and everyone that replied, as well as myself (who didn't reply there) says it doesn't work. I right-click on my toolbar, on the buttons, on the menu, next to the menu, anywhere... I never see anything that says anything like "customize" - all I ever get is "Lock the toolbars" (or the standard window menu if ...Show All

• Windows Live Developer Forums ApplicationId-Ip Specific

  hi, I got applicationid to aceess msn search api and its working correctly in local system(from where i get applicationid) but the problem is when i use the same applicationid in the program and run it in different system(in server) its giving exception.Is there any problem with applicationid,is it ip specific thanks in advance You should be able to run your application from multiple IP addresses using the same applicaion ID. Can you be more specific about what exception is being thrown ...Show All

• SQL Server MIN and MAX strange results

  I want to get the MIN and MAX value of a table column from a specified period of time. I execute a query and it return the result. The problem is that the values returned by MIN and MAX are not always correct!! This is the result table Date Statement From To 1 2007-01-03 00:00:00 Invoice 1 2 Correct 2 2007-01-04 00:00:00 Receipt 1 1 Correct 3 2007-01-04 00:00:00 Invoice 10 9 Wrong 4 2007-01-05 00:00:00 Receipt 2 5 Correct 5 2007-01-05 00:00:00 Invoice 100 99 Wrong 6 2007-01-08 00:00:00 Invoice 124 175 Correct 7 2007-01-09 00:00:00 Invoice 176 224 Correct 8 2007-01-10 00:00:00 Invoice 225 265 Correct From =From Statement Number To= To statement Numb ...Show All

• SQL Server Question about tempdb size

  I a have a question about size of tempdb. Getting the size from different sources looks controversioal. My tempdb consists of 3 files (2 data files + 1 log file) In database properties it shows total size of 153 GB However, if I go to tempdb/Tasks/Shrink/Files in SSMS (without actually shrinking them), I get different picture. I collected information from that dialog box into the following table: File Type Logical Name currently allocated space --------- ------------ ------------------------- Data tempdev 50 GB Data tempdev2 5 GB Log templog 10 GB ------------------------------------------------ Total: 65 GB If I check these values from the server's Windows Explorer, it shows for same files, respectively: ...Show All

• Visual C# textbox text to string and back to textbox?

  Im pretty new to C# and I am guessing there is an easy answer to this. I am entering a number in a textbox doing a calculation and and then putting that into another textbox. However I am getting the "cannot explicitly convert type string to float" error Is there an easy way to autoconvert the text to a string Better yet how do I force the textbox to only accept strings I tried applying a mask, but could not get it to work. Here is my psuedocode: float discountrate = textBox1.Text; // perform some type of calculation with discountrate textBox8.Text = discountrate; Thanks in advance Thanks for the help. And now how do I put the float back into the Textbox I tried this but Convert.ToText is not ...Show All

• SQL Server Page break

  Hello, I'm using SQL 2005 reporting services. I habe table with two group. Group A and Group B. I set Page break at start and at end for each group in order each group will be in the new page. it is not working and I'm getting group A and B in the same page I know this problem but no, I have no visibility set. I currently change from table to list and it seemse to work fine but still.. I have group A header and footer and also for group B My problem is that the first header from group A is in the same page with first header from Group B Also last record in the Group B in the same page with the footer from group A. Aslo I have a problem with document map. I create a do ...Show All

• Visual Basic Using RGB values for color

  Ok, this seems simple but I just can't figure it out. I'm drawing colored rectangles on a form using code like: FillRectangle(Brushes.Green, 10, 10, 500, 500) What I want to do is draw a rectangle with a random color, based upon a RGB color value. But how do I set an RGB value for the brush Any ideas just can't sort it out! Thanks Create a new solid brush, for example: New SolidBrush(Color.FromArgb(255, 45, 38, 78)) ...Show All

• Visual Studio Team System Database projects require a connection to a local instance of Microsoft SQL Server 2005 for design-time validation

  I am receiving an error when trying to create a sql server 2005 project using vs 2005 team edition and DB Pro. I have sql server 2000(default), sql server 2005 express(myserver/sqlexpress) and sql server 2005(myserver/sqlserver2005_2) Developer edition installed. All databases are up and running and can be connected via SSMS. I have changed the project options to point to the developer edition instance but the "project requires a connection...." error still occurs when I try to create a new project by using and of the databse templates. Versions are the following: Microsoft Visual Studio Team Edition for Database Professionals Version 2.0.50727.145 Microsoft Visual Studio 2005 Version 8.0.50727.762 (SP.050727-76 ...Show All

• Visual Studio Changing local report definitions in the webforms ReportViewer

  In this thread http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=455978&SiteID=1 Brian Hartman lays out a limitation of the webforms ReportViewer control saying "that the report definition can't be changed once the report has been processed... you must workaround this issue by creating a new instance of the ReportViewer" I tried this workaround. When I needed to load a new local report definition I create a new instance of the ReportViewer and add it to a placeholder control. This does not work. I cannot find a way, on a postback, to get the ReportViewer to render a different report definition then it has previously rendered. I even went so far as to search the Session object for data that I might be a ...Show All