![]() |
![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
| Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks. |
| |||||||
![]() |
| |
| | #1 (permalink) |
| | Vista Home Premium And SQL Server 2005 Standared Edition... Colleagues: Would appreciate any advice / perspective re the following issues with SQL Svr 2005 Standard Edition (with SP2 applied) and Vista Home Premium: 1. All system "dbcc" maintainence queries (reindex, checktable, checkdatabase, etc) stop running after about 4 minutes, I lose the mouse, the box totally freezes up, must restart the computer 2. Cannot use CREATE INDEX to create a non clustered index on an integer data field - after running for about 10 minutes, the box locks up 3. Cannot import or export data (in any larger amounts - ie over 10 million rows) The box just locks up. 4. Cannot run INSERT queires that insert more rthan a few hundreed thousand rows without the box freezing up 5. Printing any documents takes several minutes I've enabled lots of growth in the database log. Other (older, slower) boxes on my network continue to work fine. Am suspecting that a permissions / security issue is in play. Thanks for any suggestions, Michael |
My System Specs![]() |
| | #2 (permalink) |
| | Re: Vista Home Premium And SQL Server 2005 Standared Edition... <michael.dataSense@sympatico.ca> wrote in message news:1184524010.000907.304500@57g2000hsv.googlegroups.com... > Colleagues: Would appreciate any advice / perspective re the > following issues with SQL Svr 2005 > Standard Edition (with SP2 applied) and Vista Home Premium: > > 1. All system "dbcc" maintainence queries (reindex, checktable, > checkdatabase, etc) stop running after about 4 minutes, I lose the > mouse, the box totally freezes up, must restart the computer > > 2. Cannot use CREATE INDEX to create a non clustered index on an > integer data field - after running for about 10 minutes, the box locks > up > > 3. Cannot import or export data (in any larger amounts - ie over 10 > million rows) The box just locks up. > > 4. Cannot run INSERT queires that insert more rthan a few hundreed > thousand rows without the box freezing up > > 5. Printing any documents takes several minutes > > I've enabled lots of growth in the database log. Other (older, > slower) boxes on my network continue to work fine. Am suspecting that > a permissions / security issue is in play. > > Thanks for any suggestions, If you have Vista pre installed or if you have upgraded Vista over the top of XP, then you might want to flatten the HD and install Vista fresh. You might also want to consider Vista Ultimate, Business or Enterprise as those are business class O/S(s). As an example, IIS7 on Home Premium is not a full version of IIS7 and doesn't have FrontPage Extensions, although I hear there is some kind of patch for that, while the ones above do. So you can only do Mickey Mouse Web Development with HP, I use SQL Server 2005 Express on Vista Ultimate, IIS7 and .Net 2005. I don't have a problem on this laptop in running those solutions. I would like to get SQL Sever 2005 SE and install it. I wouldn't install it on XP Home, and I wouldn't install on Vista HP. |
My System Specs![]() |
| | #3 (permalink) |
| | Re: Vista Home Premium And SQL Server 2005 Standared Edition... On Jul 15, 4:33 pm, "Mr. Arnold" <MR. Arn...@Arnold.com> wrote: > <michael.dataSe...@sympatico.ca> wrote in message > > news:1184524010.000907.304500@57g2000hsv.googlegroups.com... > > > > > > > Colleagues: Would appreciate any advice / perspective re the > > following issues with SQL Svr 2005 > > Standard Edition (with SP2 applied) and Vista Home Premium: > > > 1. All system "dbcc" maintainence queries (reindex, checktable, > > checkdatabase, etc) stop running after about 4 minutes, I lose the > > mouse, the box totally freezes up, must restart the computer > > > 2. Cannot use CREATE INDEX to create a non clustered index on an > > integer data field - after running for about 10 minutes, the box locks > > up > > > 3. Cannot import or export data (in any larger amounts - ie over 10 > > million rows) The box just locks up. > > > 4. Cannot run INSERT queires that insert more rthan a few hundreed > > thousand rows without the box freezing up > > > 5. Printing any documents takes several minutes > > > I've enabled lots of growth in the database log. Other (older, > > slower) boxes on my network continue to work fine. Am suspecting that > > a permissions / security issue is in play. > > > Thanks for any suggestions, > > If you have Vista pre installed or if you have upgraded Vista over the top > of XP, then you might want to flatten the HD and install Vista fresh. > > You might also want to consider Vista Ultimate, Business or Enterprise as > those are business class O/S(s). > > As an example, IIS7 on Home Premium is not a full version of IIS7 and > doesn't have FrontPage Extensions, although I hear there is some kind of > patch for that, while the ones above do. So you can only do Mickey Mouse Web > Development with HP, > > I use SQL Server 2005 Express on Vista Ultimate, IIS7 and .Net 2005. I don't > have a problem on this laptop in running those solutions. > > I would like to get SQL Sever 2005 SE and install it. I wouldn't install it > on XP Home, and I wouldn't install on Vista HP.- Hide quoted text - > > - Show quoted text - Hi - thanks for writing - the box came with Vista pre-installed. Microsoft says that SQL Server should run with Home Premium as long as SP2 of Sql Svr is installed. Am seriously considering putting Windows Server 2003 (w SP2) on the box as I have other boxes with Server 2003 and none of the problems above occur. Best wishes, Michael |
My System Specs![]() |
![]() |
| Thread Tools | |
| |
Similar Threads | ||||
| Thread | Forum | |||
| Vista Ultimate Upgraded from Home Premium fails to install Virtual Server 2005 R2 SP1 | Windows Updates | |||
| Sharing Database via SQL Server 2005 - Vista Home Premium | Vista networking & sharing | |||
| SQL Server 2005 Express Edition | Vista installation & setup | |||
| Microsoft SQL Server 2005 Compact Edition RC1 (Supports Vista) | Vista General | |||
| Avast 4.6 Server Edition and 4.7 Home Edition Internet Shield does NOT work on both Windows Vista Client X64 Beta 2 and Server X64 Beta 2. | Vista General | |||