System tables in drop down menu

Asked By murtazabhurano 0 points N/A Posted on - 06/08/2012

How to view System tables in drop down menu of a database in SQL SERVER 2005 Express edition and OS-Windows XP professional SP2??

• Status: Open
• Question Views: 899
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Server Software

Best Answer by Sharath Reddy

Go To Solution

Answered By pobmxxso 0 points N/A #160727

System tables in drop down menu

 

Using SQLServer Management Studio you will be able to see them under System Databases/msdb/tables/system tables

 

With SQL Server Enterprise Manager they are viewed under the msdb database tables

About pobmxxso

Questions
0

Answers
1

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 06/08/2012
• Question Category: Server Software

Best Answer

Best Answer

Answered By Sharath Reddy 590495 points N/A #160729

System tables in drop down menu

If you are wondering on how to view the system tables on SQL Server Express 2005, there is a much easier way of displaying or listing all the tables of a database using system table sys.Tables. See below.

This will return all the tables in the database which users have created. And also, if you happen to encounter problems installing SQL Server Express 2005, the following procedure might help you solve it. See if these steps work for you.

• Uninstall Microsoft .NET Framework if you have any installed on your computer.
• Install Microsoft .NET Framework 2.0.50215.312. When I checked, this version is no longer available on Microsoft. Instead, try installing Microsoft .NET Framework 2.0 Service Pack 2 from Microsoft | Download Center | Microsoft .NET Framework 2.0 Service Pack 2.
• Restart your computer after installing Microsoft .NET Framework.
• Install SQL Server 2005 Express.
• Install the Microsoft SQL Server Express Manager.

About Sharath Reddy

Questions
1

Answers
14599

Best Answers
2290

• Vote Up 0 Vote Down

• Posted on - 11/15/2012
• Question Category: Server Software