Answer Questions

• duckduck Failed to access IIS metabase

  I installed Report Services 2005 on XP Pro, and when trying to access the http://localhost/Reports directory, I receive this error: The process account used to run ASP.NET must have read access to the IIS metabase (e.g. IIS://servername/W3SVC). For information on modifying metabase permissions, please see http://support.microsoft.com/ kbid=267904 . I ran the aspnet_regiis –ga <WindowsUserAccount> , still nothing.  I went in to ...Show All

• robin l Force to Bottom of page

  I have a text box as the last item on the report. It's just above the Page Footer. I want this textbox to always display at the bottom of the last page of the report. I can't seem to find a way to force this. All help is appreciated. You could move the text box into the page footer and use a visibility expression: =iif(Globals!PageNumber = Globals!TotalPages, false, true) Is there no way to do this Is that why I've h ...Show All

• Clarke Scott Clearing/Unselecting Multi-Value selections made

  I used to use the 'Select All' to clear the previously selected values by checking and unchecking it. However now with 2005 sp1 this is unavailable. Does anyone know of any way to unselect/clear all selections made without manually going down a long list and unselecting the old selections Yes i understand and i have tried the workaround. It doesn't help with what i want. What i want to do is be able to 'cle ...Show All

• Paul Learning subscribe a report from application

  Instead of going to subscription page of report server, can I subscribe a report from my .Net application If yes, how can I do it or where can I find resource or sample I am using SQL 2000. Thanks. Joe. Hi, you have to use the subscription API of the WebService for that. Habe a look at a sample from: http://odetocode.com/Articles/114.aspx -Jens Suessmeyer. --- http://www.sqlserver2005.de/ --- ...Show All

• Dwayne Walters New to SSIS - Destination FK's Lookup, auto increment for PK's

  Hello there. I've just upgraded from using DTS to SSIS. I've run through a few tutorials and am starting to use to the new ways of working. There are however two task that I'm not really sure how to tackle, can someone suggest the best method in SSIS. 1) The destination table has many FK's. I'd like the package to check that the input data does not violate the FK's and use a default value for the columns where a violation occurs. ...Show All

• Keith Jones How to not render blank reports?

  Hi, Currently I am programmatically printing SQL Server Reporting Services reports using a C# console application (most of the code I got from Bryan Keller’s weblog http://www.csharphelp.com/archives3/archive545.html ). The problem I am having is that when a report is blank (i.e. its data sets don’t return any data) I don’t want it to be printed. If I don’t want a blank Access report to print I set the following event i ...Show All

• msipe Migrating from Non-SQL Server/Windows Sources

  Our company has an enterprise product that uses SQL Server as its db server.  When we implement our system for new customers, it is quite a chore to move their historical data from their legacy system(s) to our system.  I am evaluating tools to make this process easier. Given that our product runs only on SQL Server and SSIS comes free with 2005, SSIS seems like the logical choice.  I have performed numerous tests in SSIS using SQ ...Show All

• StevetTW How to positioning the tables.?

  Good Day! can any one help me how to posistoining the tables I have a layout ofthe reports. the report is in the landscape view. there are some text boxes in my reports but when i put the tables my textboxes arrangement will be dis arrange. can there be a solution for this Please help me im stuck. thanks Hi, can you explain how the arrangement is being thrown off Sometimes the CanGrow property on TextBoxes can cause un ...Show All

• alexbartell Database Diagrams - SQL Server 2005 Express

  I have installed Visual Basic 2005 Express and SQL server 2005 Express. I am reading the ebook: "Microsoft Visual Basic 2005 Express Edition - Build a Program Now" that you download when you register the products (it is a PDF file named 6-2213-2.pdf) Page 139 of the book (or 151 in the file) is about "To Create Relationships between Tables". So I follow the instruction and get stuck on Step 1. When I right click on the Database Diagra ...Show All

• ND.. Merge Replication - Weird Conflicts for no reason

  Hi. I am using Merge Replication on Sql Server 2005 (which works much better than 2000 by the way) and everything is working great except occassionally I will get some conflict rows for no reason. The same column(s) of the same row was updated at both 'PublishingServerName.DatabaseName' and 'SubscribingServerName.DatabaseName'. The resolver chose the update from 'PublishingServerName.DatabaseName' as the winner. I checked our audit table a ...Show All

• christian bitter FTP Task Failure

  We are unable to get a file from a VMS FTP site.  The specific error message is: [ftp task] Error: File represented by "/VEQFFP.TR.MTSS.RATE" does not exist. normal command line ftp and other ftp tools all succeed.  Is anyone else experiencing this difficultly Thx in advance. I got the same error but it turned out that after browsing to the file to be downloaded using remote path, when I ran the ...Show All

• Risky Business Restoring a databse user

  I'm new to working in SQL, so forgive my lack of terminology. I have this database that stores sales conselors clients. One of the sales counselors is missing 1200 of his clients after synchronizing. (down to 694) When I look in the replicated database, it shows the full 1894 clients. Is there a way to restore his database from the replicated HELP When you say missing, do you mean one site has 1894 records and ...Show All

• John Meade how to create Extended procdure to invoke a webservice with C#

  Hi,    Can anyone help me in creating an Extended procdure that can invoke a webservice with C#. Hi,    sorry mate...i cannot use sql 2005 and im restricted with sql 2000 only, unfortunately :(. Now im trying to know how to return object or array using sp_OAMethod. Pls post...if u have examples that explains the sp_OAMethod returning object or array. Thank You.... -GSM ...Show All

• Atlantaazfinest Any debugger in MSSQL 2005?

  In SQL Server 2005, is there any debugging tools for T-SQL programming works similar to that in Visual Studio .NET You have to use visual Studio to debug TSQL in SQL 2005. There is nothing in management studio. ...Show All

• Gerfboy Oracle 9i -> SQL Server 2005: Snapshot agent aborts suddenly uninterrupted

  Hi - I hope some of you can help me with this problem. I'm trying to run the snapshot agent for 77 published tables, but the agent stops suddenly uninterrupted. It stops in the middle of taking a snapshot of a table containing 81,719,531 rows. The error message is pasted below. Message 2006-06-14 05:33:33.53 [89%] Bulk copied 100000 rows from "ORAMSSQLREPL"."HREPL_ARTICLE_21_21" (57200000 total rows copied) 2006-06-14 0 ...Show All