Answer Questions

• Brian Deacon Copying dimensions using XML

  Hi, I have created a number of dimensions for a project, each with multiple hierarchies etc. Now, due to a late-breaking spec change, I have had to quite seriously alter the underlying DSV, and without thinking about it I renamed it as well. As far as I can tell, using the VS UI, I will have to re-create these dimensions from scratch, using the new DSV. Is there any way I can re-use the existing dimensions and edit the XML to point to t ...Show All

• Ron4236 Moving a database from 2005 Express to Enterprise

  If I detach a database from an instance of SQL Server 2005 Express and attach it to an instance of SQL Server 2005 Enterprise, will the database be essentially identical to one initially created under 2005 Enterprise, or will some Express edition limitation follow the database from the original instance to the new one Thanks, Peter Nyberg The on-disk structures will be identical, so you should have no probl ...Show All

• wikoh Does ASP 3.0 Support Varchar(Max) Data Type

  Does ASP 3.0 support Varchar(Max) Data Type I am having problems displaying asp 3 recordset with varchar(max) data type... ADO.NET 2.0 supports varchar(max) field. Older versions will support it as well since SQL will send back as text to older clients. ...Show All

• don wingate Can't uninstall Reporting Services

  I need to reinstall Reporting Services but during uninstall I face the following error: "The setup failed to read IIsMimeMap table. The error code is -2147024893" Nothing seems to help with the problem. Regards, Ksenia I am also having the same problem,  Is there a way I can get around this without havin got rebuild my machine Does anyone have any updates on this. I am n ...Show All

• MohitGupta Foreach Loop Container in SSIS

  Could someone send me any links or information on how to loop through an ADO.NET dataset in SSIS I need step by step information please. Thank you, Shiva Sebastien Nunes wrote: Hi, I have quite the same inquiry. I'm willing to create a DatFlow for each of my Business Rules. But I don't want all rows to be parsed by each Business Rule. I would prefer looping in my DataSet and each row ...Show All

• The CHAOS Coder removing replication table

  Hi all, Can Enterprise Manager remove a table from replicating to another server I've tried looking at the article tab of the property of the publication but couldn't find a way to delete a table from the article. Any idea Thanks! Don, I am glad I could help. :) A better way is to try: If using Merge replication: exec sp_replicationdboption 'MyCompanyName_MSCRMDi ...Show All

• bbrik Batch Updation

  I have the scenario of selecting values from more than one tables, also while updating the values to DB from Datagrid some changes may or may not be made in grod Then check the values alreay existing table to the grid values now i had written in OPENXML inside a Stored procedure,the SP have if statements, INSERT,UPDATE for one table or more than one table which one is best openxml or the adapter.update is best, Also how ...Show All

• jturn99 repeatwith property

  I have tried for days to get certain textboxes and tables in page body to repeat on multiple page reports Any help is appreciated. How to use static query in my header textbox = "SELECT [Contractor Name] FROM tblvendor WHERE vendorID=" & Parameters!vendorID.Value It display the text "SELECT [Contractor Name] FROM tblvendor WHERE vendorID=354" not the query result How to transfer parameter to Head ...Show All

• Eddie H How to Execute a DiffGram

  This article on MSDN: "Microsoft SQL Server 9.0 Technical Articles, XML Options in Microsoft SQL Server 2005" states that it is possible to execute a DiffGram using SqlXmlCommand. However, when I execute this code: static string NorthwindConnString = "Provider=SQLOLEDB;Server=NJSQL06;database=Interlink_GISLink90;Integrated Security=SSPI"; SqlXmlCommand cmd = new SqlXmlCommand(NorthwindConnString); ...Show All

• twad5 Datasource Reader - Name for output column is blank.

  Hi, I have a problem using the odbc datasource reader to execute a sql command on a progress database. My query is something like:- select max(id), sum(amount) from my_table OR select a, b, c, recid(my_table) from my_table which produces external columns and output columns with no name. The progress sql doesn't support using aliases on column names and setting validateexternalmetadata to false and manually naming the input and out ...Show All

• Viktor Placek columns_updated() -- working backwards

  Hello all...another new guy question here... I'm working with an UPDATE trigger and the COLUMNS_UPDATED() function.  I *believe* I understand the basics of this ... on a table w/ 8 columns or less.  I understand the issue of using a substring to check a table w/ 9 or more columns. OK, here's the scenario:  myTable has 8 columns.  If I map this out it looks like: Value     1   &nbs ...Show All

• Eric Molitor Problem referencing a global temporary table

  I'm having difficulty referencing a global temporary table in a stored procedure. My stored procedure will execute correctly for days on end, but then all of a sudden it will stop working and I will get messages like: Invalid object name '##TableName'. and Cannot drop the table '##TableName, because it does not exist in the system catalog. ========================================================================== In my store ...Show All

• Jetto Unhandled Exception in Management Studio

  At work we run a large SQL Server 2000 database that is usually administered using Enterprise Manager. I recently started playing around with SQL Server 2005 Management Studio and have been encountering an interesting problem. Whenever I browse tables/views in the Summary window, and then select a table/view (by hitting enter or double clicking) Management Studio encounteres an unhandled exception (below). Oddly, this behaviour only occurs when ...Show All

• Venusm Using Visual Studio 2005 to convert Access reports to SQL

  I have lots of Microsoft Access reports to convert to the SQL 2005 reporting services.  I have heard that it is very simple to import them to Visual Studio 2005 and let it make the conversion for you, but I couldn't find any documentation in MSDE.  Any help on this subject would be appreciated. Thanks to Tim, for sending me this link in another post.  If you are having the same tro ...Show All

• tchow Connection to Oracle

  I have created reports in SQl Server 2005 Reporting Services using an Oracle Data Sources. When I Preview the report in VS 2005, It runs fine but when I deploy it, it fails to make a coonection to the oracle data source. Reports off the SQL Server Data Sources arerunning fine. Can any one out there help me out on this. I will really appreaciate. Regards, Sam. It seems Permissions were my problem. I assigned read/ex ...Show All