Limiting Tables Displayed In New Window For SQL 2000 Enterprise Manager

Jul 20, 2005

Can anyone tell me if there's a way to create new windows from the
tables section of a database in Enterprise Manager such that I can
limit the tables included in that window? Ultimately, I'm looking for
a solution whereby I can group tables, stored procedures, etc. into
logical groups that can then be displayed using different MMC
consoles. I'm looking for either a GUI-level or programatic approach.

Thank you,
Dax Westerman

View 1 Replies


ADVERTISEMENT

Enterprise Manager Missing Close Window

Aug 2, 2002

Hi, all:

I insalled SQL 2000 server standard version on Windows 2000 server, then I applied SQL 2000 sp2 to it. Every step told me installation was successful.

Everything sounds working except following:

I lauch Enterprise manager, serverName / databaseName(ex. pubs) / Stored Procedure, then double click one of Stored Procedures, Stored Procedures properties window pop up. On the right top corner those three small buttons (minimize, resize and close) are missing. No way to close Stored Procedures properties window except using task manager to kill it. That drives me nut.

Any idea?

Thanks!

Theresa

View 3 Replies View Related

What's New In Enterprise Manager 2000?

Jun 16, 2005

Is there anything significantly better in Enterprise Manager 2000 vs. the old EM from SQL Server 7.0?

If so I'd be willing to pay the $50 for the SQL Server 2000 Developer
Edition to get it... if not it seems dumb to pay for anything when MSDE
2000 is free and I already have the old EM.  (Although I have
installed MSDE 2000 as a new instance and can't figure out how to get
at it via EM.) 

Thanks for any insight.

View 11 Replies View Related

Enterprise Manager 2000

Dec 5, 2000

I have just discovered something with EM 2000. In the old days (SQL Server 7), you could right click on a table, choose OPEN TABLE -> SELECT ALL ROWS and get a nice little grid with the select results. The same is true in SQL Server 2000. One thing you cannot do is update a value in that result set, which WAS something you could do in SQL Server 7. If you try it in EM 2000, you get the error message "TRANSACTION CANNOT BE STARTED WHILE IN FIREHOSE MODE". ???????
Am I just missing something, or was Microsoft so worked up about putting XML into their product, they overlooked some of the simple things that were really appreciated (and sorely missed).
If anyone can provide some insight, it would be appreciated.

Thank You

View 2 Replies View Related

Enterprise Manager 7.0/2000

Feb 25, 2002

Can the SQL 2000 Enterprise Manager be successfully installed and utilised on a pc that currently has SQL 7 and is used to administer other SQL 7 servers? Can the SQL 2000 Enterprise Manager be used to administer SQL 7?

Thanks.

View 2 Replies View Related

Having Enterprise Manager 7.0 And 2000 On Same PC

Aug 31, 2005

Can you have MS SQL Enterprise Manager 7.0 and 2000 on the same computer? If so, are there any special steps involved?

Thanks,

Dave

View 3 Replies View Related

Enterprise Manager - Cant Open Tables

Jun 19, 2001

If we attempt to open a table in Enterprise Manager this error message appears

View 1 Replies View Related

Update From Two Tables In Enterprise Manager

Feb 19, 2004

Hi,
I'm trying to write a query (in enterprise manager) that will update one table's column with data from another table's column. Yet I can't seem to do it!!! Enterprise Manager won't accept UPDATE.. FROM clause, and I dont know how to do it otherwise!

Here is the structure:

Table A: col a, col b, col c

Table B: col A, col B, col C

I would like to update A.b with the data from B.B for the records where A.c = B.c

Can anyone help!?

Thanks so much!
Ian

View 1 Replies View Related

Connecting To SQL 7 Through Enterprise Manager 2000

May 17, 2002

Is it possible to connect to a SQL Server 7 remotely from a SQL 2000 Enterprise Manager. I have been given the alias config from my web hosting service but no joy on the connection.

Thanks


Anthony

View 1 Replies View Related

SQL 2000 Enterprise Manager Doesn't Run

Jan 18, 2007

Hello All.

I have been using my SQL 2000 Enterprise Manager for many months but it suddenly stopped working. I have uninstalled and reinstalled the software 3 times and it is still not working. When I double click on Enterprise Manager, it doesn't run. Query Analyzer works fine.

