Only Title

Answer Questions

• Rick X Compiling SQL statement in stored proc

  (I'm sure this is possible, so maybe someone can just mention the topic that covers it and I'll research it from there.) In essence, I have two SQL statements that are 98% the same, but I want to substitute a few different clauses according to the variable passed in. I can get the following simple example to work fine, as long as the CASE statement adds a simple string. But syntax errors appear when trying to use more complex SQL statement ...Show All

• Manuel5 SQL Express Silent install failure

  I am getting this error: Error: Action "LaunchLocalBootstrapAction" threw an exception during execution.  Error information reported during run: "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe" finished and returned: 0 in this file: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_CBXP_Core.log Maybe that's not a fatal error, but the SQLExpress service does not get installed. I am tryi ...Show All

• deodorant0208 several queries in a dataset

  Hi, I am trying to create a report that will first create a temporary table based on the values of report parameters and then use this table to generate final results via a separate SQL query. My attempt to fit both queries (1-for table creation,2-for generating final results) in the main dataset of my report wasn't successful. It seems like reporting services run only the first query in a dataset. My question is - how can I make my re ...Show All

• Chandresh Data Type Conversions

  I am trying to convert int to date. first I have converted the int value to string(dt_str), using 'Data Conversion' Transformation, then again I have used another 'Data Conversion' Transformation to convert it into date. but its giving the following error    [Data Conversion 1 [3643]] Error: Data conversion failed while converting column "THEDATE_INTO_STR" (2799) to column "CALENDAR_YEAR1" (3657).  The conversion returned st ...Show All

• johoja Error 1418, fails to connect mirror server

  I I use the mirroring wizard to config all these three servers(windows authorization is used), the error logs in primary server and mirror server are showed as below a) On primary server: Error: 1474, Severity: 16, State: 1 Database mirroring connection error 4 'An error occurred while receiving data: '10054(An existing connection was forcibly closed by the remote host.)'.' for 'TCP://mymirror.mydomain:5022' b) ...Show All

• aus_dev The error is (17058): SQL Server 2005 Express Edition 9.00.1399.06 install work.

  I have encountered an error (as shown below) when attempting to install the SQL Server 2005 Express Edition 9.00.1399.06 on on my XP SP2 pc. the file: "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\Summary.txt" show the following messages: Machine : DUMBO Product : SQL Server Database Services Error : The SQL Server service failed to start. For more information, see the SQL Server Books Onlin ...Show All

• Steve vB install in customer server

  Hello, I'm looking for a script to export all reports from server A (include all folder tree/datasource and reports) to a file in order to import in server B I'm looking the export and import scrip in order to install my reports in the customer server (I'm using SQL 2005) Thanks There are some KB Articles see http://support.microsoft.com/default.aspx scid=kb;en-us;842425 and some links i ...Show All

• dom123456 HelloWorldCS Sample

  Is anyone is familiar with the HelloWorldCS solution that is available for download at www.SQLServiceBroker.com If so, can someone tell me what this method does ------------------------------------------------------------------- private void BuildCallbackMap() { Type t = GetType(); //this member variable is for retrieving a collection of key/value pairs //BrokerMethodAttribute is a base class for all custom attributes m_dispatchMap = new D ...Show All

• Sarada Connection to Analysis services from VB - very slow

  Dear All, I noticed a strange problem with one of my client's computers where in establishing a connection with Analysis services from VB takes 6 seconds, when the computer is not connected to network, but it takes only a fraction of a second when the computer is in networ. We use ADOMD to connect to Analysis server. Analysis services is installed in the local machine. I ran dependency walker and found that the dll WS2_32.dll (winsock dll) ...Show All

• ueo How to combine different data regions in a single report?

  Hi, all here, I am trying to use report designer to create a single report with chart data region and table data region combined within the same report. Would anyone here please guide me how to work it out Thanks a lot. With best regards, What do you mean by combined You can put several data regions in a report and each can have their own datasource or share the same. If you want to have a chart data region inside a table data regio ...Show All

• rontopia Did SP1 fix Query Optimizer issues w/ Partitioned tables?

  Hi there, We've implemented a partitioned table to a large table within our EDW. However, we'd discovered that the Query Optimizer was not able to understand parameterized queries. It basically was scanning all the partitions even though a parameter was passed defining the partition to use. Consequently, the queries need to hard code parameter values! Does anyone know if SP1 addressed this problem Thanks -Walter ...Show All

• nine99 Different Header on Second Page

  I have a report that requires a different header starting on the second page. I tried creating the header for page one in the body of the report, then creating the header for page two in the actual report header and setting PrintOnFirstPage to false. Unfortunately, this leaves a large space at the top of the first page, which is not acceptable to my users. If there was a way to create a list box header that repeats at the top of each page, th ...Show All

• decyclone Empty Messagebox

  Hi When I start the MSQL Server Management Studio Express I get a Message Box with a yellow exclamation icon and NO message, just an OK button. Which when I press it goes away allowing me to logon to the Management Studiio. All seems to be working fine (although I have not used it much since getting this strange behaviour). I have re-installed Win XP Pro SP2, applied all patches from MS website, install is clean and no errors. Also ...Show All

• younessta subtotal and subaverage

  Hello, I want to have a subtotal column AND a subaverage column (or n total columns) like the one in the following example - but without the extra Avg column in the Data area. How to do that 2000 Q. 2 April Avg May Avg June Avg Total Avg North 4800 4800 5708 5708 5580 5580 16088 5363 ...Show All

• SneshaA Print Preview pagination for multipage data in single text box

  I have a tried two different reports one with table and the other without The last textbox in both reports contains enough text which should fill half of first page and half of second page. In both reports the print preview and export to PDF keeps the first page blank and puts all the data in the second page. It appears that the textbox control doesn't know when to place a pagebreak when in print preview and export to PDF. The rdl file has no pa ...Show All