[SQL 2012] how to solve this |
- how to solve this
- Can I have SQL 2012 AND SQL Express 2008 R2 installed on the same machine?
- Sql Server 2012 can't see 2nd drive
- Error in attaching Adventureworks 2012 database
| Posted: 30 Sep 2013 01:40 AM PDT two tablestable1 table2StudentId studentidTestId teacheridQuestionId classidPointsAchievedPointsPossible Write a query that would return teachers who's students had highest overall percent correct on 10 questions with lowest overall percent correct. Percent correct is points achieved/points possible. |
| Can I have SQL 2012 AND SQL Express 2008 R2 installed on the same machine? Posted: 30 Sep 2013 12:48 AM PDT I'm looking at removing the SQL Server 2008 R2 Developer Edition that I have installed on my machine (a Windows 7 Ultimate machine), and updating to SQL Server 2012 Developer Edition. I also have SQL Server 2008 R2 Express installed, using a named instance (SQLExpress). Can I have both installed on the same machine? (I'll want SQL 2012 to be the default instance.) |
| Sql Server 2012 can't see 2nd drive Posted: 14 May 2012 02:33 PM PDT I installed Sql Server 2012 Express. Everything went without a hitch until I attempted to create a new database and place it on a second drive (E:). The location window displays C: and an external drive (Z:), but not the E: drive where I wish to place the database. Permissions show full control, but Sql Server won't display it. |
| Error in attaching Adventureworks 2012 database Posted: 27 May 2013 09:55 AM PDT hi i have problem in attaching Adventure works 2012 database Attach database failed for Server '..........\MSSQLSERVER2012'. (Microsoft.SqlServer.Smo)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=11.0.2100.60+((SQL11_RTM).120210-1917+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476------------------------------ADDITIONAL INFORMATION:An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)------------------------------Directory lookup for the file "C:\CodePlex Database\AdventureWorks2012_log.ldf" failed with the operating system error 2(The system cannot find the file specified.). (Microsoft SQL Server, Error: 5133) |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2012 / SQL 2012 - General To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment