Locked Out Of Enterprise Manager "Current Activity"

Mar 5, 2001

Hi,

In SQL Server 7.0 Enterprise Manager | node-name | Management | Current Activity, if I try to refresh the current activity or view the current activity data, I get a hourglass for several minutes, then an error message box that says:

Error 3621: Lock request time out period exceeded. The statement has been terminated.
The statement has been terminated. [OK].

I need to see the current activity to check on blocking, etc.

Help!, please.

Boog

View 3 Replies


ADVERTISEMENT

SQL Enterprise Manager - Current Activity...

Jul 17, 2007

If you're passing a query from outside of SQL Server into one of your databases - is it possible to monitor the Query being processed?



I have a third party program that queries one of my databases.



Curreny activity within Enterprise manager seems to be the only thing relating to my problem.



Thanks,

i

View 1 Replies View Related

Locked Out Of Enterprise Manager

Apr 16, 1999

I am a beginner working on a webclass project using VBLive as a model. Today I have lost any ability to enter Enterprise Manager for SQL7 although my SQL7 Server is still running and operational with the webclass application.

When I try to start the enterprise manager, i get a mmc.exe-application error
Have I locked myself out somehow? How to get back in control?

Thanks.

View 2 Replies View Related

Locked Out Of Enterprise Manager

Mar 7, 2007

Hi all

First post - please be gentle :)

I have had a search of the forum and couldn't find a solution to this one.

On a clean install of SQL Server 2000 on a W2003 server we setup our database as normal, selected appropriate priveldges for everyone and all was well.

Until an adminsitraor accidently turned builtinadministors account to DENY access. We are now locked out of EM and I can't think of a way back in.

We can't access the database via the sa account as it is set to Windows Autentication, and we can't re-register the database for the same reason.

No other user has sufficent priveldges to update the master db or change authenticaion, or even log into EM for that matter.

I think we are snookered, but any thoughts are welcomed.

Cheers

K2

View 3 Replies View Related

Process Info (SQL Server Enterprise - Management - Current Activity)

Jul 23, 2005

Dear AllI have problem with my database server which running SQL server 2000.The server running very slow. The worst case, to save a record requiredmore than 20-30 seconds.Since this problem, I usually monitoring Process Info from EnterpriseManager (Management - Current Activity), and I found a misteriousprocess as follow :1. User: SystemAccessTo: MasterStatus: BackgroundCommon: Task ManagerWaiting: >438 Million2. User: SystemAccessTo: MasterStatus: BackgroundCommon: Task ManagerPhysical IO: > 510003. User: Administrator (Join domain)Database: MSDBStatus: SleepingCommon: Awaiting CommandApp: SQL Agent Alert EngineCPU Usage: > 16 MillionAnybody know about these condition? Does it normal?ThanksMichael

View 3 Replies View Related

High Value In The CPU Column (Enterprise Manager SP Activity)

Mar 22, 2002

Hi,

I could see number process is having high value in the CPU colun of the Enterprise Manager Sp Activity.

Even I took some of the process SQL and did an explain and found to be fine.

Could you tell me why it is having high CPU value and what is its effect in system performance.

Thanks
John Jayaseelan

View 4 Replies View Related

Current Activity

Apr 17, 2000

I have registered a server on to my client machine successfully,but I am not finding the current activity item in the management folder on EM.How do I see the current activity on the server.Do I need to be SA for that server?My machine has NT workstation with SQL server 7.0 on it.Any one to help?

View 1 Replies View Related

Current Activity Not Available? 6.5

Aug 12, 1999

When viewing Current Activity, nothing shows up.

If i run sp_who, the return is normal.

If I run sp_who2, the following message is returned. (it also is returned randomly while using function in EM such as Backup/Restore.)

Msg 268, Level 16, State 1
You cannot run SELECT INTO in this database. The DBO would have to run sp_dboption to enable this option.


What is it??? It's buggin me......

Dano

p.s. I remember a similar problem in the past, it had to do with turning truncate on checkpoint in one of the system databases msdb/master/tempdb or something like that. I turned off all Trunc. and Select/Bulk options on these...

View 2 Replies View Related

Cannot View Current Activity In EM

Nov 20, 2002

Trying to view current activity in EM however get error 1222 Lock request time out period exceeded, this also occurs when trying to view tempdb database.

Is this a EM Gui error or locking issue and hwo do you resolve?

Thanks

