Answer Questions

• datapvs MDAC 2.8 Fatal Setup Error. This setup does not support installing on this operating system

  I have XP Pro SP2 with MDAC 2.8.1022.  It had a problem so I tried to reinstall MDAC and got a Fatal Setup Error. This setup does not support installing on this operating system. I downloaded MDAC 2.8 1177 and get the same error. I thought of uninstalling/reinstalling SP2, but this is a 2 month old Dell Latitude 610 with factory installed XP.  There is no Windows Service Pack 2 option listed in the Control Panel > Add/Remove Prog ...Show All

• krymium SQL Express and selling as a hosting service.

  Hi, Can a web hosting company charge clients for using an SQL Express  instance on their network E.g. The host charges the client $x per month per instance. Is this legal MIcrosoft provides SQL Express Free Of Charge, if the hosters choose to charge you for the usage they can do that, I presume the charge covers the cost of hardwre, bandwidth etc. ...Show All

• Master Ruthless Grabbing the Top Nth Records based on another table per group

  Hi All, I am trying to perform a SQl query that I have never attempted before. I have a table with records such that would look like this GroupField1 GroupField2 Field1 Amount AAA BBB Field1Data 23.00 AAA BBB Feld2Data 24.00 AAA BBB Field3Data 8.00 BBB CCC Field1Data 25.00 BBB CCC Field2 Data 23.00 DDD BBH Field1Data 232.00 I have a second table that is like GroupField1 GroupField2 NumberOfRows AAA BBB 2 BB ...Show All

• Pete4096 one stored proc for multiple datasets

  hi all, i have a report which uses a few table layout. data for each table layout come from different datasets. table1 - dataset1 table2 - dataset2... for some reasons, i need to use stored proc. how can i put all the queries into 1 stored proc so that table1 will get data from dataset1 and so on please help. thanks! thanks Jens, thanks Robert. i was thinking that it's easier to keep and main ...Show All

• TDi Develop Object is invalid. Extended properties are not permitted on ...

  when attempting to execute the following query from within 2005 Mgmt Studio: sp_dropextendedproperty @name = 'test_me' , @level0type = 'schema' , @level0name = 'dbHSPS.dbo' , @level1type = 'table' , @level1name = 'Conflict' /*[ , [ @level2type = 'column'] { 'level2_object_type' } , [ @level2name = ] { 'level2_object_name' } ] */ I receive: "Object is invalid. Extended pr ...Show All

• LaurenEckert How to turn off Auto Recovery in SQL Server Management Studio 2005?

  Auto Recovery kicks in about every 5 minutes in SQL Server Management Studio 2005. Over a slow network connection, SSMS stops responding until the Auto Recovery completes. Auto Recovery can be turned off in Visual Studio 2005 but I have been unable to find how to turn it off in SSMS. Go to server->Properties dialog and go to connections tab and you can change the recovery interval here. Gops Dwarak ...Show All

• MoGram SQL 2005 Logshipping to secondary server

  I hope this hasn't been answered recently.. I have a primary SQL cluster, logshipping my SQL 2005 db to a secondary server used for the logshipping/recovery server only. Say my primary server starts on fire, melts down, etc. How do I bring the database on the secondary server online Do I need to roll in the transaction logs, etc. I'm looking for a step-by-step, as I am very new to SQL. I've seen some articles in the SQL Books Online, ...Show All

• ocanon Restore Report Designer?

  How do I restore the report designer in VS 2005 When I open an RDL file it is showing the RDL XML and not the development designer Thanks Scott ...Show All

• Leandro Ramos possibly merge join bug?

  i'm merge joining 2 data sources, one is oracle and the other is excel...the problem is in the oracle source, it's a sql statement like: select hdr.div_ord_no, hdr.mtr_no, hdr.prod_cd from qctrl_div_ord_header hdr, (select max(sub.eff_dt_from) min_eff_dt_from, div_ord_no from qctrl_div_ord_header sub group by div_ord_no ) tmp where hdr.eff_dt_from = tmp.min_eff_dt_from and hdr.div_ord_no = tmp.div_ord_no having that sql statement, me ...Show All

• BlackadderX XML not loading into SQL Server, because identity not incrementing

  I am having an issue loading data into a SQL table from an XML file. I have a Customer Table and a Phone Table related by a customer ID key. The primary key of the phone table is an autogenerated numeric field.  The identity of this field is set to yes, and the seed and increment are set to 1.  The foreign key relation is the customer ID. I am using the following script to read the XML file and pass the data to the database ...Show All

• Tim123 using ReportItems at report header

  hi all, i need to display the report date range at the report header according to month and year. Each month will be on a new page. my report is created using matirx. i embed the matrix in a list. i have a hidden textbox, that stores the month and year value for that page, embedded inside this list that group by month and year. my problem is the value of the textbox will only appear at the report header if the hidden textbox is on th ...Show All

• WuZhiming Nested Loops in the Control Flow

  I have a problem when using nested loops in my Control Flow. The package contains an outer Foreach Loop using the Foreach File Enumerator which in my test case will loop over two files found in a directory. Inside this loop is another Foreach Loop using the Foreach Nodelist Enumerator. Before entering the inner loop a variable, xpath, is set to a value that depends on the current file, i e /file[name = '@CurrentFileName']/content . The Nodelist ...Show All

• pascalh Basic Connection

  Ok. Basically I do not know how to access any database files from the SQL Server. Can someone help me please. How do I access the files from another computer. Hi,   did u give the login permissions to ur other computer wat i mean is on the sql server-->Security-->Logins(right click)New Logins n then just write the login name of ur other computer and give urself rights to access all the files in the sql server....is it of some h ...Show All

• Jitendra Kumar Mehta Another question about Login failed, but with Windows NT Integrated security for SQL 2005

  Hi, Happy New Year!   I have been struggling with this problem for a while with SQL 2005.   I have never had such login problem with SQL 2000. Here is the scenario:   I have installed SQL2005 standard version on a XP Pro box and I am trying to access it from another XP Pro machine.   I can access it using a SQL user name and password that I set up on the server, but I have not had luck with using Wind ...Show All

• Zakssj Feature Pack and SP1

  I posted this over on, I guess, the other SQL Server forum (msdn.microsoft.com/newsgroups). Sorry if it's a cross post or better answered there. Does anyone know if the feature packs are included in SP1 or still need to be installed separately. They will continue to be separate. Thanks, Peter Saddow ...Show All