Answer Questions

• Jorne Syntax format in guide

  Sorry if this thread is already affronted... but i'm not able to find in previous messages... The syntax of topics displayed in new book online appear on a single long line, so I have difficult to read.... Anyone have the same problem Thanks... I haven't been able to reproduce the problem, but from the image, it appears you have an out-dated version of Books Online anyway. There is an April 2006 version available in all languages. In the April version, the Mobile topics are incorporated into the larger Books Online set. From the Index tab or Search tab, you can filter on Mobile if you just want to view topics related to Mobile. Here's the download site. http://www.microsoft.com/technet/prodtechnol/sql/005/downloads/boo ...Show All

• balusmca UDM cube wizard

  May I know how does the cube wizard able to detect the dimensions and measures What is the logic How can a table be dim and measure as well..thanks. Regards Alu Take a look at the DSV diagram in BI Dev Studio. Edward Melomed. -- This posting is provided "AS IS" with no warranties, and confers no rights. Hi may i know what does outgoing and incoming means Thanks. Regards Alu The logic in the cube wizard is pretty simple. It analyzes the table relationships and suggests that every table with all the outgoing relationships should become a fact table. The table with incoming relationships - dimension. Edward Melomed. -- This posting is provided "AS IS" with no warranties, and confers ...Show All

• the_kid Strange out of memory error on 2005

  Hi, I am getting the following: spid53,Unknown,Failed Virtual Allocate Bytes: FAIL_VIRTUAL_RESERVE 262144 spid53,Unknown,Memory Manager <nl/> VM Reserved = 1662084 KB<nl/> VM Committed = 954940 KB <nl/> AWE Allocated = 0 KB <nl/> Reserved Memory = 1024 KB <nl/> Reserved Memory In Use = 0 KB ... <lots of memoryclerk/cachestore stuff) ... Followed by loads of 701s (There is insufficient system memory to run this query.) until the service is stopped. No new connections can be made at this time either. I'm running an ASP page under IIS 5.0 (on 2000) against the SQL Server. Connections are being pooled. The page just calls a stored procedure and passes some results back to the ...Show All

• roy182 Scheduled Subscriptions, ScheduleRecurrence and the ICalender Recurrence Rule

  I am working on getting a subscription management interface put together for my product's implimentation of Notification Services. I have a question about the capabilities of the Scheduled Subscriptions, specificaly about the flexibility of the ScheduleRecurrence property. below is a copy of recurrence options from books online... ICalendar Recurrence Options FREQ=DAILY; FREQ=WEEKLY;BYDAY= DaysOfWeekList ;[BYMONTH= MonthsOfYearList ;] FREQ=MONTHLY;BYMONTHDAY= DaysOfMonthList ;[BYMONTH= MonthsOfYearList ;] FREQ=YEARLY;BYMONTHDAY= DayOfMonth ;BYMONTH= MonthOfYear ; It would apear that Daily is the smallest unit of recurrence supported, but we would like to have a recurrence option in a period o ...Show All

• Deeps_123 Report Server Setup when query against terabytes of data

  Hi all, Can anyone point me to a resource on the best way to setup and use SSRS 2005 when reporting on tables that could have 1 billion rows. The database in question will have mulitple schema's each being at least 1 terabyte in size. Thanks -JW The size of the database matters much less than the size of the data you want in the report. My advice is to push as much filtering and sorting logic as you can into the back end database and return only the result set you want to display into SSRS 2005. Assuming you filter the data down to 20-100 page reports, going against billions of rows and terabytes of data is not difficult. Thanks. Donovan Smith Thanks Donovan ...Show All

• i-developer SQL Server 2005 SP2 released !

  Everything including Readme, updates books online etc can be found here: http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/servicepacks/sp2.mspx Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- The readme for SQL 2005 SP2 lists Windows 2003 SP1 as supported OS. Does this mean that SQL 2005 SP2 will not run on Windows 2003 SP2 Sure it will, guess the documentation was not updated. Thank you to everybody who has submitted feedback on Microsoft Connect and through the MSDN forums.  We have taken a lot of your comments/ideas into account for SQL Server 2005 Service Pack 2.   Specifica ...Show All

• widd Connection Manager Keeps External Metadata information

  We have a Main package and which is calling 2 more other packages. The first package contains a connection and we are using a Dataflow task. The data flow task has OleDB Data source which is taking getting columns using a Stored Procedure. And the output we need to write in a Flat File. The second Package also contains the same(The same Tasks, Database and Stored Procedure Calling) The difference is in the stored procedure Parameters. Based on the different parameters Stored procedures returns the different Columns and Rows output. When we are trying to Get the second package output in OleDb Data source it shows all the columns which is the output of the First Package because it stores External Meta Data. So My understanding is the Connect ...Show All

