Meg
Some things to check: Do you have more than one E.M. open on your desktop?
Is anyone else in your office looking at the same E.M. data? I still find
this app buggy, especially when granting ojects rights, etc. When stuff like
this happens to me I try the sp_ equivilents to sort it out. Hope this
helps.
Ken
-----Original Message-----
From: Meg Hardy [mailto:[Email Address Removed] Friday, October 18, 2002 7:24 AM
To: LazyDBA.com Discussion
Subject: OBJECT PROBLEM
Hi all,
I have a problem with a stored procedure. when i do sp_help on it I get
this error -
Server: Msg 15009, Level 16, State 1, Procedure sp_help, Line 70
The object 'usp_delete_from_trigger_table' does not exist in database
'marque'.
then I did select from sysobjects where name = 'etc...' and it does exist in
this table. It appears on Ent Manager but I am trying to give permissions
for a user to execute it and everytime I tick the checkbox, I go back in and
it is blank again.
Any ideas????
Baffled!! Meg
**********************************************************************
DISCLAIMER
Any opinions expressed in this email are those of the individual and not
necessarily of Mondial Assistance (UK) Ltd. This email and any files
transmitted with it, including replies and forwarded copies (which may
contain alterations) subsequently transmitted from the Company, are
confidential and solely for the use of the intended recipient. If you are
not the intended recipient or the person responsible for delivering to the
intended recipient, be advised that you have received this email in error
and that any use is strictly prohibited.
If you have received this email in error please notify the IT support desk
by telephone on +44 (0)208 2393984 or via email to
[Email Address Removed] including a copy of this message. Please
then delete this email and destroy any copies of it. Thank you.
Mondial Assistance (UK) Ltd
Mondial House
102 George Street
Croydon
CR9 1AJ
Mondial Assistance (UK) Ltd Registered in England No.1710361 Registered
office as above
**********************************************************************
________________________________________________________________________
This email has been scanned for all viruses by the MessageLabs SkyScan
service. For more information on a proactive anti-virus service working
around the clock, around the globe, visit http://www.messagelabs.com
________________________________________________________________________
MS Sql Server LazyDBA home page