Error On SQL Enterprise Manager Display
Jul 20, 2005
SQL Enterprise Manager Version 7.0, Windows XP professional version 5.1
The list panels (right half of the screen) will not show the tables.
The top of the panel reads: 245 items, which is correct, but the panel
reads: there are no items to show in this view. This error is occurring
on one database on one server. The tables are actually there but I
cannot access them through Enterprise Manager.
I assume that a re-install will probably fix it, but I'm hoping
to avoid it.
Help
--
Posted via http://dbforums.com
View 1 Replies
ADVERTISEMENT
Sep 11, 2000
I am running SQL Server 7, sp2, on my desktop as a client. I have IE 5 installed. My OS is NT, sp4.
Two problems:
1. When I click on Metadata I get the following Internet Explorer Script error:
An error has occurred in the script on this page
Line: 410
Char: 2
Error: Object Expected
Code: 0
URL: res://C:MSSQL7BinnResources1033
sqlmmc.rll/repos.htm
Do you want to continue running scripts on this page?
Regardless of my answer, I just get a blank display.
2. Whenever I single click on a database name, instead of getting the graphical display information, I get the following Internet Explorer Script error:
An error has occurred in the script on this page
Line: 361
Char: 3
Error: Object Expected
Code: 0
URL: file://C:MSSQL7HTMLdatabase.htm?
SQLNSCookie=01D223E80000000100000001
Do you want to continue running scripts on this page?
Again, regardless of my answer I get a blank display.
HELP!!!!
View 2 Replies
View Related
Jan 5, 2000
When I click on the 'Create Date' column in Stored Procedures to sort the SPs by date, the SPs do get rearranged but not in the expected order. Is there something I am doing wrong or is this a feature? I am running MSSQL 7.0 on NT4.0 SP5.
Thanks in advance,
Nishi
View 1 Replies
View Related
Jul 23, 2005
I have a new installation of SQL Server 2000 Dev Edition on a Win2K3 Standard Edition Server that I used for development. I just set this machine up in th last week and installed all Win2K3 patches and then installed SQL2K and SP3a. I have a single named instance. I just noticed today that I cannot view table data or use the Query part of EM. When I right click a table and select Open Table->Return All Rows it gives me an error dialog "An unexpected error happened during this operation". While the EM is diplaying this dialog the EM screen looks like Internet Explorer and says "Action Canceled - You might not have permission to view this directory or page using the credentials you supplied." I believe that this is a EM issue as I cannot view table content on other remote server. ANy ideas? Might this be an IE security patch disallowing some connectivity ?--Frank--Message posted via http://www.sqlmonster.com
View 1 Replies
View Related
Feb 10, 2004
Hi All,
Sqlserver 7.
From the Enterprise Manager when i right click on a table and select
Return all row. I am getting the below error
An unexpected error happened during this operation.
[Query]- Query Designer encountered a Query error: Unspecified error
When i use Query Analyser i am able to retrive the Data
Pls help Its Urgent
TIA
Adil
View 2 Replies
View Related
Jul 13, 1998
When I try to schedule a dump of a database, I receive the following error message "Error 2812: Stored Procedure `master.dbo.sp_schedulersignal` not found. I looked in the msdb databases and this stored procedure was not listed. I recently had to reinstall SQL server due to problems with IP sockets. How do I go about correcting this problem? Do I need to somehow reinstall this Stored Procedure? Any help will be greatly appreciated.
Thanks
View 2 Replies
View Related
Mar 15, 2004
Not sure what has caused this to suddenly happen, but each time I attempt to launch Enterprise Manager I get the error:
"MMC cannot open the file C:MSSQLBINNSQL Server Enterprises Manager.MSC
This may be because the file does not exist, is not an MMC console, or was created by a later version of MMC. This may also be because you do not have sufficient access rights to the file."
Now, I've already attempted to reinstall the client tools with no luck. The file does exist, and I have not changed my security settings -- at least that I'm aware of.
I use EM daily, so I'm perplexed as to why over night it stopped working. Is it possible a Windows Update could have caused this?
If you have any insight I'd appreciate it. Thanks.
PS. I'm using SQL 7.0 on a WinXP Pro laptop.
David
View 1 Replies
View Related
Feb 14, 2007
Hi Frndz,
I am using SQL Server 7.0, I will regularly take backup daily using sql
server enterprise manager. During backup running, i had cancelled
abnormally, when next time i take backup it shows the following error "Microsoft SQL-DMO(ODBC SQLState:42000)" "Backup,
CHECKALLOC, bulk copy, SELECT INTO, and file manipulation (such as
CREATE FILE) operations on A database must be serialized. Reissue the
statement after the current backup. CHECKALLOC or file manipulation
operation is completed.Backup or restore operation terminating abnormally"How to solve this problem? send reply in detail.With Regards,Arul
View 1 Replies
View Related
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
Jun 13, 2001
When I try open a table in Enterprise Manager, I am getting the following error:
The instruction at "0x418561c4" referenced memory at "0x00000034". The memory could not be "read".
Any ideas what this is?
Paul
View 1 Replies
View Related
Oct 5, 2001
Hhmm! Trying to create a trigger on a table called ACCOUNT owned by SYSDBA. SQL 7 on NT 4. Authentication is on NT logon ID.
Create Trigger [SGIACCTINS] on [ACCOUNT] for insert as
insert into SGI_ACCT_DB (accountid,account) select accountid,'I' from inserted
The error message, this is in SQL Manager, is
Microsoft SQL-DMO (ODBC SQLState: 42S02)
Error 208: Invalid Object Name 'ACCOUNT'
Any clues?????
View 1 Replies
View Related
Jan 15, 2001
Lately I noticed that I cannot return any rows using enterprise manager. The version I am using is MS-SQL 7.0 with SP 1 on NT. This will return an error:-
An unexpected error happened during this operatation.
[Query]-Query Designer encountered a query error.
Unspecified error.
I can return rows using another computer with enterprise manager installed.
Any help appreciated.
Tony
View 2 Replies
View Related
Feb 26, 2008
Hi
I am getting an error when i try to open MSEM. I have also tried to open this via mmc and get the same.
I have an attached a screen shot of the error. I tried re-installing SP4, but this did not fix it. Please help. We need to move our SQL to a new server and since I can't see any of it, I can't really manage it before the move.
I would appreciate any help.
Thanks
Jimmy
View 10 Replies
View Related
Jul 20, 2005
.... DTSRun: Executing... DTSRun OnStart:DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart:DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart:DTSStep_DTSExecuteSQLTask_4 DTSRun OnStart:DTSStep_DTSDataPumpTask_2 DTSRun OnError:DTSStep_DTSDataPumpTask_2, Error = -2147467259 (80004005) Errorstring: [Microsoft][ODBC Visual FoxPro Driver]Cannot open filee:private.dbc. Error source: Microsoft OLE DB Provider for ODBCDrivers Help file: Help context: 0 Error DetailRecords: Error: -2147467259 (80004005); Provider Error: 171(AB) Error string: [Microsoft][ODBC Visual FoxPro Driver]Cannotopen file e:private.dbc. Error source: Microsoft OLE DBProvider for ODBC Drivers Help file: Help context: 0DTSRun OnFinish: DTSStep_DTSDataPumpTask_2 DTSRun OnStart:DTSStep_DTSExecuteSQLTask_6 DTSRun OnFinish:DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart:DTSStep_DTSDataPumpTask_3 DTSRun OnError: DTS... Process Exit Code4. The step failed.anyone know becaouse if i execute this job whit the Schedule packagedont work but i execute manually it's work ?pls help me ...
View 2 Replies
View Related
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
Sep 12, 2001
Receiving error "Microsoft ODBC Server Driver Timeout Expired".
This is happening when running queries or stored procedures through VB6 and also in Enterprise Manager.
Have set query timeout to 0 and command timeout to 0 but no joy.
Enterprise manager cannot even perform a count of records (16Million) without timeing out.
Can anyone help...at end of tether!
Cheers,
Brookesy
View 1 Replies
View Related
Sep 21, 2000
Greetings:
We have a database with approximately 15-20 tables. Last week, using Enterprise Manager, we were able to open any of these tables and return all rows. Yesterday, when we tried to do this, we got the following message:
An Unexpected Error happened during this operation.
[Query] - Query Designer encountered a Query Error: Unspecified Error
Can anyone tell me what might be causing this and how to fix it? Barring that, can anyone suggest some general steps I might take to possibly eliminate this problem without knowing the cause? Last, can you point me to a good resource for investigating problems of this kind, such as a knowledge base (other than Microsoft's TechNet)?
Many, many thanks.
View 1 Replies
View Related
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
Nov 7, 2007
Hi,
I am getting following error message while opening DTS package,
"No provider exist fro this connection on this computer", Invalid class string.
When I use the SQL Enterprise Manager (SEM) Return All Rows option to open a table, or you attempt to create or design a view, the following error occurs:
An unexpected error happened during this operation.
[Query] - Query Designer encountered a query error : unspecified error
This is working fine from remote enterprise manager.
Recently I have migrated all the databases including system databases from old server to new server.
I reinstalled latest MDAC to correct this problem, but I did not get any solution for this.
I have installed SQL Server service pack 4, do I need a SP4 re-install and how I can do this.
View 1 Replies
View Related
Sep 12, 2007
Hello I am receiving the dreaded mail error listed above. I can send out a test E-mail from Enterprise Manager to operators, but I cannot run this Transact query:
EXEC master.dbo.xp_sendmail @RECIPIENTS = araz***@***.com(removed email address),
@SUBJECT = 'test'
I receive:
Server: Msg 18025, Level 16, State 1, Line 0
xp_sendmail: failed with mail error 0x80040111
I have stopped/restarted the SQL SERVER AGENT but haven't done much else as I haven't been able to.
Should it work through transact SQL if the test email works from Enterprise Manager?
This is SQL 2000 SP4 running on Win2K in the domain. Thank you.
View 8 Replies
View Related
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
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
Jan 7, 2002
I am trying to run queries against any of the user tables in my MS SQL 7.0 database. I get a message the Query Designer encountered a query error.
We have tried rebooting the SQL Server and I am still getting these messages. Also, the SQL error logs look fine - all database
maintenance are running successfully including the DBCCs which show no errors. Any help would be greatly appreciated as we are to go
into production in a few days.
View 2 Replies
View Related
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
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
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
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
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
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
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
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
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
Apr 17, 2000
Is non-SA account able to view the SQL Enterprise Manager?
Thanks in advance!
Plum
View 3 Replies
View Related