The folder « C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Update Cache » is used to verify what are the service packs or cumulative updates already installed and it is also not indicated to delete it.
The content from SQL server 2008 must be migrated to the 2012 supported formats. The approach I am going to take is the second, since I have a new hardware and I am going to do a fresh SQL Server 2012 installation. The migration from SQL server 2008 to 2012 must be well prepared and tested before going to production.
I'm in the process of installing a client's ASP.net site on a Windows Server 2003 box running Sql 2008. The site uses Report Viewer 2012, but when I attempted to install it on the server, I got the message "CLR Types for Sql Server 2012" were missing.
I was looking for a CONCAT function in SQL Server 2008 R2. I found the link for this function. But when I use this function, it gives the following error: Msg 195, Level 15, State 10, Line 7 '...
5 We just migrated our Microsoft SQL Server from 2005 enterprise to 2008 standard on the same specification hardware. The databases were backed up and then restored to a clean sql 2008 install. The compatibility level is currently at 90 (2005). None of the Enterprise features were being used on 2005 (thus the edition downgrade).
When you install SQL Server 2008 one of the screens asks what accounts should have Administrative Rights to the SQL Server Instance. If you don't select and accounts, then no accounts have admin rights as the BUILTIN\Administrators group is no longer a member of the sysadmin fixed server role by default.
Working with security in SQL Server 2008, I'm trying to grant a user CREATE TABLE permissions, but only within a specific schema. Does CREATE TABLE permission only apply at the database level? Ca...
