Answer Questions

• markse Formatting/CR in Report Manager Report Description

  Is there any way to format or add a CR to the report description in report manager Thanks! BobP Ya know... I knew you were going to say that... Thanks! I'm afraid there is no way of doing this. ...Show All

• Uwe Heinkel SSAS crashes - mining predictions for large data sets

  Hi all, I am using SSAS 2005. The mining model works fine. But it crashes when I run the 'Mining Model Predictions' against large data sets. I ran it against 5,000,000 records and it went fine. But exactly same model failed for 5,100,000 records and beyound. The message is 'Query Execution Failed' and then Visual Studio crashes. Pl. let me know if anybody has the same experience or knows the solution. Thanks, Vikas Jamie, Thanks, I'll try to use IS or RS. Vikas You are trying to run the query inside visual studio for > 5M records It shouldn't crash (this would be a bug), but that environment is not particularly designed for vary large query results. The prediction tab is generally for designi ...Show All

• wbrogdo1 c# against ms sql express - multi user access

  I have developed two programs that operates against the same database. One of the program is just a display program that displayes the data put into the other administation program where you put in the data to be displayed (an administration program). Every time I access the db from the administration program, the display program stops and throws connection pool errors and other database errors. For me, it looks like it does’t do multi-access to a database. I have tried putting user instance to off in both programs, but this didn’t help. Connection string also points to same file database. Never mind.. forgot the initial catalog... It sounds like you're try ...Show All

• Tobias Boehler SQL 2005 Server DDL Trigger Errors

  Greetings! I've been working on a SQL 2005 project, and have really been excited about the new DDL triggers. I managed to implement some database-level DDL triggers successfully. However, I keep getting an error when I try to create a server-level DDL trigger. For several of the event groups, I keep getting the following error: Msg 1082, Level 15, State 1, Procedure tr_Server_Audit_Security, Line 44 "DROP_SERVER_ROLE_MEMBER" does not support synchronous trigger registration. I can't figure this one out for the life of me. Here's a sample of the trigger I'm trying to create (BTW, this code works for database triggers, with some slight mods of course): create trigger tr_Server_Audit_Security on all server  for drop_server_role ...Show All

• vutkuri Funny error during runs

  Can any one please help explain why this error has happened, it is not a normal error of SSIS, "SSIS Debug host has encountered a problem and needs to close. We are sorry for the inconvenience" It has 2 buttons Debug and Close, this error happened in the middle of a script task. This is a classic Microsoft problem. I face this problem often. These are the scenarios on which I usually get this probelm: 1. If there is less memory on the client system where VB studio is open, and trying lot of mouse clicks frequently. 2. It is observed more when in Debug mode, when you try to scroll using the middle wheel of the mouse. After I upgraded my desktop RAM to 3GB, and often syst ...Show All

• thedewd Report Viewer Parameter Dropdown width

  Does anyone know how to control the width of the parameter dropdownlist If you select "Multi-value" for the parameter (non-sp1 version) the parameter list is in a dropdownlist that is manageable in size. If you do not use the multi-value parameter, it looks like the width of the dropdownlist is determined by the width of the longest text of the returned parameters. Is there any way to control the width of the dropdown Thanks Rob I spent some time "fighting" with this problem. The only way this might be achieved is to play with the customizable style sheets for the Report Manager. I solved my problem by making the text in the multi-value dropdown smaller. ...Show All

• melara Working with two data sources and dependencies parameters

  Hello. This is a real hard nut to crack :) I'm trying to do the following: I have one dataSource name "dSource1" and second named "dSource2". I have a report with one dataSet base on dSource1 and one dataSet base on dSource2. Now, I want that the second dataSet will return a list of numbers and for the first dataSet to use those number in a query. (example: second dataSet is "select num from t1" and the first dataSet is "select * from t2 where nums in (@allNums)". and of course that @allNums should be the values returned from the second dataSet. Whan I tried to set the @allNums parameter to get his default values from the query of the second dataSet I got the error that say "forward dependencies ...Show All

• Muhsin Zahid Uğur The OLE DB provider "SQLNCLI" for linked server "(null)" indicates that either the object has no columns ...

  When deploying my cube, I somehow have seemed to start getting this error and I can't figure out what I changed or why this might be happening: Error 1 OLE DB error: OLE DB or ODBC error: Cannot process the object "[dbo].[vwTraffic]". The OLE DB provider "SQLNCLI" for linked server "(null)" indicates that either the object has no columns or the current user does not have permissions on that object.; 42000. 0 0 Anyone seen this or have any thoughts on what the underlying cause might be Nope, I'm just trying to process a measure group on my AS server. The underlying DSV sourcing the MG is a view. Really strange - it used to work, but just recently changed and I can't se ...Show All

