SQL7 Service Pack 2 and Stored Procedures in Enterprise Manager 
Author Message
 SQL7 Service Pack 2 and Stored Procedures in Enterprise Manager

Hi All

I applied Service pack 2 to a pair of SQL 7 Servers the other day, and
tonight I have noticed that I can no longer  edit the stored procedures in
any of the databases using Enterprise Manager.

Enterprise manager lists the procedures, but when I double click on one of
them I cant see the text to edit it. I cant even create a new procedure as
nothing appears when I type in the text.

If I use ISQL (Query Analyser) and do 'sp_helptext sp_myproc' I can see the
stored procedure.

Anyone got any idea's ?

Thanks

Paul Clarke



Thu, 05 Dec 2002 03:00:00 GMT
 SQL7 Service Pack 2 and Stored Procedures in Enterprise Manager

Just answered my own question.

The font and size being used in the stored procedure properties box had
become corrupt - it was trying to use font || and size 2332425

Scary !

Paul



Fri, 06 Dec 2002 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Errors in Service Manager and Enterprise Manager after installing Service Pack 3

2. Service Pack after upgrading from SQL7 Standard to Enterprise Edition

3. Enterprise Manager/Service Pack 2

4. after service Pack 2, Enterprise manager text is in tiny type

5. SQL Enterprise Manager do not open after applying NT 3.51 Service Pack 5

6. after service Pack 2, Enterprise manager text is in tiny type

7. Update Enterprise Manager to Service Pack 3

8. Service Pack 1 Driver: buggy with Stored procedures?

9. Enterprise Manager, Query Analyser, Service Manager etc will not launch

10. Service Manager & Enterprise Manager Problems

11. Can't Execute Stored Procedure outside of SQL Enterprise Manager/isql

12. Stored Procedure Behave Differently using SQL 2000 Enterprise Manager


 
Powered by phpBB® Forum Software