Answer Questions

• Vargess Local Reports

  Thanks for the info but I am interested in designing and running local reports in a windows form.  I have not been able to find correct documentation on how you define a schema that can be used to create an rdlc file for design of a report that uses a datasource that is set at runtime.  Specifically, I would like to use business objects that return a data table in a get method.  The online documentation is incomplete and full of ...Show All

• rwa Execute SQL TaSk

  I am trying to run a Direct Input SQL query to SELECT MAX value of ColA. This query when I run on Query Window runs fine - means it is NOT a NULL. I get a max value. When I run this query on a SSIS package outputing to a variable - I get the error. - [Execute SQL Task] Error: An error occurred while assigning a value to variable "MAXROWKEYID": "The type of the value being assigned to variable "User::MAXROWKEYID" di ...Show All

• Alex2008 Uninstall Microsoft SQL 2005 CTP

  Hi, I am having trouble uninstalling Microsoft SQL Server 2005 CTP. I have gone through the steps of uninstalling. Microsoft Configuration Tools does not seem to uninstall. HELP! Tried everthing short of formatting thanks in advance Hi, " GDCDEVSERVER : SQL Server 2005 Beta 2 Setup has detected incompatible beta components from Visual Studio or SQL Server.  To proceed, use Windows Add or Remove Programs ...Show All

• NewWorldMan SQL Server Service Broker Admin Tool for SQL Server 2005 RTM

  Back in July I released the (then) latest version of SsbAdmin. For you who don'r know what it is; it's a tool which allows you to graphically administer SQL Server Service Broker. I have now uploaded a new version which is compiled against the released versions of SQL Server 2005 and .NET 2.0. You can download it from here : [0]. After download, un-zip to some directory and read the README.doc file. [0]: http://staff.develop.co ...Show All

• alejack-sw How to stop discovery from adomd.net connection

  I am using MSAS 2005 with ADOMD.NET 8.0 with .NET 1.1 I observed whenver we execute any query it does discovery of meta data. The meta data is part of resultset that is returned to the client. You can see this part of XML that is returned to client. <root xmlns=\"urn:schemas-microsoft-com:xml-analysis:mddataset\" xmlns:xsi=\" http://www.w3.org/2001/XMLSchema-instance\ " xmlns:xsd=\" http://www.w3.org/2001/XMLSch ...Show All

• goffj68 DTS or Replication?

  I need help deciding whether to use DTS or Replication: We have four SQL Server databases on four separate servers with the same data schema, one for the north east, south west, mid atlantic, and mid west. We also have one "global" database on a separate server. First, and only this one time, we need to copy data from the four regional databases to the global database. Then, at least once a day we will need to copy changed and new ...Show All

• JimVb Problem with remote replication

  I have a number of dialup users who are trying to replicate against a master database.The first few times worked fine.but now each user is getting the following message "The process could not change generation history at the publisher" Any help or pointers gratefully received many thanks David J. If it is a Timeout issue, it can be dealt with increasing the timeout value. If it is a ne ...Show All

• Mark Davis image causing extra page in PDF export

  HI I have a report, on the first page I have: Single Line of text Single Line of text IMage 2.04 " by 2.04 " (centered) Single Line of Text Single line of text Looks fine in report viewer, but when exported to PDF, all the text lines are on the first page, and the image is on the second page by itself off center. Any ideas Thanks Bob bump ...Show All

• wagnerjp SSIS: Opening package takes 8 minutes

  I have an IS package containing approx. 10 tasks in the control flow - one of these tasks is a rather large data flow containing around 50 transformations plus 3 sources and two destinations. Around 10 of these are script components and another 10 are Union All transformations. The rest are primarily lookups, conditional splits and derived column transformation. The XML file containing the package is approx. 4.5 MB. As I am developing the pac ...Show All

• RSVS2005 SQL Server 2005 and Visual Studio 2005 on local develoment machine - Unable to connect to Server from VB app.

  Hi all, "An error has ocurred whilst connecting to the server..." I have been developing using VB 2005 and SQL Server Express 2005 editions for a few weeks, and having had some sucess, I was given the full versions to replace my express editions.   I uninstalled the express editions and installed the full versions (VB as part of Visual Studio.  All this is on my local laptop PC which I use for development. I need t ...Show All

• Steve in Crystal Lake Illinios Pie Chart

  How do i specify the slice percentages on a pie chart when i dynamically generate an RDL file Hi, That's OK , but in the case of a dynamically generated RDL, how do i specify it in XML Here is a simple example: <ChartData> <ChartSeries> <DataPoints> <DataPoint> <DataValues> <DataValue> ...Show All

• Betty01 Audit Transformation error

  Hello all, I am getting an error that I am stuck on. I dragged the Audit Transformation for error handling (Flat File Source); however, the Audit Transformation is returning an error for one of the standard column "User name". I tried to change the length or take out this column, but the error does not go away. Below is the error message. Your help is much appreciated! -Lawrence "The length for "output column " ...Show All

• justin tighe Remote Connection

  Could someone tell me how to remote connect to other server . Everytime when I try to connect to other server, I get an error message . Eventhough I have opened the 1433 port, allow the remote connection using both TCP/IP and named pipes, and open the firewall for connection. The following is the error message "An error has occurred while establishing a connection to the server. When connection to SQL Server 2005, this failure ma ...Show All

• BMoores How to change a field's type?

  Hi, How could I change the field type through T-SQL I have tried Using the ALTER:          ALTER TABLE tblName ALTER COLUMN myID int It didn't work... And also, how could you rename a fieldname cheers, Paul June A. Domag Hi, Whew! Why didn't I think about that tsk.... Thank you very much! You really made my day... Here's the error message that I keep on getting in SQLServerCE: FAILED: A ...Show All

• jain_arun SQLCMD "-r" option

  OK, so I'm playing with SQLCMD and trying to get the "-r" option to work. According to BOL it's supposed to redirect error messages of severity level 17 or higher to the screen (stderr). Presumably this would be useful in situations where you're running a script with the "-o" option, so that output would be sent to a file and error messages would be sent to the screen and not included in the output file. When I run it in the ...Show All