Answer Questions
Chris Biles Reporting services passing parameters
I have a report that is link from another report, I've created this link in the report designer by using the rightclick textbox>select properties>Navigation tab > jump to report. Now I have passed 4 parameters over to the new report, these are hidden and shouldn't be seen by the user. There is however a fifth parameter that should be set by the user at run time, as this controls what the report shows. This works perfectly w ...Show All
Pat11 Problem with nested install of SQL 2005 Express...
I create Installer for my company, with using SQL 2005 Express and its files database. I used MS Build bootstrapper before to install MS SQL 2005 Express in my installer and it was installed before my product installed, and there is no problems... But now I need to install Express during setup, because it must be installed NOT everytime (if user choose, in bootstrapper it is impossible). I know that during execute sequence it is not po ...Show All
Bohdan Label 3X7
Hi, I want to create a report to display and print 3 * 7 sheets of labels. Please guide me to achive this. Thanks, Prashant Prashant, have you solved your label problem I have created a report to print custom sized labels just by setting the right report size but I too have questions about printing labels. Maybe we could share what we have learned thanks, theresa ...Show All
ailleresc Copy Reporting services Reports from Beta to production
Hi, I was wondering what the best practice was for duplicating a reporting services setup. I have a source test SQL Server 05 running the June CTP with a few reports. I setup a production box with SQL 2005 Standard with Reporting services. How do I copy the reports, settings, etc to production. Thanks for any advice. Asim. bump. Anyone. I don't want to backup and restore from beta to production. Will ...Show All
Skynetxp Help! - Error in moving data from AS400
I have a process that simply copies data from a table on an AS400 to SQL Server. This process executes fine until it gets to around 44 million rows copied out of 48 million rows in the source table. At this point, the process exits with the following error messages: The attempt to send a row to SQL Server failed with error code 0x80004005. The ProcessInput method on component "SQL Server Destination" (40) failed with error code 0xC02020C7. Th ...Show All
mootha == The SQL Server service failed to start ==
I'm newbe with SQL Server , I'm looking for help with sql server express edition 2005. At the end of installation ocurrs an error: The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually. Error Number : 29503 . (Summary file) Rest of components has status : Successfully installed I've go installed .N ...Show All
Assert.True Named Calculation, Referencing a field from a linked table
Is there a way to reference a field from another table in a named calculation. Ex: Table movies has a link to table theatre, in the theatre there is a display code, the display-name of the movie should be comp.comp_displaycode + ' - ' + mov.mov_name. I know i could do this in a view and than use the view instead of the movies table, but if it is possible in the Datasourceviews it would be easier. Try rep ...Show All
Magnus Blomberg Apply sql2k post sp4 fix 2162 on cluster
I applied sql2k post sp4 fix 2040 and 2162 on active node of the cluster without error, the version number is 8.00.2162. When failover the cluster and double check version number again, it's 8.00.2040. That means fix 2162 didn't push to passive node. So I tried apply fix 2162 on current active node but stopped with KB904660(ENU) setup error: An error in updating your system has occurred. Can't find any log file, and OS is win2k3 enterprise editi ...Show All
penfold2006 Management Studio Find & Replace
Hi, I'm expreiencing a very strange problem with SQL 2005 Management Studio. Somehow I've manged to "lose" the Find & Replace dialog box! If I press Ctlr+F or Ctrl+H the Find/Replace dialog doens't appear, however if I press Ctrl+TAB I can see "Find and Replace" listed in the "Active Tool Windows" list. Any suggestions "Find and Replace" is a tool window. This means that it can be ...Show All
Holm76 Setting up Sql Mobile subscription
I am working on settin up a subscription to a publication that i made of the AW database. when running the subscription wizard i get an error on the sycronization of data part. the error states "A request to send data to the computer running IIS has failed HRESULT 0x80072EE7(28037)" i have the URL on the Web Server Authentication page of the wizard set to http://localhost . can anyone help me out on this one thanks ...Show All
nzMatt "Launch Database Mirroring Monitor" is not an option
Good morning all... I would like use the "Database Mirroring Monitor" to track what's going on. All three of my servers have SQL Server 2005 x64 edition installed with SP1. Server A is mirroring to Server C Server B is mirroring to Server C Following the instructions at http://msdn2.microsoft.com/en-us/library/ms365786(d=ide).aspx : On Server A and C, "Launch Database Mirroring Monitor" appears. On Server ...Show All
Rodrigo Benitez upgrade sql 2k std to sql2k5 problem with Reporting Services
Hello, I just ran the upgrade for our production box. During all of our tests we haven't encountered this problem. We added in reporting services to be hosted on the db server so iis 6.0 is installed. Everything installed fine and we received no errors during the upgrade. However when we goto the site http://dbserver/reports we see the site come up but a message is display stating that "Unable to connect to the remote server". Looking over th ...Show All
gdumazet JOB With SSIS Step Fails If Package Contains A Script Task
I have a Job Step defined to execute a SSIS Package. This SSIS package contains a Script Task. The Job fails with the message "Package execution failed. The step failed." I am logging events in the package and when the packages gets to the Script Task the log reports "The script files failed to load". If I disable the Script Task from the package it executes fine. Curiously, the package runs ...Show All
Spy versus Spy sql server 2000
This is my last attemp at trying to install sql server installed, which its been quite reluctant too, as I've spent the last 2 hours with no progress. I've downloaded MSDE2000A.exe from http://www.microsoft.com/downloads/details.aspx FamilyId=413744D1-A0BC-479F-BAFA-E4B278EB9147&displaylang=en Installed it in the default directory. "C:\MSDERelA" And ran setup which returned this error "A strong SA password is required for securit ...Show All
Vladimir Nesterovsky the name of the trigger
I am calling a CLR stored procedure from my CLR trigger and would like to pass the name of that trigger as an argument to the procedure. How can i get the name of the trigger and save it into a variable Hi Ravi, How is this possible since @@PROCID is not allowed to run within the context of a CLR Trigger I also want to acquire the name of the trigger that invoked the stored procedure. Can you ...Show All