GaryW

View 5 Replies View Related

Current Activity Window

Sep 24, 1999

Hi,

On sql server 6.5 running on a win/nt platform my Current Activity window comes up blank when I click on it. Everything else seems to be working fine. This is a new problem, it just stopped reporting any info when I click on it.
Any suggestions would be greatly appreciated.

Thanks,

Jerry

View 2 Replies View Related

Current Activity Tool

Nov 3, 1998

Hi there!
in the ms-enterprise manager , the current activity.. under server menu
does not display anything in one of the server in EM but in other
servers it is okay.

any inputs?

thanks.

joe

View 3 Replies View Related

Current Activity = 0 And Still Sql Server Use All CPU And Memory ?

Mar 28, 2001

What to check on NT or Sql server it self
if
1. NT performance shows that sql serve.exe -CPU 93% memory 49000
2. Sql server current activity only sa connected to master.
Thanks

View 2 Replies View Related

Current Activity - Process Info

Jan 12, 2007

Hi, please i need to know where sql save (table) the info that i see in Managment/Current Activity - Process Info
thanks so much

View 4 Replies View Related

Duplicate MAC In Current Activity -> Process Info

Jun 15, 2001

Just recently I noticed something that I consider very strange on a SQL7.0 server with SP1.

In [Server -> Management -> Current Activity -> Process Info] I see a great number of rows(connections) around 70 or so that all have the same net_address value. However, the nt_loginame is different on each.

Q1: How can this be?
Q2: Isn't the net_address really the MAC of the network card?

Also, on a test SQL7.0 server with SP1 where the connections are far less (around 15 or so), I noticed the same problem. Luckily, because the connection count is low I was able to go around to each machine where the nt_loginame was used to log on and found that the net_address shown in [Current Acivity] didn't match any of these machines. Why?

-John

View 1 Replies View Related

Managment/ Current Activity / Process Info

Jan 12, 2007

Hi, I need to know where SQL save the info that I see in the Managment/ Current Activity / Process Info

thanks so much

View 2 Replies View Related

Problems Running Enterprise Manager And Service Manager

Jul 20, 2005

On one of our machines, all of the SQL Server 2000components except for the main Server component (SQL Servercore) itself were installed (Management tools, etc) a while agoand everything was running fine. Now I go and add/install theServer component and then Service Pack 3a.It seems that Service Manager won't start up (I get an hourglass cursor)and now I find that Enterprise Manager won't run as well. No errormessages appeared and I don't think I saw anything unusual inthe log file.However, I can use Enterprise Manager on a differentmachine and connect to the database (so the databaseitself seems to be running).Any suggestions as to what the problem might be and how tofix it? I like to see if I can repair this without havingto do a reinstall.Thanks.PF

View 2 Replies View Related

Help! Enterprise Manager Turns SQL Server Service Manager Off

Dec 6, 2006

IF someone can assist me. Everytime I load up enterprise manager the service manager turns off. And the enterprise manager can't connect to the local database. But everytime i turn it back on and try to connect again it shuts it off and around and around we go. Help would be appreciated. Thanks.

View 2 Replies View Related

Text Manager Can Not Conitinue With Current Statement

Jul 20, 2005

I received this error message in the application event logs. Can anyone tell me what this is pertaining to?Error: 7102, Severity: 20, State: 99SQL Server Internal Error. Text manager cannot continue with currentstatement.Thanks Barb

View 2 Replies View Related

Asp.net Enterprise Manager

Nov 30, 2006

Hi
has anyone used this tool to upload sql databases to a web host
i'm struggling
cheers!!!
Adrian
 

View 2 Replies View Related

Where Is Enterprise Manager?

Sep 10, 2005

I installed SQL Server MSDE 2000 but I can't find how to start it. Does this package include an Enterprise Manager or not? I thought that maybe it was a standard XP Pro feature. I had no problem finding it in W2000 Pro.

View 1 Replies View Related

Enterprise Manager

Mar 21, 2001

When I open databases, there is nothing there - not even Master, Model, Temp, Pubs, etc.

When I open the query analyzer, however, they all appear in the drop down.

What is up with that? and how can I remedy?

OP sys:Win98
SQL Server 7

View 2 Replies View Related

Enterprise Manager

Jun 11, 2001

