Answer Questions

• aliasx Two tables, one dataset. Performance?

  If I create a report with one dataset referenced in two tables, will the dataset be queried twice, or once, and copied to both tables (preferred). I am trying to create a report with a summary report and then summarized detail report, both using the same data. I have done the same with one dataset. Works good. Using SQL Profiler shows that the query only executes once. I am using multiple tables also. BobP ...Show All

• pcompassion Performance Problems with SMI

  I have a subscription management interface that seems a reasonably thin wrapper of the NS API. Whenever I do gets, it takes a tremendously long time to process. For example, when I do a GetSubscriptions for a user (very thin wrapper around SubscriptionEnumeration()) it takes roughly 40s to return on one of my servers which is an old P3-866, and 20s to return on my dev VM (on a physical Intel Dual Core 2.0Ghz). CPU is hit pretty hard during those calls. This also seems to happen when I get SubscriptionClasses. I've looked through several samples, some from the NS Samples included, some from 3rd party books, and all seem to have similar calls, without mention of performance problems. Is there something I might be doing wrong Or is this e ...Show All

• rgny Need sql script or statement to extract all relations from one tree

  Suppose I have a table with relations (REL). In this table there are relations between parent en child, so the columns are: Rel_Id, parent_Id, child_Id. Example: 1, A, B 2, A, C 3, A, D 4, B, E 5, C, F 6, G, H 7, G, I 8, H, J I need a query which returns all relations from REL that are in the same tree as the input unit. In the example, giving D as input unit, it should return relations 1, 2, 3, 4 and 5, because A, B, C, E and F are (in)directly related to D and belong therefore to the same tree. Giving H as input, it should return relations 6, 7 and 8. (with a tree, I mean that a parent can have 0, 1 or more children and a child belongs at most one parent.) Thanks for your help in advance! Adam ...Show All

• IgorLiokumovich What is replication?

  What is replication where used Replication 101 right here: http://msdn2.microsoft.com/en-us/library/ms151198.aspx . ...Show All

• MeniB AS2000 - Different default dimension member according to cube

  Dear all, Is it possible, in AS2000, to choose a different default dimension member according to the cube we are looking at I'm in a project where the Accounting cube should open on the last closed month and the sales cube on the current month. Is this achievable Regards, Pedro Martins Portugal Hello. This is from my(weak) memory. If this is possible in SSAS2000 you should be able to set the default member on the dimension in the cube editor. Have you checked this I do not think it is possible if you use a shared time dimension in two cubes. I think that you set the default member in the dimension editor(advanced properties). One solution is to build two separate time dimensions, ...Show All

• rod_r data conversion - numeric to string loosing precision

  Hi All, i'm using a "data conversion" object to convert a numeric field to a string just before i save the record set to the database. the problem is when this numeric field is > 0 it looses the precision on its decimal value. example, if numeric value is 0.32 after converting this to a string, the new value will be : .32 it's lost the 0 infront of it. i can't do this converion in the query level because it's a derived field, so i need to convert it to a string before stroing it. when converting to string i'm using the code page 1252 (ANSI - Latin I). i also tried with unicode string both looses this 0 infront. can any one help on this Hi Mark, thanks for that, but it sort of half answer my ...Show All

• 40th Floor Batch SQL

  Questions I need to batch a set of update commands. Can that be done and if so what are the possible ramfications Can one mix / match Deletes/Inserts and Updates into a SQL command via the semi-colon in a batch set (Is this the appropriate forum ) WHY I am unable to use the dynamic sql building found in the dataset due to a multiple table contstraints. I have built classes that will extract the differences from two datasets and report on the updates/deletes and inserts required. Since I have multiple SQL statements, it would be nice to combine them into one statement. Platform .Net 2 C# IIS6 SQL Server 2000 is the eventual target database for the generated SQL advTHANKSance Regarding Transact-SQL it is possible to co ...Show All

