Hi All, I'm trying to register an externally hosted SQL 2000 server through Enterprise Manager which isn't on the default port and I can't see anywhere to change it within Enterprise Manager. So, the question is, how do I connect to the database if: I.P Address is 123.456.789 (example) Port is 1334 Thanks in advance EDIT: Both Rob...
I'm using a medical records system built on an Oracle database. Our vendor just told us that we need to shut down Oracle's Enterprise Manager service when we're not using it, because it uses too much of the system's resources. I know I can get actual numbers by checking Sysinternals Process Explorer, but I was hoping that someone can giv...
In Enterprise Manager you could script all SPs in a database through the right click menu, is there a way to do it in Management Studio? ...
In an interview for a SQL DBA position a while back, I mentioned I prefer the SQL 2005 Management Studio app vs. the old 2000 versions of Enterprise Manager / Query Analyzer. The DBA who was interviewing me said that they had experienced some sort of database corruption in their 2000 databases when making changes from the 2005 MS, so the...
I am running a windows xp sp3 machine with 22gb free space, 1.5ghz Intel Pentium M and 768MB of RAM. Every time i try to install oracle 11g, the installation goes okay except for running the emca script. Enterprise manager failed due to the following error- error starting database control caused by OracleDBConsoleorcl not being...
We are having issues with our sql server. About two times a day we have to restart our server because SQL becomes unresponsive to our web applications. It doesn't look like we have a problem with to many connections, as there are never more then 20 active at a time. The weird thing is I can access sql from MS SQL Enterprise Manager 8.0 ...
This is one of those "I probably should know this, but I don't" questions. How do I make a copy of a table in Enterprise Manager? Not export the data into a different database, just make a copy of the table within the same database. At this point, I don't care whether the data comes with or not, but the table definition should definitely...
I have a simple table for a gallery. There are many galleries, each containing images - which may belong to multiple galleries. Basically this is a 'cross table' with a sort order within that gallery. CREATE TABLE [dbo].[GalleryXGalleryImage]( [GalleryId] [int] NOT NULL, [GalleryImageId] [int] NOT NULL, [SortOrder] [int] NO...
Our Oracle Enterprise Manager Grid Control 10.2.0.5 website has no favicon. I don't know if this is normal or not. If it is not normal I'll contact support, but if it is normal I'd like to know if there is a way to add one. I would guess if I knew where the root of the website was I could put a favicon.ico file there, but I'm not sure...
I'm currently using MSSQL Server 2000 and to design tables, create and alter stored procedures as well as manage users and permissions I'm using Query Analyzer and Enterprise Manager. I also spend an awful lot of time in Visual Studio 2008 and rather jump out to other applications I was wondering if Visual Studio could help me do at leas...
Given I have the following view where N=1..100 detail_view_N Pant Quantity Fieldx ... A 20 A 13 B 4 Currently we have summary views which insert to a table like summary_view_N Report_Name Plant Count summary_view_1 A 2 summary_view_1 B 1 The table is then used to create an overall summary l...
Somebody can advise an equivalent for Enterprise Management Console? I found this Oracle Enterprise Manager 10g Grid Control Management Agent. But i cant launch it. There is two jar file. I try to run it, but it doesn't work. dhcp-176:~ kukodajanos$ java -jar /Users/kukodajanos/Downloads/macosx_10_1_0_3_agent_download/macosx/agent/stag...
I would like to use SQL Enterprise Manager to manage my SQL Azure Databases. Everywhere I look everyone says that if you want to use the object browser then you need R2. However I can not find Enterprise Manager R2 anywhere. Not unless I install DataCenter R2. Where can I find Just Enterprise Manager R2? ...
After creating a db using Database Configuration Assistant, I go to Enterprise Manager, log into it, and it tells me, that java.lang.Exception: Exception in sending Request :: null. OracleDBConsole for this db, and iSQLPlus services are started. When I run %ORACLE_HOME%\bin\emctl status dbconsole, it says, EM Daemon is not running. How d...
When I attempt to connect to SQL server using enterprise manager I get the strange message: "SQL Server is not known to be running. Are you sure you want to connect?" What is it trying to tell me? Is there some special caution required in trying to connect to a server that is not known to be running? If so, how do I find out if a serv...
I understand that Oracle will at some point add support for MySQL to its Enterprise Manager software. However I'd like to know perhaps from other Oracle to MySQL migrants what tools are available for monitoring the queries, activity and resource usage happening on a MySQL database instance. ...
Is it possible to write a plugin or a form for SQL Server Enterprise Manager version 8? I'm doing some simple queries all the time to admin the databases. So wondering if I could write something for it. ...
I need to complete some tasks in EM. But I don't have access to web interface and ssh. Is there other way to configure EM? I think EM should have pl/sql API, but I didn't find any information about it. Only idea that came to my head it's to implement java stored procedure that interact with CLI. But maybe less complex solution exists? ...
Is there a way in SQL Server Management Studio to use modal dialogs to view or edit a View, Stored Procedure or User Defined Function? As it is now anytime you want to see/modify their declaration, it has to be scripted as ALTER VIEW ALTER PROCEDURE ALTER FUNCTION and it is placed on a new dummy tab. i prefer the old fashioned OK C...
The Problem i'm trying to import data into a table using SQL Server Management Studio's Import Data task. It only brings in 26 rows, out of the original 49,325. (Edit: That's where 99.9% comes from: (1-26/49325)*100 = 99.9% Using DTS in Enterprise Manager correctly brings all 49,325 rows. Why is SSMS not importing all rows, reporting ...