I am on Windows XP. No change in system configuration recently or any s/w upgrade, etc.

Any advise?

Thank you.

Best regards
Teck Boon

View 2 Replies View Related

Error Opening Tables In Enterprise Manager

Jun 6, 2001

everytime i go to open tables in enterprise manager, i right click the table and then select open all of it. however, i was gone from work for a week, and when i came back i got an error message when i did this. it is as follows:

An unexpected error happened during this operation.

[Query]-Query Designer encountered a Query error:
Unspecified error.


I dont know what to do. all i can think of is rebooting the computer, but it is the LIVE databases for webpages. please help me!

View 4 Replies View Related

Using Enterprise Manager To Export Tables/data

May 19, 2006

Hi,

I'm trying to use enterprise manager (v 8.0) to generate a sql script. I know I can select the tables I want to script and then select "Generate SQL Script".

My problem is that I can't seem to figure out a way to get the INSERT statements for all the data in the tables into that same script. I can get the table CREATES, ALTERS, etc.

Is there a way to include the INSERTs for data as well???

View 5 Replies View Related

SQL Server 2000 Diagrams Without Enterprise Manager

Oct 24, 2006

Hi,I currently (for a hobby project) am unable to use SQL Server 2005, and rather am stuck with 2000. Since the way diagrams are handled changed, the tool for 2005 doesn't allow for the creation of diagrams when using it for 2000 (work sweet for everything else though!).I do not have access to a developer version of SQL Server 2000's tools, and thus no Enterprise Manager, leading me to my question: Are there any free utilities to replace this functionality? I don't have MS Access or Visio or anything like that unfortunately :(

View 3 Replies View Related

Sql Server 2000 Enterprise Manager Crashing

Nov 15, 2000

I've installed the client tools on my notebook, and EM normally works properly. However, sometimes Enterprise Manager will crash on me for no obvious reason(it generates errors, but this takes forever, so i kill it). It is not consistent, nor can I reproduce the error, but it happens about once a day, never at the same time. Anyone else see this? My pc has win2K professional on it.

View 1 Replies View Related

SqlServer 2000 Enterprise Manager - Major Bug?

Jul 20, 2005

I had a problem today where I could not see column names and alltables had a _1 after them when viewing a Sql Server view inEnterprise Managere.g.TableName Company when added to the view would be named Company_1 andthe only columns available were 1 which was *(All Columns)After looking through the news groups I saw several occurrences ofthis problem but no answers that gave a fixAfter some investigation I found that it is caused when the databasename in SqlServer has a . in it!Test1 >> Fine the view designer works fineTest1.6 >> Problems as listed aboveI don't see why Enterprise Manager allows database names with .'s ifit is going to create such problems.

View 1 Replies View Related

SQL Server 2000 Enterprise Manager Error

Nov 27, 2007



Hi Guys

wondering if you can help me.

Im having an issue with SQL Server Enterprise manager. I cannot access an MSDE DESKTOP SQL Server 2000 installation that is on the same machine as enterprise manager.

I can access the MSDE Databae from another machine fine, but when I try to register that DB locally in Enterprise manager I get this error.


PC007 - Data source name not found and no default driver specified.

I had to install sqlserver 2000 using k=dbg and skip the MDAC install as it was giving me an install error but this shouldnt have mattered as I am running XP SP2 and it has MDAC 2.8 installed by default.

Any Ideas?

View 1 Replies View Related

Registering SQL Server In SQL 2000 Enterprise Manager

May 22, 2008

When Trying to register a SQL Server using Windows Authentication, I get the following error:

Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

When I edit the properties and make it SQL Authentication, it works fine. The SQL Server Service is starting up with a domain user account. If that makes any difference. Funny thing is, that my co-worker, can register the SQL Server in his Enterprise Manager using Windows Authentication. We are both Domain Admins and members of the servers local admin group. So, I'm not sure what to do now.

I checked under Security, Logins...and neither of us are listed under there.

Thanks

View 6 Replies View Related

How Can I Reinstall The Enterprise Manager? (SQL SERVER 2000)

Mar 19, 2008

I can€™t use the DTS editor because shows an error.
So, I want to reinstall the enterprise manager without uninstall the sql server 2000, Is that possible?
If the answer is yes, How can I do that?

I think that reinstalling only the Enterprise Manager the DTS editor can be fixed.