• Brainsponge SQl Server 2005 installation Is depend on installation of visual studio 2005?

  Hi every one, I'd like to install SQL SERVER 2005 Express Edition ,I begin to install it from DVD but during the installation it dosn't ask me about any instance and after installation there isn't SQLExpress service and I can't use sql server .(there are not MSSQL and Binn directory in sql server 2005) but when I install visual studio 2005 and after that I install sql server 2005 it ask me for name of instance and with this way every thing is ok and I use sql server completely. I 'd like to know the complete installation of sql server 2005 is depend on installation of visual studio 2005 befor it if not how can I introduce any instance after installation of sel server 2005 . Hi Orchid, You can download SQL Express directly ...Show All

• Dabi Error: 7886, Severity: 20, State: 1.

  Hi All I am seeing this error being logged in my SQL 2005 Ent machine A read operation on a large object failed while sending data to the client. A common cause for this is if the application is running in READ UNCOMMITTED isolation level. This connection will be terminated . It seems to be arising out of a read of a text column. Any info on this will be appreciated. Thanks   K T Ah, you use 'nolock' hint. There are issues with using such hint. I suggest you take a look at the following KB. http://search.support.microsoft.com/kb/235880 No ! I'm still having the same problem.. My sql query results about 100Mb of information. What can I do ...Show All

• MGorgone WHAT NEXT AFTER INSTALLING SQL SERVER EXPRESS?

  I have installed SQL Server Express with Advanced Services SP1 option. I am not really sure if I should have done this but I could not resist the temptation to have as many options as I could get. I even installed some samples/sample databases. However, I cannot understand how to start using the SQL Express package which (unlike the Visual Basic 2005 Express or the Web Developer Express I also downloaded) does not show me a start up page. I get SQL Server Configuration Manager, SQL Server Error and Usage Reporting and SQL Server Surface Area Configuration, all from Configuration Tools. I have no idea how to proceed. Could I have downloaded the wrong package Ok well I'd install the tools next. You c ...Show All

• Vijay Chegu 2nd Post - Problem installing SQL Server 2005 Express SP2

  Hi, I started applying "SQL server Express with advanced tools SP2" and had to stop on following items which I'm not too sure about what I must understand from step "Existing components". Those three items listed were: - "SQL Server DataBase Services 9.1.2047.00" => which I can check - "Reporting Services 9.1.2047.00" => which I can check - Workstation components and development tools 9.1.2047.00 => which is simply disabled If I then look at the details of that last item, I can see the following warning: Name: Microsoft SQL Server 2005 Tools Reason: Your upgrade is blocked. For more information about upgrade support ...Show All

• NukeMan Report Designer Question

  How to Add the Report Designer in my Application I'm sorry , you can't. Report Designer is an add-in to Visual Studio. ...Show All

• DiamonDogX Merge Replication-Apply BCP files

  How can i apply a BCP files generate by Distributor in the Suscribers. I don’t know wich parameters BCP.EXE need. Thanks I need to manually apply because there is few information, and i've configured suscription with the option to no send the schema tables. I've configured the replication via internet (is slow for a very large tables) But now i need to send data to the suscribers. Thanks I thinks I am having same requirements like Jorge, See What I am looking for is quit similar to Jorge's case, I have 2 Database Servers, I have set Merge Replication (Pull) between them, But Sometimes The Connectivity between both of them is not available for many day ...Show All

• wirol Set MaximumErrorCount does not work!

  Hi, I'm new in SSIS and I'm trying to copy data (1 table) from server1 to server2; I've set the MaximumErrorCount to 10 at control flow level, the transfer fails with this message : Warning: The Execution method succeeded, but the number of errors raised (3) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors. 1. I'm wondering why SSIS tells me the maximum allowed (1) even if MaximumErrorCount = 10 do I miss something in settings 2. How to tell SSIS to transfer fails row to flat file and continue to processes next rows. Thank you very match for your help ...Show All

• alexmy5 Restricting export of the Header

  Hello Is it possible to restrict the export of the header when exporting the report from the browser or at least restrict the export of the image. Thanks Inder The answer is no. You can't have conditional rendering based on the target output format e.g. HTML or XLS or PDF etc. What's to stop someone taking a screen caprute or right clicking the image and choosing the "Save Picture As..." option in IE Thanks ...Show All