InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 15:31:22 GMT20http://www.sqlservercentral.com/Forums/Topic478940-1238-1.aspxThanks, I learned again something new about SQL server, just 2 days after I had troubles running SQL server on vista :-).And also, it's not bad to have an error here once and a while. You know that the biggest inventions almost all started with something been wrong... Quality is good, but quality should not block creativity, nor trial and error. Trial and error is our main way of learning and growing.Mon, 07 Apr 2008 01:17:33 GMTCarl Janssenhttp://www.sqlservercentral.com/Forums/Topic478940-1238-1.aspx[quote][b]bitbucket (4/3/2008)[/b][hr]Here we go again .... For Steve and others - might I suggest asking a few users to form a panel to check the questions BEFORE they are published as QOD.[/quote]Second the motion on that one. Would also reduce the load on Steve for making sure these are correct.Thu, 03 Apr 2008 08:31:33 GMTGSquaredhttp://www.sqlservercentral.com/Forums/Topic478940-1238-1.aspxTo Everyone that posted a comment about my QOD:Thank You! I appreciate the feedback. My goal of the QOD was to get people to look into the SQL Server 2005/Vista/Office 2007 Compatibility Topic. Mission Accomplished in my eyes.To those of you who left a scathing comment before the technical issue with the Answer Key was fixed:[quote]Steve Jones:Anyone wishing to complain about quality or how easy it is to write a question is urged to submit their own. http://www.sqlservercentral.com/Contributions/Home[/quote]To those who have given constructive feedback or given a solution to those experiencing issues with SQL Server 2005 and Vista/Office 2007, thanks for your input and sharing your troubleshooting advice.Best Regards,Thu, 03 Apr 2008 08:23:04 GMTKey DBAhttp://www.sqlservercentral.com/Forums/Topic478940-1238-1.aspxThanks Steve. I just answered and it's working correctly now.Where I agree on the idea of a review panel, I still learn new things even if the QotD answer or question isn't accurate thanks to the rest of the community. :)CheersThu, 03 Apr 2008 07:35:37 GMTJeff Delucahttp://www.sqlservercentral.com/Forums/Topic478940-1238-1.aspxPoints awarded back. It was a simple checking of the wrong box for the correct answer.Anyone wishing to complain about quality or how easy it is to write a question is urged to submit their own. http://www.sqlservercentral.com/Contributions/HomeGood guess, Tim, but I had enough April Fool's stuff this week already :)Thu, 03 Apr 2008 07:20:30 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic478940-1238-1.aspxHere we go again .... For Steve and others - might I suggest asking a few users to form a panel to check the questions BEFORE they are published as QOD.Thu, 03 Apr 2008 06:57:07 GMTbitbucket-25253http://www.sqlservercentral.com/Forums/Topic478940-1238-1.aspxbah... give me my point! :hehe:Thu, 03 Apr 2008 06:41:36 GMTthe__thttp://www.sqlservercentral.com/Forums/Topic478940-1238-1.aspx[quote][b]dominik.ladich (4/3/2008)[/b][hr]Even if SP 2 is the correct answer, I don't think it is correct, as I'm running a SQL 2005 SP 2 Client on Vista, which cannot display the properties of a job ;-)regards[/quote]The database server you are connected to is not at SP2. Both SSMS and SQL Server engine need to be at SP2.Hope this helpsThu, 03 Apr 2008 06:40:22 GMTMark Harrhttp://www.sqlservercentral.com/Forums/Topic478940-1238-1.aspxSimple explanation: this is just a leftover April Fool's QOTD. Just give everyone a point who submits an answer, give me 5000 points for coming up with this glorious solution and call it a day!Leave the answer explanation as confusing, contradictory and vague as it currently is. We're M$ professionals: contradictory confusion is our language!Peace-Out Fellow SQL-ites!:DThu, 03 Apr 2008 06:28:31 GMTTimothy Ford-473880http://www.sqlservercentral.com/Forums/Topic478940-1238-1.aspxLooks like this one got set up incorrectly.Thu, 03 Apr 2008 06:18:24 GMTGSquaredhttp://www.sqlservercentral.com/Forums/Topic478940-1238-1.aspxSQL Server was not fully compatible with VISTA until SP2. See following link:http://www.microsoft.com/sql/prodinfo/previousversions/faq-sql_on_vista.mspxThu, 03 Apr 2008 06:00:44 GMTWilliam Vachhttp://www.sqlservercentral.com/Forums/Topic478940-1238-1.aspx-- Even if SP 2 is the correct answer, I don't think it is correct, -- as I'm running a SQL 2005 SP 2 Client on Vista, which cannot -- display the properties of a job ;-)If that's the case, then SQL 2005 Sp2 isn't compatible with anything. Half the time I have to jump through hoops just to get SP2 to install.Thu, 03 Apr 2008 05:53:30 GMTTimothy Bakerhttp://www.sqlservercentral.com/Forums/Topic478940-1238-1.aspxThere has to be some error. The only answer that's correct is SP2, the explanation says SP2, but the result of choosing SP2 is that you are wrong?!!Thu, 03 Apr 2008 05:28:49 GMTLisa Philliphttp://www.sqlservercentral.com/Forums/Topic478940-1238-1.aspxAre you testing the server to see how much email can go through on a given day? If you punch in the correct answer, which is SP2 of SQL 2005, it comes up saying the answer is wrong that the correct answer is SP2 for SQL 2005. What's up with that?Thu, 03 Apr 2008 05:20:56 GMTJamie Longstreet-481950http://www.sqlservercentral.com/Forums/Topic478940-1238-1.aspxOh well... Looks like the scoring key is wrong again. Glad they don't do exam testing:hehe:Thu, 03 Apr 2008 04:44:42 GMTPurpleLadyhttp://www.sqlservercentral.com/Forums/Topic478940-1238-1.aspxEven if SP 2 is the correct answer, I don't think it is correct, as I'm running a SQL 2005 SP 2 Client on Vista, which cannot display the properties of a job ;-)regardsThu, 03 Apr 2008 04:44:16 GMTdominik.ladichhttp://www.sqlservercentral.com/Forums/Topic478940-1238-1.aspxSorry but your explanation is incompatible with the answer.Thu, 03 Apr 2008 04:34:41 GMTKennyClarckhttp://www.sqlservercentral.com/Forums/Topic478940-1238-1.aspxIf the explanation is correct, the answer is incorrect.RoyThu, 03 Apr 2008 04:22:30 GMTrforknerhttp://www.sqlservercentral.com/Forums/Topic478940-1238-1.aspxConfusing,i checked the Windows Vista Compatibility List and found:Microsoft SQL Server 2005 x64 & x86 (needs SQL Server 2005 SP2 installed to run best in Vista). Note: SP2 has not been released yet, it's only beta and [b]Microsoft recommends not to install it in production machines. The major issue with SQL 2005 is that it doesn't inherit credentials from Windows[/b], as a result, any application attempting to access the db engine will have to run as administrator or the Authenticated users group will have to manually be added to to the SQL logins. Manager Studio requires administrator's privileges or to manually add user accounts to sysadmin group. SP2 should be the correct answer i think.Thu, 03 Apr 2008 03:27:21 GMTJambolehttp://www.sqlservercentral.com/Forums/Topic478940-1238-1.aspxI live this forum but QoD makes me crazy too often...:crazy:Thu, 03 Apr 2008 02:32:25 GMTMichal Mokroshttp://www.sqlservercentral.com/Forums/Topic478940-1238-1.aspxSP2 or higher is the corect answer (just try to use datamining functionallity in Excel without SP2 or higher it will fail)So or the question is wrong but the anwer to this question is sp2 or higher for sureGreetings Niels NagléThu, 03 Apr 2008 02:02:13 GMTNiels Nagléhttp://www.sqlservercentral.com/Forums/Topic478940-1238-1.aspxAs I see it, what most people are answering, and what the explanation says is correct, are the same, but that a mistake has been made in the configuration of the QOTD app (so that an incorrect answer is the one flagged as the right one).Now we've highlighted this, can I PLEASE request that we don't do the same as with the "Order By" question and submit 11 pages of "I answered this and it seems to be right, but I've been told it's wrong so can I have my point back please".Thu, 03 Apr 2008 01:58:09 GMTmajorbloodnockhttp://www.sqlservercentral.com/Forums/Topic478940-1238-1.aspxCorrect answer: SQL Server 2005 RTM Explanation: SQL Server Service Pack 2 or greater is needed to be fully compatible with Windows Vista and Microsoft Office 2007. This makes no sense. Please can the questioners take more care before submitting questions, as there seem to have been a few debatable answers lately. Whilst its good to get the forum busy to increase knowledge, it doesn't help to confuse people.Geoff.Thu, 03 Apr 2008 01:50:00 GMTGeoff Langdonhttp://www.sqlservercentral.com/Forums/Topic478940-1238-1.aspxWeird.Correct answer: SQL Server 2005 RTM Explanation: SQL Server Service Pack 2 or greater is needed to be fully compatible with Windows Vista and Microsoft Office 2007. Doh! Pass the six pack.Thu, 03 Apr 2008 01:47:45 GMTjfmccabehttp://www.sqlservercentral.com/Forums/Topic478940-1238-1.aspxGlad I'm not the only one who doesn't understad it???Have a nice daycarlThu, 03 Apr 2008 01:46:44 GMTCarl Janssenhttp://www.sqlservercentral.com/Forums/Topic478940-1238-1.aspx?? Correct answer: SQL Server 2005 RTM Explanation: SQL Server Service Pack 2 or greater is needed to be fully compatible with Windows Vista and Microsoft Office 2007. I chose SP 2 as well in the mistaken belief Microsoft are right.Thu, 03 Apr 2008 01:36:52 GMTCraig@Workhttp://www.sqlservercentral.com/Forums/Topic478940-1238-1.aspxI think SQL Server SP2 is the right answer.Thu, 03 Apr 2008 00:41:02 GMTChiragNShttp://www.sqlservercentral.com/Forums/Topic478940-1238-1.aspxI am totally confused.The explanation for the answer says that SQL Server 2005 SP2 or greater is required to be fully compatible with vista and office.But the correct answer seems to be SQL Server 2005 RTM.Can anybody detail more on this?:DThu, 03 Apr 2008 00:36:20 GMTarvindravishhttp://www.sqlservercentral.com/Forums/Topic478940-1238-1.aspxdear friend, you need to update your knowledge properly and after cross check it, you should submit your questions. Plz don't mind but you are makeing the things confuse. reff: http://www.microsoft.com/presspass/press/2007/Feb07/02-19SQLSP2PR.mspxWed, 02 Apr 2008 23:24:40 GMTAmit-695544http://www.sqlservercentral.com/Forums/Topic478940-1238-1.aspxI'm lost, I chose SQL Server 2005 SP2, but it tells me it's wrong, and the correct answer is SQL Server 2005 RTM. But the explanation and the links all said SP2, not RTM[quote]Correct answer: SQL Server 2005 RTM Explanation: SQL Server Service Pack 2 or greater is needed to be fully compatible with Windows Vista and Microsoft Office 2007. Ref: SQL Server 2005 Service Pack 2 Web Site - http://technet.microsoft.com/en-us/sqlserver/bb426877.aspx [/quote]Wed, 02 Apr 2008 22:04:21 GMTIggy-SQLhttp://www.sqlservercentral.com/Forums/Topic478940-1238-1.aspxI think you got it wrong. Isn't the right question "Which version of Windows Vista is compatible with SQL 2005?" PhilipWed, 02 Apr 2008 21:10:06 GMTPhilip Kelleyhttp://www.sqlservercentral.com/Forums/Topic478940-1238-1.aspxComments posted to this topic are about the item [B]<A HREF="/questions/SQL+Server+2005/62405/">SQL Server 2005, Windows Vista and Office 2007 Compatibility</A>[/B]Wed, 02 Apr 2008 21:09:04 GMTKey DBA