Answer Questions

• Paulson How to calculate the percentage?

  In my cube, I've a date dimension and a time dimension. I would like to know how can I calculate the percentage of order count for a specific time I can get this. Hour 11/6/06 11/7/06 9am 60 10 10am 80 10 11am 60 20 But how can I get this. Hour 11/6/06 11/7/06 9am 30% 25% 10am 40% 25% 11am 30% 50% I would like to use the calculation feature in available in the cube. How can I do this Thanks! Hi Deepak, I'm using AS 2005. The problem that I don't understand what [DimTime].Parent is pointing to. The Time dimension and Date dimension doesn't have any direct relationship in my cube. Is there any design fault Regards, Alex Alex, With AS 2005, the hierarchy should also be specified ...Show All

• Trisk2 Can not create New Subscription

  Hi, I have a report that I would like to send out to users automatically every day at 10AM. For some reason on reporting server under the report I would to email, I see 3 folders...Data Source, History & Subscription but I am not able to click on "New Subscription" option in order to create new subscription. First I created "Shared Schedule" specifing day, time etc information. And then I am tring to create Subscription but the option is disabled. Is there any service pack I am missing or I am following the wrong procedure. Please advice. - Payal Hi, Can make sure that you have provided an account to run the report and not use the Integrated Security To be able to use Subscriptions, R ...Show All

• Lavee mobile phone and databases

  Can you please tell me what are the risks of customers using a mobile phone to send a request of information which will be automatically responded to as an entry is made into the database. How do I ensure that the data intergrity is maintained, as this 'Table' in the database will take in many request a day and repond based on what the customer has type in on the text message. I did not get your point. What are you trying to do Sending a message to a Service, processing it in the database and sending the processed data, evtl. with a customized text back to the caller Data integrity should be maintained either through constraint rules (Whatever rules you have) or your logic you are trying to implement ...Show All

• Lars-Erik Aabech the error of the SMTP in Sql Server 2005 notification services

  Hi all: I had created the notification services in my  server ,but when I add the subscribers and the subscriptions successfully,it can't send email.The most important is there is no any error to indicate me how to do it . The configuration of the SMTP protocol in the ADF is as following     <Protocol>      <ProtocolName>SMTP</ProtocolName>      <Fields>       <Field>        <FieldName>Subject</FieldName>        <SqlExpression>'Flight notification: '+CONVERT (NVARCHAR(30), GETDATE())</SqlExpression> ...Show All

• Dominik Chrzanowski Import data from a web site

  I'm trying to use 2005 Integration Services to import data from a web address into a SQLServer 2005 database. The address I want to download data from is http://www.nymerc.com/futures/innf.txt I'm not sure how I am supposed to access the data on the website. What kind of connection manager do I use Flat File HTTP When I try to use a flat file connection manager, I set the connection string to 'http://www.nymerc.com/futures/innf.txt', but when I click OK, the connection string gets changed to 'c:\documents and settings\....\Temporary Internet Files\Content.IE5\V01H744)\innf.txt' Is this expected What's the best practice for using a web page as a data source Hi ECDOK, Can you get FTP aces ...Show All

• Khenat.Ram Where's the "NeedsProcessing" property for a partition?

  I know, there is no such property - but is there something similar that I could query inside my Script Task to know whether or not to process a particular partition Thanks.. As I mentioned in several posts this week, there is a very simple way to figure out if there is property belong to an object. That is : use AMOBrowser application. You compile and run this application and then navigate to the object. In your case you can see that partition object has State property. And if your partition is processed it shows 'Processed' value. Edward. -- This posting is provided "AS IS" with no warranties, and confers no rights. ...Show All

• Wayne Sepega Triggers

  Hi, I am pretty new to SQL triggers. I want to create a trigger so if there is any updates on any record, the trigger will insert something to another table. My problem is whenever I have an update for multiple records, only the last record got inserted to another table. Looks like the "inserted" only retain the last record updated. Here's sample of my code create trigger UPDATE_INVENTORY on Inventory FOR UPDATE AS DECLARE @LocationID int DECLARE @TID int DECLARE @doUpdate bit FOR EACH RECORD SELECT @LocationID = LocationID, @TID = TID, @doUpdate = DoUpdate from inserted IF @doUpdate = 1 BEGIN INSERT INTO [Update](LocationID, TableCode, ID, Type) VALUES (@LocationID, 2, @TID, 'UPDATE') END ...Show All

• DavidAtPEfiberoptics How can I ensure that SQLExpress is running and not MSSQLServer?

  Visual Studio 2005 Professional: Windows XP Professional: Frequently, SQL Server (SQLExpress) will be stopped and I am unable to test my application. When this happens SQL Server (MSSQLServer) is running. I have to turn off my computer selecting 'turn off' and do a cold reboot. Selecting 'restart' will not do it. Then SQLExpress is running and MSSQLServer is stopped and I can run my app. How can I ensure that SQLExpress is running and not MSSQLServer Open SQL Configuration Manager Right-click on the SQLEXPRESS service and choose Properties Switch to the Service Tab Set the Start Mode property to Automatic This will ensure the SQL Express is started each time you start your ...Show All

