Sql server 2008 r2 list of tables and other objects is incovenient vs Sql server 2000

Posted on 2013-11-21
Last Modified: 2013-11-26
Recently I upgraded an sql server 2000 database to sql server 2008 r2... But I saw that the list of tables, jobs,sps and others is not in an convenient format as was like in sql server 2000 where we had a list of jobs with more information at a glance... I thought that when we upgrade something then we have more convenient environment to work not the opposite...
Question by:nonlinearly
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
  • 2
LVL 25

Expert Comment

by:Lee Savidge
ID: 39665476
So what exactly is your question?
LVL 25

Expert Comment

by:Lee Savidge
ID: 39665479
Not every upgrade is better.

DOS -> Windows = downgrade
Windows 98 -> Windows ME = downgrade
Windows XP -> Vista = downgrade
Windows 7 -> Windows 8 = downgrade

Sometimes you just have to work with what you've got.

Author Comment

ID: 39665512
The question is obvious and has to do with a confirmation... I am right or is there alternative view?
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

LVL 25

Expert Comment

by:Lee Savidge
ID: 39665534
The question isn't obvious as you've just made a statement saying that you don't like the interface changes.

SQL Interface for SQL 2008 R2
What is wrong with this interface? It shows you a split by database and within each database you can see your stored procedures and functions and then if you expand the tables you can see your triggers and indexes. I find this a very convenient interface for the most part. The only bit I don't particularly like is if I'm trying to find a trigger and I am not sure what table it is on but then I can write a query to list me the triggers.
LVL 25

Expert Comment

by:Lee Savidge
ID: 39665538
For a list of Jobs you can expand the SQL Server Agent branch. For Maintenance Plans you expand the maintenance branch.

Author Comment

ID: 39665569
It is obvious that you have not worked with Sql Server 2000...
Thanks anyway...
LVL 25

Expert Comment

by:Lee Savidge
ID: 39665672
Thank you for your observation. I have been working with SQL since version 6.5 days which was back before SQL 2000 and I've been working with it ever since, so yes, I have worked with SQL 2000 but not for a number of years now, since about 2005 and certainly not since its mainstream support ended back in 2008.

This forum is to ask for help with a problem you're having. You have expressed an opinion because you don't like something and not asked a question. Your query is asking an opinion at best because the answer you strive for is based on a very subjective statement as you find that the updated layout is not convenient for you. This is not a question and therefore has no definitive answer.

I'm sorry you haven't found what you're looking for.
LVL 27

Expert Comment

ID: 39665865
In order to be able to help we need few clarifications:

1. Can you give an example of what you see and what you expected?

2. Are you looking for something in particular?

Author Comment

ID: 39668369
Ok... so... Can you make a sorting in jobs in the field of disabled job like in sql server 2000? Or if I want to find a table I can type the firsts letters like in Sql server 2000 but now I have the dbo. in front of the table name and the time I have to type until the first leter of the table is not enough... Or if I want to find at a glance information for all jobs (like the next schedule time) without having to go through each job's properties...
Is there anyone that can not understand the difference? I am surprised!
I have 60 jobs and 3.000 tables so it is obvious that I am suffering with this new viewing format...
LVL 27

Accepted Solution

Zberteoc earned 500 total points
ID: 39668621
For jos expand the SQL Server Agent node and then double click on Job Activity Monitor. In the window that opens you will see a list of jobs. You can order that list by any column asc or desc by clicking on the column header.

In the case of the tables you can right click on the Tables node and then set a filter but what you say worked in 2000 doesn't exist anymore.

For a list of tables in any database you can execute:
select * from database_name.INFORMATION_SCHEMA.TABLES order by TABLE_TYPE,TABLE_NAME

Open in new window

This will give you a list of tables on top and views on bottom in alphabetical order.

I understand that it can be frustrating that things change and behave differently but that is life, ultimately, and we all have to adapt. Change is generally good and it is done for a reason, exceptions can exist though, but in the end we will come to use to the new features and understand their benefit.

Author Closing Comment

ID: 39677203
"...but in the end we will come to use to the new features and understand their benefit."
I do not see the benefit to find quickly a specific table among 3000 tables in this tree view anyway...

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Server Agent Job Error 13 83
Removing SCCM 2016 4 53
Powershell error using sql agent job 24 41
Total count in section based report in SSRS 10 16
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question