Answer Questions

• takkyangel Report Services installation problem

  I've installed SQL Express 2005 on an XP Professional machine and I'm trying to configure Report Services. In Reporting Services Configuration Manager, all items are "green" except "Web Service Identity". The value is <machinename>\ASPNET and isn't configurable. I've searched the forums and followed the advice I've found to remove and reinstall .NET, but it hasn't helped. User ASPNET does exist on the machine with a local account, and IIS5 is running. SQL gurus, please help me figure out what to do! Thanks. That's a little over my head, I know little about IIS. Other "web pages" are accessible, such as http://localhost/printers and http://localhost/tsweb . This machine ...Show All

• JosB Cannot Install SQL Server 2005 [SOLVED]

  I'm trying to install the final releases of Visual Studio 2005 Pro and SQL Server 2005 Developer's Edition. Unfortunately, I uninstalled VS Apr CTP "first"  INSTEAD OF SQL Server 2005 Apr CTP. I was then able to install the final release of VS 2005 without any problems but now I cannot install the SQL Server 2005 because it finds the beta components that must be uninstalled before proceeding. I tried using "Add/Remove Programs" but when I selected any of the SQL "CTP" programs that were there, I received a message that there was nothing to uninstall but I could have the "entry" removed from the "Add/Remove Programs" screen -- which I did. I now have nothing related to the VS or SQL Server CTP's showing in "Add/Remove Programs". So it ...Show All

• __ButterFly__ Data SOurce View and Missing Diagrams

  Guys, I am a newbie working through the SSAS tutorial. I am at lesson 5 and something has gone wrong with my Data Source View. Although I have diagrams in the Diagram Source pane I can not get them to show in the actual diagram pane. That pane just shows a grey background rather than the cream canvas. New diagrams in that data source view show the same problem. If I create a new Data Sorce View, I can create diagrams and see them. I do not want to create a new Data Sorce View and abandon the old one, because it will break the tutorial. I do not have a record of everything that was in the old one. Neither do I know how to repoint my cube at the new Data Sorce View. Can someone please tell me how to restore the view of the diagrams. ...Show All

• remedios_ server timeout

  In SQL server management studio: When doing ex count(*) for a big table or create index or like, I get timeout error. The timeout setting = 0 Even timeout = 888888 gives timeout Does not the query execution timeout parameter work Or are there other parameters needed to be ajusted Hmmm... are you able to execute SELECT COUNT(*) from other applications with configurable timeouts i.e. SQLCMD or a custom .NET application Paul A. Mestemaker II Program Manager Microsoft SQL Server Manageability http://blogs.msdn.com/sqlrem/ Could you apply SQL Server 2005 Service Pack 1 Paul A. Mestemaker II Program Manager Microsoft SQL Server Manageability http://blogs.msdn.com/sqlrem/ Was there ever a solution found ...Show All

• YhanT Access to the property values for my expressions

  I may be looking too hard for this but I can't find a way around it. I have an Expression and in that expression, I want to access a property on the same object (it would be great to get the properties of other objects as well). Example: I have a flat file connection where I defined the name of the flat file in my ConnectionString. I also have a variable that I have it linked to my dtsConfig which points to the proper folder name at run time. How can I create an expression similar to this: @[User::strFolder] + @[Connectionstring] where @[User::strFolder] is my variable and points to the correct folder for the given server the package is running on and @[Conenctionstring] is my made up name to access the VALUE of the Connecti ...Show All

• alecb why won't this work? select stmt

  select uid, OrderID, Count(OrderID)As DupCnt from OrdDetails group by uid, OrderID having count(OrderID) > 1 this returns no rows, can't I show another column to identify which uid goes with the dups, I did it before and now it doesn't work, probably something silly I'm missing. thx, Kat Kat - If UID is unique you should not group by it - you should just group by Order ID which is duplicated. why is UID in your query AWAL In this situation, it is the uid that is an identity column because of the way I duplicated this table to put over 46,000 rows in it for testing. So, OrderID is duplicated, but uid is not. Of course if I use this in the select clause, I have to group by it also, so maybe it isn't possible ...Show All

• NetPochi Totaling of the represented values (but not dataset values)

  Hello! I have a problem with totaling. There is table below which represents what exactly I need. Each cell value in the table is field multiplied by a coefficient. Totals should sum all row values as represented below : Tasks            User1 value                  User 2 value      ...     Column Totals  task 1            =field1_1*coef1           =field2_1*coef2   ...    =field1_1*coef1 + field ...Show All