Has anyone encountered this error: When you are in Enterprise manager and you select a database then the tables tab and then you select a table and go to open table- select all rows, I get an error--An unexpected error happened during this operation-Query Designer encountered a query error! Please let me know if you have seen this. Also, when I access this from one networked computer I get the same error, then when I access it from another I do not!! The servers are interacting with Pivotal. The one that works does not!!

View 3 Replies View Related

Enterprise Manager

Jun 12, 2001

Hi all,
I have SQL 7.0 desktop addition installed on my local win NT workstation. I am able to connect to my local server using Quary Analyser but when i am trying to connect using EM, i am not able to connect. I am receiveing the following error message.
__________________________________________________ ___________________________
A conncetion could not be established to "servername" - Specified SQL Server not found. ConnectionOpen(CreateFile()).
Please verify SQL server is running and check your SQL Server registration properties(by right clicking "servername" node) and try again.
__________________________________________________ ___________________________
I have tried as said in the error message and also tried connecting with "sa" but its not working. I can see that the server is running and i am able to connect through QA.

any help is highly appriciated.

View 1 Replies View Related

Enterprise Manager

Jun 20, 2001

We can no longer open tables in EM. The error message is;

An unexpected error happened during this operation
[Query] - Query Designer encountered a Query error:
Unspecified error

The tables are fine - can access them other ways.It looks as if the fault is in the script used by EM. Anyway to clear this ??

View 2 Replies View Related

Enterprise Manager

Sep 26, 2001

I am fairly new sql dba in a company and I am sure Enterprise Manager is installed on PC's and it shouldn't. Is there a way of finding out other then visiting each workstation. Thanks in advance..

View 1 Replies View Related

SQL 7 Enterprise Manager

Jul 28, 2000

I am considering upsizing my Access 2000 DB to a SQL 7 server. I was told that having SQL 7 Enterprise Manager is highly prefferd but not essential as I can maintain the upsized DB with Access 2000. The only way that I have been able to find JUST enterprise manager seems to be with purchasing the whole SQL 7 program for $1300! Microsoft cannot be that cruel, that you have to buy the whole program just for Enterprise Manager!

My questions are:

Can I download just MS SQL 7 Enterprise Manager anywhere for a reasonable fee or free?

and

if not, can I continue to use Access 2000 to maintain the SQL 7 upsized DB?

View 5 Replies View Related

SQL Enterprise Manager

Jan 25, 2001

I have access to a SQL 7 server via my ISP Hosting account. I know Enterprise manager comes with the server software, but how can I get a copy of JUST Enterprise Manager?

JD

View 1 Replies View Related

SQL Enterprise Manager

Apr 17, 2000

Is non-SA account able to view the SQL Enterprise Manager?

Thanks in advance!
Plum

View 3 Replies View Related

SQL Enterprise Manager

Aug 3, 1998

Is it possible to administer both 6.5 and 7.0 databases from the same SQL Enterprise Manager? I have read that you cannot do this because the 7.0 "plug-in" to the MMC wont work with 6.5 databases.

View 2 Replies View Related

Enterprise Manager

Nov 8, 2001

We had database corruption and cannot access the Enterprise Manager. DBCC returned errors 9000 to 9999 which I can't get any suggestions on how to handle from BOL. Any ideas!!!!! Thanks.

View 4 Replies View Related

Enterprise Manager

Mar 13, 2001

Hi,
I would like to know if we can present users to access details database information about the databases on a server through Enterprise Manager.
If you create a SQL login and do NOT give it access to any database, if someone logons on your server with enterprise manager, even though he does not have access to any database, he will still see the list of all database on your servers plus tons of sensitive information like database owner.
Is is possible to limit enterprise manager to only view information about database that the user has access to?

Thanks
Mark

View 2 Replies View Related

Enterprise Manager 6.5

Nov 26, 1999

How can I force users of Ent Manager 6.5 to enter a name/password when connecting to a server that has been registered? I dont want to use the sa name and password so that anyone could use my workstation to access our servers.

View 2 Replies View Related

SQL Enterprise Manager

Oct 10, 2003

Does anyone know how to turn off or disable the auto discovery for Enterprise Manager. Apparently our Network group is complaining that Enterprise Manager is generating noise on the network, it is not signifcant in volume but they complain it impacts there ability to detect hacking attempts on our network because it causes some false positives. I generally keep Enterprise Manager running because I will always have some manual job running from it and we have so many servers it takes awhile for them to all load when I first fire it up.

Thomas

View 3 Replies View Related







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