SQL Server Management Studio

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

schedule a restore plan

using sql 2005, management studio,, how to schedule a daily database and restore plan.

View Answer   |  May 8 2008   1:58 PM GMT   |  asked by DRE1
SQL Server restore, SQL Server Management Studio, SQL Server backup

How do my database sql2005 database to another server with management studio

Has sql 2005, using management studio to do a full backup of my database. Using maintenance wizard to set the backup. I only see my local drive and not my share folder created onthe other server where i want to place the .bak file. Any idea will be helpfull.

View Answer   |  May 5 2008   2:10 PM GMT   |  asked by DRE1
SQL Server backup, SQL Server Management Studio, SQL Server 2005

having problem with SSIS package

i have created the SSIS package from sql server Server management and its work fine but the problem I’m having, when I try to run it from SQL Server Management jobs.Every time when train it from Sql jobs it failed.Please advice on ….

View Answer   |  Apr 30 2008   7:12 PM GMT   |  asked by Atif
SSIS Package, SSMS, SSIS