• K. Murli Krishna SQL Server 2005 JDBC Driver Output Parameter/Result Set issue

  I'm having an issue with the JDBC driver when I execute a stored procedure that both has a return value and also returns a result set. If I attempt to retrieve the return value (registered as an output parameter) after I execute the stored procedure, then any subsequent attempts to retrieve the result set always return null. Is this by design If I use the result set first and then later get the return value that works; however, in my situation I need to first check the return value before I work on the result set. Am I'm I doing something wrong Code: CallableStatement cs = connection.prepareCall("{ = call spGetCustomer( , ) }"); cs.registerOutputParameter(1, Types.INTEGER); cs.setString(2,"blahblahblah"); cs.setB ...Show All

• Fwank79 Hidden Graph and table show up as empty page when rendered to pdf

  I have a report that has 3 graphs and two tables that render to 5 pages in pdf. Some users should only get a subset of the 5 elements and some need all 5. When I set the Hidden property (in the designer or via a parameter) for any of the elements they become invisible but in pdf but the report still prints out a page for the hidden element. It works fine in the designer and rendered to html and excel but I get an extra page in pdf. it is like the hidden element still takes up the same amount of space but is just hidden. Any help would be great. Greg actualy it is the body in those pages that is blank, the header and footer show up I could not get an answer to this problem anywhere. FYI work around/redesign I have n ...Show All

• gigi90 Comparing dates

  HI, In my report there are two parameters,One is for StartDate and One is for enddate.Startdate must lessthan enddate.How to compare two dates in sqlserver report,and if send date is earlier than startdate how to display error message. Thanks in advance You can use the expression as the value of a textbox where you want to display the comparison result. You can use the Parameters collection to reference the value of a parameter - Parameters!StartDate.Value. So you can compare the two dates like =IIF(Parameters!StartDate.Value > Parameters!EndDate.Value, "Error", "OK"). Hi, where we have to write that iif condition.Please help me. ...Show All

• Haff Calculated measure generates invalid value in SSRS report

  Hi, Calculated measure generates inconsistent results when browsed in cube browser and retrieved from a reporting services report (2005). When this calculated measure is retrieved from reporting services report it returns all member based result. Tested on enterprise and developer version. SS 2005 Version: SQL Server 2005 with sp2 (CTP) Sample query based on Adventure works cube: Case When [Customer].[Customer Geography].currentmember.level.ordinal = 2 Then [Measures].[Internet Sales Amount] Else Sum({[Customer].[Customer Geography].[State-Province].&[CT]&[US],[Customer].[Customer Geography].[State-Province].&[CA]&[US]},[Measures].[Internet Sales Amount] ) end ------End of sample code ...Show All

• Jacus83 How to use parameters in the MDX?

  Hi all, I'm working on a project that builds a report in RS 2005 agains the data cube created in AS 2005. I created a report in RS 2005 against database table, and the parameters were easy to be added in the T-SQl query. There are about 15 parameters needs to add in the query, and I can use "IN, =, Betweent.. and ," in the "where" clause, e.g., select * FROM Mytable1 WHERE EmployeeID IN (@EmployeeID) and EmployeeName] IN (@EmployeeName) ... and Salary between @SalaryFrom and @SalaryTo ... and Date between @DateStart and @DateEnd most of the restriction fields are column fileds in the report. Right now, I need to switch the datasource to the data cube, and then I have to u ...Show All

• Milos Kompjuteras bulk insert much to slower on SQL2k5 in compare with SQL2k.

  To understand the problem that I have, I will exemplify but the problem it is general in the SQL2k5. So any BCP insert it is slower with the SQL2k5 in compare with the SQL2k, doenst matter the edition of SQL2k5. 1. First test environment comparing Enterprise versions of SQL2k and SQL2k5 with memory seted 4GB RAM available on the computer it is 6GB Ram(awe enabled), Windows Server 2003 R2 SP1(this window version was special installed because I got the Info that can work better with the SQL2k5).Changing the allocated memory for the SQL Server makes no difference because the SQL Server need only maximum 200MB Ram for the import. I was installing the system database from the both system on the same hardisk and the client dat ...Show All

• jag108 Message: Missing end comment mark '*/'.

  Hi, I created a web syncronization merge replication ,both servers and clients are sql server 2005 and everything is fine with the settings , but while synchronization and after i received some sch files i got the following message at the subscribers on the initial snapshot operation: 2006-06-27 07:50:14.471 The schema script 'myfile_311.sch' could not be propagated to the subscriber. 2006-06-27 07:50:14.471 Category:NULL Source: Merge Replication Provider Number: -2147201001 Message: The schema script 'myfile_311.sch' could not be propagated to the subscriber. 2006-06-27 07:50:14.471 Category:NULL Source: Microsoft SQL Native Client Number: 113 Message: Missing end comment mark '*/'. Any idea Tarek Ghazali SQL Server MVP ...Show All