• cipcip Should query against sys.database_principals return same number of rows as query against sys.sysyusers?

  I notice that query against sys.database_principals returns less rows than query against sys.sysusers or sysusers if alias is added to a database. Are there any other way to find all the alias added to a database besides querying sys.sysusers or sysusers Hi PCSQL66, Ashvin is right. this feature has been deprecated. If you do want view the alias apart form querying sysusers. You can use the following command: use databsename go sp_helpuser go regards Jag As alias users are deprecated in SQL SERVER 2005, they are not exposed in sys.database_principals. As far as I know, they are exposed only in sysusers ...Show All

• VictorArce XP_CMDSHELL Issues

  I use dbartisian 8.1 and I am able to connect to multiple servers both 2000 and 2005. When I use the XP_CMDSHELL. I only have issues on 2 servers one is a 2000 and another is 2005. The exact error received for the 2000 box is: Could not find stored procedure 'XP_cmdshell'(42000,2812). I went into mast and found the stored procedure, I know there are permission issues if you attempt this procedure with a lower level security id. However, I'm the server admin and this should not be an issue. I went further into the procedure itself and into the permissions button, in my user id I granted exec permissions to my id and still I have an issue. On the 2005 server. The error message states that this command has been blocked by the server ...Show All

• GrindCrusher Import/Export

  HI , I am importing data from remote database only data is being exported and the Primary Key,FK are not coming and even the stored procedure are not coming. So please any help me out regarding these thing. Hi joey, Can you need me the full details how can i do it. hi sandy, I suggest you configure a snapshot replication configure the articles to have the objects you need. or you can do a full database backup and have it restored on your remote server thanks,   joey ...Show All

• _joe Moving sql 2000 to sql 2005- update query run slower

  Earlier I posted this query in SQL Server Database Engine forum. I am reposting it here. We have upgraded our database server from SQL 2000 to SQL 2005. To migrate the DB I attached the mdf file in SQL 2005. After migration website loads quicker than earlier but records updation ( no of records are 20k) got slowdown. I have found that update query run very slow in SQL 2005 as compared to SQL 2000. Although other select query run very faster. Query is called from ASP (active server page) page. Changing of fill factor option from 0 to 70 also did not work. I also have set the competible leve to 90. OLD Sever Config: dual xeon 1GHz, 512MB RAM, window 2000, MS SQL 2000 New server Config: Dual Core Xeon with 2 CPU, 10 GB RAM, window 20 ...Show All

• Gabriel_M Fatal exception while firing a rule

  Hi, I am having a problem when moving our NS application from dev environment to testing environment. What happens, is that when the rule is fired, a fatal exception is generated. Any hints how I can start hunting down what the source of the problem is. The thing is, this works in dev environment, but not in test. Further, if I try to execute the stored proc manually which fails ( NS_MyAppApplication].[NSFire3] ) I get the same error: A user request from the session with SPID 63 generated a fatal exception. SQL Server is terminating this session. Both dev and test environments use same ADF and ICF files. The ADF file is pretty much like in the InventoryTracker sample, using ConditionAction element like this: <ConditionAction> ...Show All

• Tyf Show non empty cells on the colums only

  Hi, I have a fact table sales, and two dimension tables time and manager. There are 2 rows in the time table (jan,feb) There are 2 rows in the manager table (manager A, manager B) In the fact table sales there is only 1 row (manager A, jan, 100) The following query gives a 2 x 2 table back : SELECT { [Measures].[Sum] } ON COLUMNS , { ( [Managers].[Name].[Name]. ALLMEMBERS * [Time].[Month]. ALLMEMBERS ) } ON ROWS FROM [Testdata] But I want a 1 x 2 table (all time, but only the manager that have data) Adding non empty gives a 1 x 1 table Any suggestions With regards, Constantijn Enders Can you not try and filter the set of Managers so that you only g ...Show All

• OLIRIC can i restore sql 2000 from veritas under sql 2005?

  While ago my SBS 2003 which had SQL 2000 crashed so I had to rebuild everything and this time I used SBS 2003 R2. My SQL 2000 databases were backed up under Veritas 10 and now I'm trying to restore them under SQL 2005. Is this possible Please advice. Thanks, Mike This is great. Thx for the quick reply. Since on my prior server I had databases on drive E and now they are all on drive C, is this going to be any problem RESTORE WITH MOVE is your friend. You can look up details on Books Online. If you mean that you are using Veritas 10 to restore backups taken from a SQL 2000 database to a SQL 2005 instance, then yes this will work just fine. If you are t ...Show All