Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
massif
Starting Member
1 Post |
 Posted - 2006-11-02 : 10:57:07
|
HEllo,after restoring a db, I can't execute stored procedures or update tables correctly.I have these kind of messages :quote:
Server: Msg 3705, Level 16, State 1, Line 1949556518Cannot use DROP TABLE with 'SALESFORCE..maj_strat_lite' because 'SALESFORCE..maj_strat_lite' is a procedure. Use DROP PROCEDURE.Server: Msg 2714, Level 16, State 6, Procedure maj_strat_lite, Line 3There is already an object named 'maj_strat_lite' in the database.
Orquote:
Server: Msg 2812, Level 16, State 62, Line 1Could not find stored procedure 'changement_compagnie'.
I think that it is linked to logging problems.Indeed many of the objects are owned by user BATCHEUR.But when I restore the db, I think that the objects are not corectly linked to the user BATCHEUR.How to recreate all the links (maybe in sysobjects table ?) ? because I've deleted the user BATCHEUR and recreate it and I think that I've made a big mess !!!! |
|
|
Kristen
Test
22859 Posts |
|
|
|
|
|
|
|
[MSSQL7]Problem after restoring a db