how to upgrade server to SQL 2005
I have a system with MS SQL Server 2005 installed and am running the MS SQL Server Management Studio Express but when I query the database version it comes back as SQL 2000 - 8.00.194. How do it change to using SQL 2005?
View Answer
| Jun 5 2008 11:08 PM GMT
| asked by
Cjdechris
SQL Server 2005, SQL Server upgrades, SQL Server Management Studio
Migrating from MS Access to SQL Server Express
I've just installed SQL Server Express and I want to create a local instance. I would like to use SQL Server to do my analysis in running queries instead of Microsoft Access. I want to import my tables from Access to SQL Server Express. How can I migrate from MS Access to SQL Server?
View Answer
| Apr 18 2008 1:01 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server migration, SQL Server Express Edition, Microsoft Access
fore front - Can FCS be installed on sql express 2005
Can FCS be installed on sql express 2005, and if yes what is the requirementsas per the web site it can be done but how !!!!??? eveywhere else they are saying its not supportedhttp://www.microsoft.com/forefront/serversecurity/mgmt/sysreqs.mspx
View Answer
| Apr 8 2008 12:45 AM GMT
| asked by
Rami
SQL Server Express Edition, FCS, Forefront Client Security
How to create a maintenance plan in SQL Server Management Studio Express
I’m running SQL Server 2005 Workgroup edition with SP2. I’m trying to create a new Maintenance Plan in Microsoft SQL Server Management Studio Express (MSSMSE) by right clicking on the Maintenance Plans object icon. The only option is Refresh - there’s no manual method or wizard.I'm logging in...
View Answer
| Mar 19 2008 0:00 AM GMT
| asked by
SQL Server Ask the Experts
SQL Server 2005, SQL Server Express Edition, Microsoft SQL Server Management Studio