Sql Version: Sql Server 2000
SO: Windows 2003 Server

Tanks in advance
Ariel.

View 3 Replies View Related

Enterprise Manager For 2000 No Longer Loads

Nov 8, 2007

After installing DTS designer tools for SSIS/Visual studio,
I can no longer open enterprise manager and get the following error:

mmc.exe - entry point not found

The procedure entry poinst ?ProcessExecute@@YAXPAUXHWND_@@PBG1@Z could not be located in the dynamic link library SEMSFC.dll.

View 4 Replies View Related

How Can I Reinstall The Enterprise Manager? (SQL SERVER 2000)

Mar 18, 2008


Something happened when the server fall down because of no disk space.
Now everything is fine but I have a problem in de DTS (from the Enterprise Manager) editor, I can€™t run, modify and even make a new DTS.
What can I do? Is it possible reinstall de DTS components without reinstall sqlserver 2000?

Sql Version: sqlserver2000 Enterprise
SO Version: Windows 2003 Server

Thanks in advance

Ariel.

View 4 Replies View Related

Enterprise Manager - Slow Updates When Editing Tables

Jul 20, 2005

Hi,I have a table with about 70k rows. When I use open table --> returnall rows and then edit a field Enterprise Manager then says it has toreturn the entire result set for the update to take place.This can take a long time and makes editing data a slow process. Isthere any way to get Enterprise Manager just to update the one row??Thanks Tom

View 1 Replies View Related

SQL Server 2000 Enterprise Manager Snap-in Missing

Nov 11, 2006

After running virus cleaning software on my HD, I suddenly find my Enterprise Manager snap-in missing and fail to initialize. Is the MMC erased or damaged? What should I do? Reinstall SQL Server 2000 or repair it? Please advise. Thanks.

View 3 Replies View Related

SQL 2000 Enterprise Manager 'Management' Folder Empty

Feb 25, 2006

Hi,
We patched our servers last week and now, when connecting to our server remotely via Enterprise Manager (with DBO permissions), the management folder shows as empty.  My guess is its permission related but, I'm not sure where to begin to correct the issue since we aren’t sure how it happened.  Any help will be greatly appreciated.
~des

View 1 Replies View Related

MMC Error When Staring Enterprise Manager In SQL Server 2000

Jun 21, 2001

Hello,
Yesterday I was in SQL Server 2000 Enterprise Manager and it got hung up. I couldn't get out of it without rebooting my machine. When I tried to enter Enterprise Manager again, I got an error message "MMC Cannot Open The Selected File". So I completly shut down my machine and then started it back up, but still go the same message. I stopped the services and then rebooted again,but no luck either. Today, I still cannot open Enterprise Manager. Has anyone experienced this and worked through it? I am debating as to whether or not I should uninstall SQL Server 2000 and reinstall it? Any advice?
Thanks
Heather

View 1 Replies View Related

SLOW Connection To SQL Server 2000 From Enterprise Manager

Sep 9, 2004

I have had a problem with Enterprise Manager connecting to SQL Server. At first this problem was experienced with one particular network user... whichever PC he logged onto, Enterprise Manager took ages to connect to SQL Server and every operation was painfully slow. Creating a new Windows NT logon fixed the problem.

I now have this same problem but only on my PC. It doesn't matter which Windows NT logon I use, using Enterprise Manager is painfully slow. I've tried creating a new Windows NT profile, checking the hard drive for errors, defragmenting the disk, reinstalling Enterprise Manager etc but nothing works.

What is strange is that connections from VB applications on my PC are fast. It is only Enterprise Manager that is slow.

I am using the latest service pack for SQL Server.

I thought it could be a problem with the Enterprise Manager registry values but don't want to start messing with them!

Has anyone else experienced this problem? Any advice would be great as I can't find any help from microsoft other than installing the latest service pack for SQL Server.

Thanks

View 4 Replies View Related

How To Add A Foreign Key Constraint Using The SQL Server 2000 Enterprise Manager

Jul 23, 2005

Hi,How to add a foreign key constraint using the SQL server 2000enterprise manager?Not by SQL.thanks

View 3 Replies View Related

SQLServer 2000 SP4 Enterprise Manager Crashes Immediately...

Jun 6, 2006