• Neil East Howto Add new Parameter in Report using ReportViewer in ASP.NET?

  Hello, I am starting to work with reporting services. I want to make a asp.net page with as reportViewer-Controll. I want to add at runtime a new parameter to the report with vb.net How can I do that Is it possible Thanks and Best Regards Gerhard You have to modify the report definition in order to get a new parameter. The ReportViewer control consumes and is driven by a report definition, but it has no control over the report definition. ...Show All

• Avotas Reducing the PDF File Size

  Hi all. I'm using MS SQL 2000's Reporting Services. Our output PDFs are usually composed of fifteen or more pages. Our file size typically exceeds 2 MB per report, I was testing the report on sample outputs and I was getting around 40kb per chart and each of our pages are typically composed of 2-3 charts. Is there a tweak that can be applied to reduce the file size of the output pdf Thanks, Edward An issue has been opened for this problem. Please add your vote. https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx FeedbackID=232211 DO you have any images rendered into the report As the report is based on Adove 4 definitions its limitated to the render ...Show All

• Jeanvo SPLIT AN ARRAY!

  dear friends, I have a stored procedure that receives a parameter like ' 123#67#1#89#52#' I need to insert each number (123, 67, 1...) in a table... How can I do it using the best performance Thanks!!! Cheers!!! Phil, I cut the parentesis and the error still there! :-( Thanks! Jean, But I need is to extract each field in a while, and insert each extracted value in one table. The example you gave me is not too long for my case Thanks!! How can I do it ! Could you give me an example thanks Dear Mark, Your example works, but I need to create a new table. Probably is more fast and data is more consistent, but is one more object... I will think on it... :-) Unless I have one solut ...Show All

• Sandrina Using Report Builder On External Web Apps

  Can someone point help me with the requirements for using Report Builder in an external web application In our case, we'd like to give users access to report builder, but the user are coming in anonymously over the web in our app, so they won't have a Windows user account. If there are any articles related to how this must be setup and whether any features are disabled in this mode, I'd appreciate the help! Thanks ...Show All

• agody Can i connect to SQLExpress instance using (local)

  Hello, I am using the following connection string to connect to SQL Server 2005 Express Edition installed on my local PC. string sqlstr = "Server=(local);Database=MyDB;User ID=sa;Password=sa;Trusted_Connection=False"; And it gives me the following error. The string works fine in computer with SQL Server 2000 instance but fails with 2005. The string also fails for "Server = localhost". However the string works very fine if I use the name of Server 2005 i.e ./SQLExpress =================================== Cannot connect to (local). =================================== An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the ...Show All

• Cobaia Tracing the deadlock

  Hi, I need to trace deadlock, one of article was mentioning “QL Server Profiler's Create Trace Wizard to run the "Identify The Cause of a Deadlock" for SQL Server 7.0, is there any way I can do this in Sql Server 2000 The Locks Event class contains two events for deadlock (Deadlock & Deadlock Chain) that you can use. See BOL for more details. SQL Server 2005 new graphical way to show the deadlock information in profiler. See the blog post below for some details: http://blogs.msdn.com/sqltips/archive/2006/06/12/628773.aspx SQL Server 2005 BOL also has several topics on deadlock troubleshooting. ...Show All

• KitGreen Performance issue in MDX query

  Hi All, I have the following MDX query which takes around 3 minutes to execute in spite of my fact table containing only around 800 rows. The dim classification no hierarchy dimension contains around 10,000 members. with Set [Time1] AS {[Dim Time].[FullDateAlternateKey].&[2003-07-01T00:00:00]:[Dim Time].[FullDateAlternateKey].&[2004-07-01T00:00:00]} member [Incident Count] as 'Sum ( { [Time1] },[Measures].[Estimated Incident Count]) ' member [DTS] as 'Sum ( { [Time1] },[Measures].[Days To Solution]) ' SELECT NON EMPTY CROSSJOIN ( AddCalculatedMembers ({[Dim Project].[Dim Project].[ALL]. CHILDREN }), {[Incident Count], [DTS]}) ON COLUMNS , NON EMPTY TOPCOUNT ( AddCalculatedMe ...Show All

• Redfox72 The product level is insufficient for component

  We are trying to run SSIS DTSX packages from a VB.Net 2005 application and we get this error : The product level is insufficient for component. The server is SQL 2005, the clients (for which the VB application is run from) have SQL 2005 Client tools (since there are running XP). I know this is a known issue, as SP1 corrected the import/export problem in Management Studio, can we expect a similar fix when using SSIS locally on a client's machine via a VB.Net application and SQLServer 2005 assemblies We are currently in the process of migrating our VB.Net 2003/ SQL2000 applications to VB.Net 2005/ SQL2005 and do not want to change the way we process our data, as we expected 2005 version to have the same functionality as 2003. T ...Show All