System tables in drop down menu

Asked By 0 points N/A Posted on -
qa-featured

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

SHARE
Best Answer by Sharath Reddy
Answered By 0 points N/A #160727

System tables in drop down menu

qa-featured

 

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
Best Answer
Best Answer
Answered By 563960 points N/A #160729

System tables in drop down menu

qa-featured

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.

Login/Register to Answer

Related Questions