• Scott McKeown Download DTS for SQL 2005 Express

  I'm trying to export a SQL 2005 express database to SQL 2000 without success, really a pain in the ass :-( But I found that it may be a hope but I can't find the page to download the in this page mentioned additional download for SQL 2005 express that will add DTS functionality to it. http://www.microsoft.com/technet/prodtechnol/sql/2005/msde2sqlexpress.mspx " DTS runtime Yes Yes (Web download) " Where can I find the additional package to add DTS to SQL2005 express Best Regards   Hi.. try http://download.microsoft.com/download/4/4/D/44DBDE61-B385-4FC2-A67D-48053B8F9FAD/SQLServer2005_DTS.msi  you will find the DTS Wizard at C:\Program Files\Microsoft SQL Server\90\DTS\B ...Show All

• Mario_G Integrate my app

  I wish sqlserver can send me a mail automatically after completing one job,there are alerts and notifications in job properties,which can perform my need Previously,i defined database mail,but failed who can tell me which is appropriate way TIA I saw your different threads in the groups, did you manage to setup database mail, this should be the first point where we should start. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• leclerc9 Rank() and using WHERE clause on results

  Hi, I am trying to return the 100th ranking in my SQL, ie SELECT DailyValueChange , BUSINESS_DATE , RANK () OVER ( order by DailyValueChange ) AS RANK_Vals FROM Table WHERE ( BUSINESS_DATE = @CurrentBusDate ) AND ( RANK_Vals = 100 ) However when I try to update the Stored Procedure it tells me RANK_Vals is an invalid column name, which is not the case as if I run it without the Where clase it runs and returns all results. Any advice on how to get around this would be greatly appreciated. Cheers Mark Mark: Try layering your select query such as: set nocount on declare @currentBusDate datetime set @currentBusDate = '10/25/6' declare @ ...Show All

• Smartpatrol How do I set the visible property of a report field based on the value in the field?

  I have tried doing an IIF test on the value of the field, but, I can't figure out how to reference the "NAME" of the report field, not the database value but the name of the field itself. Any ideas There is a ReportItems collection. So in code you could do ReportItems!textbox1.Hidden = True or write an expression for the Hidden property of the textbox you wish to hide referencing the database field e.g. = Iif(Fields!some_field.Value = some_value, True, False) ...Show All

• Tom Janssen Flat file CSV problem

  Hi all, I hope someone can help with a problem i'm having. I want to process a large number of CSV files into various tables in an SQL database. The CSV file contains entries on a row by row basis relating to specific events (indicated by an eventID in column 0). Eventually i think i want to be using a conditional split to process each row seperately depending on the eventID but before i get this far i am having a problem with the source data. Each event can have varying amounts of columns filled in in the CSV file. And each CSV file can have multiple event types in it. The flat file manager seems to merge a number of different rows into one within the preview pane. It seems to ignore the end of row delimiter of CrLf. Can anyone please hel ...Show All

• Andrea Pagliano How to map new columns to an oledb destination using script?

  Overview of my scenario: i have an SQL table with 10 columns. I read data off a csv flat file source and insert / update them into the sql. No problems there. Now, after the 10th column, the columns are variable from site to site. Ie, for any customer, the first 10 columns are the same but the following 'n' number of columns can be different. I'm already able to detect what are the 'custom' columns from the source db and can programmatically add / modify the columns to the destination sql tables when SSIS runs. My problem now is, i have the flat file source with 'fixed' and 'custom' columns together, and my sql table is ready to receive them, but i don't have the proper column mappings in my SSIS package. I only have mappings for ...Show All

• Steven Berger how to design dynamic reports based on user's choice

  Hi all, I'm a beginner to Report Services, and have tons of questions. Here's the first one: if the reports are created based on the condition that the user selects, how can I create the reports with Report Services For example, the user can select the fields that will be shown on the reports, as well as the group fields, the sort fields and restrict fields. So I would not be able to pre-create all possible reports and deploy them to the report server, and I think I should create the reports dynamicly based on what the user select. Could someone tell me how to do it (create and deploy the reports) Thanks a million! Jonee I think this it's possible to certain extend, but not sure i ...Show All

• devstuff How to handle ISNUMERIC() function ?

  I have a task (Derived Column Task) and I want to write something like this : IsNumeric(aColumnOfString) == true "All numbers" : "there are some characters" Here aColumnOfString can be something like "123a5" or 12345". I do not want to simply check if the left-most character is a number or not. I want to check the entire expression and return me a TRUE or false. A TRUE is returned if the entire expression contains ONLY numbers, and FALSE otherwise. I read some posting using regular expression. But that is not a solution for this situation. Anyone knows how to accomplish this, please help! Steve, To determine if a string contains only numbers, you could use the data conv ...Show All