Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 268
  • Last Modified:

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

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...
0
nonlinearly
Asked:
nonlinearly
  • 5
  • 4
  • 2
1 Solution
 
Lee SavidgeCommented:
So what exactly is your question?
0
 
Lee SavidgeCommented:
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.
0
 
nonlinearlyAuthor Commented:
The question is obvious and has to do with a confirmation... I am right or is there alternative view?
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Lee SavidgeCommented:
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.
0
 
Lee SavidgeCommented:
For a list of Jobs you can expand the SQL Server Agent branch. For Maintenance Plans you expand the maintenance branch.
0
 
nonlinearlyAuthor Commented:
It is obvious that you have not worked with Sql Server 2000...
Thanks anyway...
0
 
Lee SavidgeCommented:
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.
0
 
ZberteocCommented:
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?
0
 
nonlinearlyAuthor Commented:
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...
Thanks...
0
 
ZberteocCommented:
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.
0
 
nonlinearlyAuthor Commented:
"...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...
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 5
  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now