Answer Questions

• David Funez Reporting Services Capabilities

  Hi all, I'm kinda new to reporting services, and I would like to know if I can generate reports so that the data inside them can be updated directly to the SQL Server by the client. For example: Lets say that I have a report that crosses information from some tables in my SQL Server database. I want my client to be able to update the data on those tables directly on the report, as he sees it. Can this be done by SQL Server 2005 Reporting Service ...Show All

• Einat Cart data row

  I have a SQL table with summary data.  I want to display a pie chart for fields in each row and a table that displays values from the corresponding row. I have a table and pie chart defined.  However the pie chart only displays for the first row in the table.  The table repeats ok for each row in the table.  I have tried placing a rectangle on the report and putting the chart and the table in the rectangle but it still wor ...Show All

• Rob Weiss Set Primary Key when normalizing data?

  Greetings all, I have created an SSIS package that takes data from a very large table (301 columns) and puts it in a new database in smaller tables. I am using views to control what data goes to the new tables. I also specified that it drop the destination table and recreate it prior to copying the data. The reason for this is so that old data removed from the larger database will get removed from the normalized databases. I have 2 thing ...Show All

• RomiHsu Conditional Split to send top 10, top20, and top 30 in three different flows ?

  I  have dataflow that i wish to split. The recordset that i uses is sorted by the Sort Task. After that i'll like to take the Top 10 records and send in one direction, then ill like to take the top 20 and send in another direction and finally Top 30 in a third direction. How can i do that Out of interest, would you want to send: Rows 1-10 to output1 Rows 1-20 to output2 Rows 1-30 to output3 or Rows 1-10 t ...Show All

• Werner Sandner Management Studio Still will not install

  I followed the thread " Re: Management Studio for SQL Server 2005 Standard " But these remedies did not resolve the problem. Environment: AMD Athlon64 XP-Pro 64 2gig ram Office Pro 2003 Visual Studio 2005 SQL-Server 2005 Developer I get an error at the end of the install attempt: None of the selected features can be .... and so on. It is saying that the reason is because the upgrade is blocked....SQl-Serev ...Show All

• HowardRichards Cant connect to SQL Server 2005 Express from VStudio 2005 pro.??

  Hello I can't do subject. It says the SQL Server does not allow remote connections, but in SQL Server surface area conf. it is turned on. What to do Cheers Got it to work now. I wrote localhost as with SQL Server 2000, and changed it to .\SQLExpress Cheers ...Show All

• Ja1970 Can SSIS work in a Cluster

  We have just installed a new SQL 2005 Clustered server and loaded integration services. However it appears that integrations services may not work properly in a clustered environment. So can integration services be setup on a clustered SQL 2005 server How about if this is a multi instance cluster In the config fil there is only room for 1 server/instance of SQL. <ServerName> K-CLUSTER2-SQL1 </Serv ...Show All

• Frank Palinkas Creating report based on parent-child dimension

  Hi I have a problem to create a report based on a parent child-dimension When I go to reporting services, and I create a new report based on a cube, I drag my parent-child dimension to my data-layout. Then the dimension is immediatily ragged down. Anyone an idea to solve this. I have the same problem and didnt' find a solution for it. What I really want are the little +/- signs so i can open/close the children ...Show All

• ?? How to limit a db owners cpu/memory usage

  Hi there, Is there a possibility that i can limit a user's cpu/memory usage so that if this user (the database) generates a report, this process won't hang up the whole sql server thanks in advance edgar Not exactly. You can prevent a query from running by setting Query governor cost limit, but this will stop all queries with a cost above the specified threshold from running at all. There ...Show All

• Bruce Adkins Materialized View Doesn't Materialize. (and queries on MVs ignore index hints)

  I am creating and indexing a view. The index does materialize physically (i think -- since sp_spaceused now returns values -- not nulls) But any query searching the view does NOT use the materialized index. Here's an example: -- Create/Populate test table create table test ( i int constraint PK primary key ) insert test select 1 union select 2   -- Create View set ansi_nulls , ansi_padding ...Show All

• auky setting variable value

  hi ! I am trying to set the variables value through Execute SQL task and create directory through the FileSystemTask by setting the user variable as source. The User variable has the Directory path to create the directory, but when i set the source as the user variable it complains that its value is empty. Execute SQL TAsk happens to work correctly when i check the watch window the user variable is set correctly . but value is not setting ...Show All

• Brian Donahue Is this a bug??

  i use AMO to connect MSAS2005. Seems everything is fine except i do like this: I try to restart the Analysis Service, and then connect to the server. This will cause windows prompt msmdsrv.exe error or debug info sometimes. This comes with the Connect() methed, but the codes will continue running - that means the code doesn't throw exceptions and executed as usual. I tried to sleep the thread for a while(Like in code make 10 seconds sleeping) ...Show All

• paprika use multiple databases as source for report builder

  I have table's in multiple databases. I am trying to access them in the report builder. I tried view's but it doesn't display them. any Idea's. You need to open model designer, open the DSV based on views and for all views define PK/FK columns. This is require by model generation wizard - otherwise it can not generate entities and roles. I think this requires VS 2005. Create new report model project. ...Show All

• Akella Query problem - TIPOS IN ()

  Hi, I have the following query SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO ALTER PROCEDURE CONSTELEFONICA @E1 VARCHAR(50), @TIPOS VARCHAR(50), @PERINI DATETIME, @PERFIM DATETIME, @PERINI2 DATETIME, @PERFIM2 DATETIME AS SELECT DATA_HORA, LOCALIDADE, VALOR_TEMPO, VALOR_TARIFA, CLASSIFICA_TELEFONICA, VALOR_TOTAL, NRTELEFONE, NUMERO_E1, @PERINI as DATA_INICIAL, @PERFIM as DATA_FINAL FROM TELEFONICA WHERE NUMERO_E1 = @E1 AND D ...Show All

• sumguy How Create SQL CLR Functions in Yukon June CTP

  I don't believe there is a compatible VS.NET release for this CTP so how are folks creating SQLCLR functions/sprocs   Command line   Any pointers to articles Thanks, Chris Thanks.  The CTPMadness tool on Channel 9 was missing this combination. Chris Whidbey B2 is compatible with this version of SQL Server. You can also use the samples and just compile them at the commandline assuming you have the sdk installed. ...Show All