0 (Intel X86) 11:57:00 Copyright (c) Microsoft Corporation Express Edition with Advanced Services on Windows NT 5. Any ideas? Thanks.ĮDIT: select returns "Microsoft SQL Server 2008 R2 (RTM). Lastly, right clicking on a database in SSMS and navigating to "Tasks" does not show any Maintenance Plan option.Ĭlearly, I'm missing something, and Google is coming up empty considering the scenario I've outlined. I am logging in as the SQL account sa, and the account does have the sysadmin server role. I have checked the version and verified the splash screen when studio starts are not Express. I am certain this is SQL Server 2008 R2 and not Express. It is not under Management -> Legacy either, as it would be if there were legacy-mode databases on the server. Future releases of Microsoft SQL Server 2008 R2 Management Studio Express will not have this problem. Select the option to Run Program to continue. Under Management in SQL Studio 2008 R2, there is no maintenance plans folder. For Windows 7 and Windows Server 2008 R2, the install process displays the Program Compatibility Assistant dialog indicating that you must apply SQL Server 2008 Service Pack 1 or later. A client has SQL Server 2008 R2 installed on a Windows 2003 R2 32-bit server.
0 Comments
Leave a Reply. |