Answer Questions

• shakey slidewell I want my custom SQL errors to display on the RS Page

  Dear Anyone, We have custom raise error messages embedded in our stored procedures. I've noticed that using Business Intelligence Dev, when these errors are invoked, they actually display on the RS report. But unfortunately, when I tried it on a deployed report, I always get the error below. Is there a way to display custom SQL errors from my stored proc to the RS page Where do I enable the remote errors Thanks, Joseph An e ...Show All

• vhmau Background image sizing

  Hello, I have a jpg image to use as report background. How can I strecth the image in order to fill the page background (i'm using PDF output) with my image Thanks, Pierre In report designer, go to the properties editor window and select "Body" for the report body from the drop down list. The report body has a background image property. Note: page header and page footer are independent of the report body - but you can also use images in t ...Show All

• czetsuya Am I missing something???

  So I'm using the new Microsoft SQL Server Management Studio (aka Enterprise Manager)... 1. So I load it up, add a few sql servers to it. Mess around, close it, open it again and lo and behold it didn't bother to keep any of my settings or any of the SQL Servers that I had added and anoyingly asks me for login information to add another one.  Unless I'm missing something, you just threw out one of the best parts of Enterprise Manager. Please ...Show All

• theBainster Email tasks fail after an unsuccessful SQL 2005 installation

  I tried installing SQL 2005 Dev Edition on my Win 2000 Professional machine. That failed. But now I cannot send out emails or even open a simple Email task from DTS. This is something that worked perfectly fine before I attempted the SQL 2005 installation. It seems that the SQL 2005 installation somehow messed up the the MAPI profile. The exact error message that I get when trying to execute or open a Email task in DTS is: CAnnot load MAPI Inter ...Show All

• Jan DHondt Rerun only certain containers ?

  Hi There I have a package that has many containers that execute in sequence. If any container fails the package does not fail as the subsequent containers must run. However if containers fail i do not want to rerun the entire package. Checkpoint restartibility only allows you to start from where your package failed, however my package will not fail and i do not want to start from where it failed but only rerun the containers that failed ...Show All

• jm47048 Report Viewer Issue in Visual Studio 2005 Beta 2. for Microsoft Reporting Services

  Hi I am trying to display  Microsoft Reporting Service Reports from windows application. I have application window with Report viewer control. I have  assigned valid path and URI from Server report properties in report viewer control. When I try to display the reports Error is " "The attempt to connect to the report server failed. Check your connection information and that the report server is compaitble version. The request failed w ...Show All

• Ronald Cuzco Newbie: DT_I1, DT_STR, etc

  Anyone know the origin of sql 2005's datatype naming convention or even why SSIS has defined its own special data types (Before SSIS I had never seem types like DT_UI1 except in programming languages.) TIA, barker The reason of having SSIS's own data types is quite obvious, being a ETL tool SSIS pulls data out, as well as sends result to, various systems - It  ...Show All

• BradFriedlander Two Instances (SQLEXPRESS and MSSQLSERVER)

  Hi there, I installed SQL Server Express few days ago but today I coudn't start the Management Studio. After reinstall the management studio, the problem stay. Then I uninstall SQL Server, but I still had acess to the configuration manager and I see that the instance SQLEXPRESS still runing, even with all unistalled (SQL Server, Management Studio, Framework 2.0, Visual Studio). Then I install again Sql Server, and it detected that the default In ...Show All

• kennydmac MS SQL Server 2000 Enterprise Edition installation error

  My laptop has VS 2005 installed. I am trying to install MS SQL Server 2000 Enterprise Edition, when i run "install database components", it gave error: "MS SQL Server 2000 Enterprise Edition component is not supported on this operating system. Only client components will be available for installation". then when i click on "ok", then "next", when i click on "next" on the "computer name" page, it gave another error: "A previous program installati ...Show All

• Desire Is this possible?

  Hey guys, I wrote a T-SQL query to retrieve all errors name and count the error for each error name based on some conditions. Assume that errors_name is a column name in Error table and the error_count is a calculated field. Here is my question; when I run the query, obviously, it displays the list of errors name and the corresponding errors count which only meets the where condition . However, what I need is to list all the errors name (eve ...Show All

• RatOmeter ToggleItem and PDF export

  Folks, We've developed a bunch of reports that are very screen friendly by showing only one section of the report at a time, and the table header rows only for the remaining sections. However, when we export to PDF, we really need all these sections opened. How do we go about doing that Thanks so much! --randy ...Show All

• lazyfellow Push and Pull subscription?

  As I understand replication in Sql2K the only difference in push or pull subscriptions is where the agent runs. If I wanted changes in the publisher to be sent to the subscribers immediately after the change then I thought push would be better. But, if I am equally interested in changes made at the subscriber then what should I use Or does the agent monitor both the publisher and subscriber at the same time Thanks for your help Graham ...Show All

• Flanman URGENT : DataSource Problem

  HI, My name is Paras Dhawan, I was looking for a code which can execute mdx queries through JAVA code using XML for Analysis and I found the following code at Microsoft Forum (click to see) import java.net.*; import java.util.*; import org.apache.soap.*; import org.apache.soap.rpc.*; import org.apache.soap.encoding.*; import org.apache.soap.encoding.soapenc.*; import org.apache.soap.util.xm ...Show All

• Buck Woody Query Runs Perfectly in SQL 2000 but not SQL 2005 (but runs fine in Query Analyzer for 2005)

  The following query: SELECT TOP 1 a1 . AccountType as 'OtherAcctType' , a1 . ListID as 'OtherAcctName' , a2 . ListID as 'AgCommAcctName' , a3 . ListID as 'AdminAcctName' , a4 . ListID AS 'InsAcctName' , v1 . ListID AS 'OtherAcctVendor' , v2 . ListID AS 'AgCommAcctVendor' , v3 . ListID AS 'InsAcctVendor' FROM tblCommissionStructure LEFT OUTER JOIN tblAccounts AS a1 ON a1 . ...Show All

• Rob Stubbs Need to refine the query. I get an error

  update datusers set u.password = ua . [passwordsha1] from dbo . datusers du join dbo . datusersall da on du . UserObjectID = da . UserObjectID I'm getting the error: Msg 4104, Level 16, State 1, Line 1 The multi-part identifier "ua.passwordsha1" could not be bound. I dont know what it means. I'm trying to update the password column from 'da' table. both tables have same records. and UserO ...Show All