Microsoft SQL Server Management Studio Express

I get alot of questions like this - who do I graphically design DB's with SQL Server 2005 Express Edition without installing a Visual Studio Express solution?

Here, download this - Microsoft SQL Server Management Studio Express:

http://www.microsoft.com/downloads/details.aspx?FamilyID=82afbd59-57a4-455e-a2d6-1d4c98d40f6e&DisplayLang=en

posted on Monday, February 27, 2006 8:43 AM

Feedback

# re: Microsoft SQL Server Management Studio Express 3/13/2008 3:52 AM sandeep rastogi

TITLE: Microsoft SQL Server Management Studio Express
------------------------------

Restore failed for Server 'HCL-BAF46434EAD\SQLEXPRESS'. (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

System.Data.SqlClient.SqlError: The operating system returned the error '5(Access is denied.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\livestock.MDF'. (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

# Microsoft SQL Server Management Studio Express 3/13/2008 4:03 AM sandeep rastogi

hi,
i try to restore bakup file of sql server 2000 into sql server express 2005 it gives an error msg..

TITLE: Microsoft SQL Server Management Studio Express
------------------------------

Restore failed for Server 'HCL-BAF46434EAD\SQLEXPRESS'. (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

System.Data.SqlClient.SqlError: The operating system returned the error '5(Access is denied.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\livestock.MDF'. (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

whlie i'm restoring back file of sql server express 2005 into sql server express 2005 it work........

plz , some one try to solve the problem.

thanks
sandeep

# re: Microsoft SQL Server Management Studio Express 8/3/2008 4:42 PM mohamed bakry

TITLE: Microsoft SQL Server Management Studio Express
------------------------------

Attach database failed for Server 'df'. (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&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.Express.ConnectionInfo)

------------------------------

Could not find row in sysindexes for database ID 8, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.
Could not open new database 'ERP'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 602)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=602&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

Post Feedback

Title:
Name:
Email: (never displayed)
Url:
Comments:
Please add 5 and 8 and type the answer here: Remember Me?

Nikita Polyakov

News

Archives

Feedback

Post Feedback