Answer Questions

• yxq SQL Server Profiler Cant Dump To Trace Table

  After upgrading SQL 2000 to SQL 2k5 I cannot dump Profiler Results to a table anymore. the trace immediatley fails with the following Error: "Failed To Start A New Trace" so, I run the Trace dumping results to a trace file or just to the UI\grid and later attempt to "Save Output As Trace Table" and receive the following Error: "Failed to save table XXXXXX. Cursor operation Conflict" What Gives Has anyone else seen this issue with SQL2k5 well..... therein lies the problem. I installed SQL 2k5 on this specific server as a test to consider upgrading production to SQL2k5. We are very motivated to migrate. However, with the issues I'm s ...Show All

• Kikkoz Excel 2003 PivotTable Field List measures sort order

  We have OLAP database migrated in AS 2005 but still using client Excel 2003 Pivot table reports. Finally all dimensions looks good. As we expect in Excel 2003 field list - measure groups and calculated members are coming in one flat list but "there is no sort order". I looked in to properties of cube (in my case virtual cube with 5 linked cubes/object) and dimensions didn't find any thing. I know we can arrange order with in one cube by using "move up/move down" option but that doesn't help when there are more then one cubes and calculated members in virtual cube. I need to some how sort in virtual cube or while reading virtual cube from excel. ( sorry! don't know what to call the cube with 5 linked cu ...Show All

• DavideB Chaging the Min and Max Scale of a Chart at run time

  I have a stored procedure which will bring me back the Min, Max and Mean of different result sets. What I want to do with the Y-Axis is set the Min scale value of the chart to be Min -%5 and the Max scale value to be Max + 5%. Is there a way to change the Y-Axis values at report run time without spitting my own RDL In RS 2005, the Min/Max/CrossAt/MajorInterval/MinorInterval settings can be expression based. Note that by using an aggregate function such as first you can even reference certain values from another dataset than the chart is bound to. For example, you could use an expression similar to: =CDbl(First(Fields!MinValue.Value, "StoredProcDataset")) - 0.05 -- Robert Hi! ...Show All

• PeterPan1120 Credentials used to run this report are not stored

  Hi all, When I create a new report subscription in report manager, I got this error Credentials used to run this report are not stored any idea Thanks, Jone Glad I could help Jone, can you mark this one as answered so others can view the solution Jarret Could you use a Windows domain account and it's password Then, you will need to check the box for 'Use as Windows credentials when connecting to the data source' also. Jarret Thank you, Jarret. I used my user name an dpassword that I use to login my machine, and checked the 'use as windows credentials when connectingto the data source', and the subscript ...Show All

• Tobias Boehler SSIS Reference Manual

  I never had to use DTS in MSSQL 2000 but I'm finding a need to use SSIS quite a bit in a new position. I know this is subjective, but I looking for suggestions for a reference book with good examples and tutorials. TIA I have Brian's book, and I found it very useful. As you want a book with good examples and tutorials, then I would recommend it. I've not read Kirk's so cannot comment on it. I hate to say anything detrimental to Brian's sales levels but if you want a deep dive into SSIS then Kirk Haselden's book is the one to go for. It really is superb. -Jamie P.S. In my opinion the fact that you have never used DTS is advantageous to learning SSIS. It's ...Show All

• Sameep How To Get User Input in Query

  I m new to SQL Server. Before this I was using access. In access one can have user inputs easily .. for example where receivedate=[enter date] how I can get userinputs in SQL server Query.... Forgive me if it is a dumb question I know what you mean, but user interaction is not possible in SQL Server like in Access as SQL Server is no frontent application. The best thing would be, as already mentioned to use parameterized queries and letting your frontend application fill these params with the respective values. HTH, jens K. Suessmeyer. --- http://www.sqlserver2005.de --- Vow   -   Great, Thanks a lot. 1. Why did we make a s ...Show All

• Gied Usage base aggregation design.

  I have collected statistics of cube usage. I start Usage Based aggregation wizard, but it shows 0% stubbornly for reached performance gain. What to do Is this wizard mature thing (SP1 + hotfixes) or better to leave this thing on the shef and make aggregation manually Usage Based optimization wizard is running variation of Aggregation Design with additional weights given to the aggregations answering queries logged in QueryLog. You should first take a look at the things that influence aggregation desing algorithm. Analysis Services performance guide talks in length about aggregation design. Take a look at the AggregationUsage property. As for the future. You should expect upcoming SP2 going to have ...Show All

• dddon Issues With SQL 2005 Encryption

  Are there any pitfalls i should look out for when using the encryption in SQL 2005 Heres the Message error: Msg 15315, Level 16, State 1, Line 1 I opened the key then used the Alter Statement. Thanks Just to clarify, have you tried calling "select * from sys.openkeys" right after your open key statement (before your alter)   Was this result blank For the database, are you backing up the database from your main server and restoring this onto your test server   If so, are these two machines in different time zones   If you are restoring a database in two different time zones, you may get errors trying to use symmetr ...Show All

• Kalpesh Sharma vs Ankit Fadia Having Problems Installing SQL Server 2005 Express

  I am running WinXP Home edition, and I was trying to install SQL Server Express, but the error message is too vague for me fix. It says my computer lacks the "Service Pack Requirements" to run the software, but I'm afraid I don't know which service pack requirements the error is talking about. What Service Pack do I need to download Here is the report from the install: System Configuration Check - WMI Service Requirement (Success) Messages WMI Service Requirement Check Passed - MSXML Requirement (Success) Messages MSXML Requirement Check Passed - Operating System Minimum Level Requirement (Success) Messages Operating System Minimum Level Requirement Check Passed ...Show All

• Lama Karmi MDX Prior Year Calculated Members

  Hi, I have a report from a cube where the user chooses a year from a single value parameter, and then months from a multi value parameter. Based on what they choose I need to display the current year Revenue and the prior years Revenue. I have tried to this by creating a Calcualted Member for the prior year: (ParallelPeriod([Dim Time].[Year - Month - Day].[Year]),[Measures].[Revenue]) The problem is that when I do this the Current year revenue is displayed for the year and months choosen but the prior year displays the entire prior years revenue dispite what months are choosen. Is there a way that I can display the prior years revenue based on both the year and months that are choosen ...Show All

• eroe For each Loop Container do nothing inside

  Hi, A very strange thing happened to me. I have a package that includes two For each loop containers. Each container has script tasks, sequence containers, etc. Both are Foreach ADO Enumerator basis. It works without any problems until I changed the position of one of them in the Control flow and added some code in the script task. After these changes I executed the package and both of For each loop containers did not execute the tasks inside of them, any task. However the execution color on the containers was green (success). How can it be Your help is much welcome. Thanks in Advance. Joao Cruz Not enought nformation to tell really, but likely related to the code ...Show All

• Ofer Gal formating values in chart

  hello to every bodu. well i am truing to create a line chart in sql server reporting services and when in the data field i put the division of 2 values. i want to have a % represerntation does anybody knows how i can achieve that than u in advance Moving to Reporting Services forum. Steps: * open the chart properties dialog by right-clicking on the chart * go to the Y-axis tab * set the Format code property to e.g. P1 (which results in percentage value formatting with precision of 1) -- Robert ...Show All

• IgorV OpenQuery() to Linked Server hangs, leaving SPID with open tran, then templog.ldf grows without limit.

  Hi, We have a customer that is using SQL Server 2000, and experiencing the following intermittent problem -- occasionally templog.ldf will grow and grow until it fills the entire disk. This is a rare problem, it has happened less than 10 times in the past two years, for a job that runs once a minute. But it has happened on 3 different SQL Servers, (two production servers, and one test server). Our suspicion is that the root cause is an OPENQUERY() to pull data from a linked server (Oracle database on Unix). We have seen that these OPENQUERY() statements occasionally hang and cannot be killed. The OPENQUERY() is used to populate a local table, and when we originally populated permanent tables with OPENQUERY(), then there would be a ...Show All

• Musa_Tariq_Raza Basic business rules question

  How do you represent business rules in SQL Server I need the database to return an error to a .net app if a business rule fails. Thank you! :) triggers can cause problems and many people (Self included) recommend against them 1. if the trigger contains much logic, it can hurt performance 2. if you're trouble shooting a slow stored procedure, you will NOT see the trigger code in any query plan. in fact, you wont even know the trigger exists unless you explicitly go look for it. This can cause you to spin your wheels trouble shooting the sproc, when the performance issue is in the trigger all along. (Maintenance nightmare) 3. it's preferable to use constraints 4. IF you must use triggers, be ...Show All

• Ryan F Transactional Replication from SQL Server 2005 to SQL Server 2000

  I am trying to test simple replication (only tables) of a database that resides on a SQL Server 2005 instance to a SQL Server 2000 instance. The Publisher and Distributer are set up on the SQL Server 2005 instance for Transactional replication. The subscriber is set up on in the 2000 instance. Replication Monitor shows the following error after applying a few scripts: " Category: SQLSERVER Source SQLSERVER2000 Number: 170 Message: Line 6: Incorrect syntax near 'max'." Here SQLSERVER2000 is the name of my 2000 instance, as should be obvious. Beyond this point, replication fails. Any pointers as to where the problem could lie Is this a known backward compatibility issue I've checked all tables in the database and none cont ...Show All