Answer Questions

• Yuvaraj Database Mirroring

  Hello, I'm having some troubles to set up database mirroring on Itanium II based servers. I have 3 servers registered in the same domain (windows authentication) I have created manually the endpoint and there are all 3 started (port 5022) When I do the alter database set partner on the mirror site it works. When I do it on the principal instance, I have the following error: Msg 1418 the server instance "TCP:itanium8.sql.net:5022" is not running ...Show All

• Jonhwang Custom source adapter UI

  I am currently writing a custom source adapter that extracts data from a JD Edwards OneWorld system. In the custom user interface of the source component I need to allow the user to set a query (a custom property), and then refresh a list of output columns that will be extracted based upon that query (similar to the list shown in the advanced editor). My question is, can I apply the custom property change to the component and build my output ...Show All

• jtw2006 Paging large result sets

  I use SqlServer on my web app written in Java. I have went through quite a big effort in trying to realize a flexible paging algorithm that I can include in my set of libraries. However having to deal with too many unknows like do I want the RS ascending/descending, what is the first/last itemid, next/previous page (and then invert logic what is up what is down) I'm quickly going mand. I realise there is a fine line where this is a tsql problem ...Show All

• Paulovsky Conditional Execution based on Multi-Valued Parameter Selection

  If a user selects all (266) parameter values from a mult-valued parameter list, I would like to display a table based on a version of a stored-proc that does not select records using parameter driven criteria. The total selected count can be acquired by =Parameters!ParmName.Count syntax. Total available parameter values can be extracted by =CountDistinct(Fields!ColName.Value,"DatasetName"). Setting a filter on a table and inspec ...Show All

• BrotherC Strange Results in executing views in SSME

  I am getting some interesting (read 'undesirable') results in SSME. I am attaching two scripts, one that creates a TestTable and the second creates a TestView, based on TestTable. When TestTable is created, enter the following rows (format is TestID, Sequence): 1 - 99 2 - 98 3 - 97 4 - 1 5 - 2 6 - 3 When the data is entered, highlight TestTable from the list of tables, right-click and select Open Table. The result shou ...Show All

• DennisCIS what i forgot

  hideho mates, well could it be.... all SQL services r runnin, i created 2 sql logins with ALL rights!!!!! well now i want to use one of this accounts (which r domain admins too) too install VSTFS 2005 Beta 2...so far so good...but the first evetnlog entry after the begin of the install is always "sql server login failed - cannoct connect to the database"... the funny thing is > AFTER is event log entry ALL VSFTFS and ADAM Databases gonna  ...Show All

• Stephen M. Berube cannot generate ResultSet code

  I am using Visual Studio 2005 and SQL Server mobile edition. From Visual Studio I went to Data->Add New Data Source. From there I created and added an SQL server Mobile database. I want to use result sets instead of data sets. A file was added to my profect called: "databaseNameDataSet.xsd". In the properties for that file, when I change the Custom Tool property to MSResultSetGenerator, I get the following error: Failed to generate ...Show All

• Marvin_ru Excel Value Error accessing OLAP in the last week

  We use Excel 2003 to access OLAP cubes on SQL 2000.  One of the cubes uses security using the manage roles function on the cube.  In the last week, users who are restricted by the role management can no longer access the cube.  The excel pivot table show #VALUE! in all the cells.  If I turn off the security and allow them to see all the data in the cube it works fine.  It only happens when the role management is used.&nb ...Show All

• rima66345 Audit task

  Hi, I have to compare the values of two fields which are in different tables and then generate a audit report. How to view the audit report . How to compare values Consider scenario like this.   Two product tables are available product1 and product2. What i want to compare is the price field of two product tables for each product id if they are same no action if not do some a ...Show All

• blk_ice Fresh RS Install - weird bug

  Hi all, My RS install is having a strange issue.  I've installed RS on an IIS Server and pointed to a remote server database.  The IIS server is secured using an internally issued SSL cert. After some tweaking, I've been able to get RS to work (almost) properly.  I'm able to deploy reports from Visual Studio and view them through the RS Web App.  Of course, I have admin rights on this box. My problem is this:  ...Show All

• Display Name* Transfer logins from sql2000 to sql2005

  Hi, I'm trying to transfer my logins from 2000 to 2005 (last CTP) and recieve error: [Transfer Logins Task] Error: Execution failed with the following error: "Cannot apply value null to property Login: Value cannot be null..". Any one I assume you solved this problem by now, or it went away with RTM code. Please reply back if that's not true. Paul Yep, Away with with RTM ...Show All

• muyis AVG Function Overflow

  Convert the column to BIGINT so you have more range:     SELECT AVG(CONVERT(BIGINT, YourColumn)) FROM YourTable     -- Adam Machanic SQL Server MVP http://www.datamanipulation.net --     <Dennis Jackson@discussions.microsoft.com > wrote in message news:43ea50a8-ae33-4816-bb70-8935293b923c@discussions.microsoft.com ... encountered on SQL 2005 C ...Show All

• shaht SSIS - XML config file

  Hi All, I am looking for help trying to configure an XML dtsconfig file, I am using different connection managers for my Source and Destination Databases, I am also using an XML dtsconfig file to set these parameters dynamically, however I dont want to use userid/password to connect to my source/destination databases and instead use trusted connection or windows authentication, I remember we had an option in earlier DTS where we could set ...Show All

• Chuks Can't run reports in Report Builder

  I've followed the Adventure Works tutorial for Report Builder, but when I click Run Report I get this error message: Report execution error The report might not be valid or the server could not process the data. Input string was not in a correct format. ---------------------------- Remote GDI stream version: 10.0.1. Expected version: 10.0.1. Any ideas Yes, switching the regional settings to US English should work for CTP builds. Note: th ...Show All

• Dave P2 GUIDs using NEWSEQUENTIALID() on SQL Server Mobile

  Hello, I've been thinking about using GUIDs as primary keys within my application. One problem I have with this approach is that GUIDs generated with NEWID() are not sequential, and this can have a huge impact on insertion performance due to fragmented indexes. It would seem that NEWSEQUENTIALID() solves this issue, however it doesn't seem very practical to use this on SQL Server Mobile. With SQL Server, you can specify an OUTPUT clause for an I ...Show All