Answer Questions

• Guard Installing Right Components for Sql Server Express

  Hi I recently purchased a copy of Visual Studio 2005 & to my surprise there was a sql Server Express. My Question is Do i need to download any more components for this Are Enterprise manager or Query Analyzer part of Sql Server Express Ani You should go and download Advanced Services and the Toolkit, you can get them here, this will give an EM like tool and lots of other goodies. http://msdn.microsoft.com/vstud ...Show All

• Tonychen System.Web.Services.Protocols.SoapException: The item '/foldername' cannot be found

  I am trying to figure out how to correctly reference the directory to my subscriptions: Dim subs As Subscription() = rs.ListSubscriptions( "/SSS" , Nothing ) System.Web.Services.Protocols.SoapException: The item '/Hedi' cannot be found. ---> FYI: I replaced sss for privacy purposes only here Here's the actual report URL http://servername/Reports/Pages/Report.aspx ItemPath=%2fHedi%2fProcessingSummaryReport the subscr ...Show All

• NTBugtraq Token (A-DBN) show always master after alert

  I try to create a job for an alert that should backup the log of the database which passed adefined threshold in an alert. Therefore I created an alert for this threshold which starts a job in which I would like to use the token (A-DBN). Doing debugging with print statement shows always the database name "master", although my alert is defined for a user database. Bug or USer error and if it is an user error, what did I wrong ...Show All

• Peter Nowak (Germany) ordering values

  I have a table which contains demographic information. Within this table I have the following columns raceam_ind raceasian racebl__af_am racehi_pacisl racewhite These columns will have either a Y or N value. It is possible for more than one column to have a Y value in the case of dual ethniticity. Each possible value maps to a numeric value. FOr example 1 = white 2 = African American/Black 3 = Asian 4 = Hawaiian or ...Show All

• David So NEED HELP - Merge Replication with SQL Server 2000

  Hi, I posted about this before, and set out on my own to get this working, and haven't been able to.  I'm trying to get merge replication working with my SQL server 2000, and after 2 weeks I still have nothing.  I've gone through multiple 'walkthroughs' which all brought me to the same point.  I'm getting down to crunch time, and I'm either going to use this or implement my own merge algorigthm (I'd much rather use this).  So ...Show All

• Peter Svensson Report/query parameter default values

  I am using a SQL stored procedure for a report. The sproc has a variable in it (@itemnumber) to be supplied by the user at run time. In the report parameters within Visual Studio Designer, I am trying to set a default value for the parameter of % so that all items will be returned unless the user enters a specific item number. In the Visual Studio preview this works but once the report is deployed to the web server, the default value does NOT sh ...Show All

• John Gordon - MSFT Creating New Packages - Saving in Project Folder Unnecessarily

  In BI Dev Studio, I have a Project/Solution created successfully, which has got say 5 packages working fine. I created a new package by Right Clicking on a solution explorer and selecting "New SSIS Package". System has given itself a default name and I decided to leave the BI Dev Studio WITHOUT SAVING project / solution. Even though I haven't saved the project / solution still it left a package in project folder with a name "Package1.dtsx". I th ...Show All

• Sam Heald - MSFT Using Unicode in SQL Server

  Hi I'm have big problems trying to save Unicode information into my MS SQL Server 2000 Desktop Engine. Alright, so the problem I'm having now is I'm working with MS SQL 7.0 and PHP5. I've trying to get information to save into MS SQL, however it is storing it all weird. When I save the information and try to view it in Enterprise Manager it shows it has random characters but for some weird reason I can output that information on the page ...Show All

• Jan Dytrych Reporting on Active Directory

  I belive it is possible to use active directory as a datasource for a SQL Report Services Report. Anyone know how I go about this geoff Hi,   I think that is a C# example. (which is fine I suppose, but it doesn't help me. )   Does anyone know of or have any information on how to create a report in Reporting Services 2005 that accesses Active Directory   If I try the "Microsoft OLE ...Show All

• peace4theapes Integration Services extraction/loading throughput/performance

  I'm new to integration services. I want to create a centralized reporting system for our customers. Some customers have up to 1,000 sites and some are expected to grow past 5,000 sites. The sites are running POS applications and I want to extract the POS sales data from these sites. Is it practical to expect that SSIS can handle the extraction of data from this many sites and load the data into a central SQL database The POS sales data at the si ...Show All

• Babroberg How to append a new values like uniqueidentifiers, sequence numbers to data flow?

  Hi, I would like to know different possible ways in appending extra values like new uniqueidentifiers, sequence numbers, random number. Can you please tell what type of data flow components helps us Append what to where Do you want to add new columns with such vaues to a path within the data flow task Derived Column Transform Script Transform Row Number Transform ( http://www.sqlis.com ...Show All

• Chris4578 Creating report based on parent-child dimension

  Hi I have a problem to create a report based on a parent child-dimension When I go to reporting services, and I create a new report based on a cube, I drag my parent-child dimension to my data-layout. Then the dimension is immediatily ragged down. Anyone an idea to solve this. Hello Telmo, Everything works fine and all children will be shown. But when a parent has a child there is a toggle item (+) before ...Show All

• Leneise44 Instert found records into DB

  here, this query produces 21 days for @TotalPostingDays  ...the days left after pulling out weekend days (sat and sun) and holidays. What I want to do is instead of pulling the total amount for @TotalPostingDays I want to insert the actual dates that are contained within the @TotalPostingDays into a table DECLARE @TotalDaysInMonth int ,             @today datetime , ...Show All

• Phiipp Schumann Report Model Deployment Error

  Hi All, I created a report model and when I tried to deploy I got the following: The model ID of the submitted model must match that of the current model I have searched all over for the cause and solution but, have had no luck. Can someone please help me Thanks, Roy The SemanticModel ID of the submitted model must match the semantic model id of the existing model, otherwise you'll get this error. The solut ...Show All

• DanScan Format DateTime attribute in AS 2005

  Hi, I have an attribute a Time dimension which is of the datetime datatype. In the browser and in other tools, the displayed members are formatted like this: dd-mm-yyyy hh:mm:ss I want to change this format. How is this done The format property of the attribute in the dimension editor seems to have no effect... I tried "mm/dd/yyyy" and without quotes. Thnx... Jeroen. Hello Yan, Thn ...Show All