Hello,I need some help with SQL Server 2000 SP4. I've been using thedeveloper product for a few years now on my PC with very few problems.Today when I try to start up Enterprise Manager, it crashesimmediately. I get the usual "Please tell Microsoft about this problem"dialog and if I click the 'click here' link, I'm presented with adialog that says:-------------------------------------------------Error signatureAppName: mmc.exe AppVer: 5.1.2600.2180 ModName: mmc.exeModVer: 5.1.2600.2180 Offset:0001f07eReporting detailsThis error report includes: blah, blah, blah...-------------------------------------------------I am running Windows XP with SP2. Also installed is Visual Studio 2003,Visual Studio 2005, and SQLServer 2005 (We're in the process ofmigration).All of these products have been running OK together for at least amonth until today. I'm not sure what changed, but obviously somethinghas. I tried uninstalling and reinstalling SQLServer 2000 & it's SP4,but no luck. Enterprise Manager still crashes immediately when I try tolaunch it.Could somebody please help me out?Thanks.

View 1 Replies View Related

Cannot Access Clustered Disk Using Enterprise Manager SQL 2000

Jul 10, 2006

Hello,

I am running an SAP installation on clustered DELL poweredge 1850's with a shared scsi disk system. I am running Windows 2000 sp4 with sql 2000 sp4. I am trying to restore a database from a .bak file on a clustered disk. When I attempt to access the disk through enterprise manager it is not there. I only get access to the E: drive (which is clustered as well)

View 1 Replies View Related

Enterprise Manager (or Other Software) To Document Tables And Columns For Server2k?

Jun 13, 2006

Hi,We have enterprise manager for sql server 2000. I would like to storecomments about my database schema somewhere in the database. I want tostore information about the intent of tables and columns.We have EM but I am open to any suggestions regarding products.

View 1 Replies View Related

How To Delete/drop All The Tables From SQL Server Database Without Using Enterprise Manager?

Sep 13, 2006

How to delete/drop all the tables from SQL Server Database without using Enterprise Manager?
I tried using DROP Tables, Truncate Database, Delete and many more but it is not working. I want to delete all tables using Query Analyzer, i.e. through SQL Query.Please help me out in this concern.Nishith Shah

View 34 Replies View Related

Accessing Remote Sql Server 2000 ( Enterprise Manager Like Tool)

Jul 20, 2005

Hi all,I need to gain access to a remote SQL Server 2000 storing my data.The remote SQL machine can only be accessed via an internet connection,that is - it is not part of my network.I know Enterprise Manager can do the job, but EM only comes bundled inMS SQL Server, which is not installed on the client machine.Please let me know which other (preferably free) tools can performsuch remote access.Thanks,Gilad Haimov

View 1 Replies View Related

Dual Instances In OnSQL Server 2000 Enterprise Manager

Feb 16, 2007

I am working on a site's SQL Server 2000 database on a W2k3 machine . I went into Enterprise Manager and saw that their database resides on a named instance. I did not see the default instance listed so I registered that using windows authentication. I noticed that the default instance had a user database that had the same name as the user database on the named instance that I was to work on. I looked at the properties of the databases and saw that on both the default and named instances of SQL Server that the Data Files and Log Files for the user database point to the same location.

Is this a problem? Can anyone see any issues with this? Does this mean that someone can simply connect to the named or the default instance of the SQL Server and connect to the same database?

Kirk

View 1 Replies View Related

Using MS SQL Server 2005 Enterprise Manager With MS SQL Server 2000

Dec 5, 2006

Hi Everyone,Most of our MS SQL Servers are still running on SQL 2000, but being Iwill soon be upgrading my workstation to Vista Business I'd like toinstall MS SQL 2005 Enterprise Manager to manage them all. When Itried to install MS SQL 2000 Enterprise Manager on Vista, it gave me amessage saying it's not compatible, so I'll have to use 2005 I guess.We have LOTS of DTS scripts on our SQL 2000 server, and will 2005 EMwork with these okay? Also I want to make sure SQL 2005 EnterpriseManager won't be adding to, changing, or 'upgrading' the DTS scripts oranything on the SQL 2000 servers as we still have folks using SQL 2000Enterprise Manager.Thanks for any suggestions. I'm always leery when using cross-versionsof Microsoft applications because they are often incompatible or theydo squirly things that often break stuff.Thanks --Alex

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved