I have a VB project that conects to an SQL Server database. I just builded 2 new stored procedures and than I sent the project for testing. After some time the database generates an error an all, I repeat, ALL stored procedures and views dissapear. Anyone know what this problem can be?

Thanks


Lucian Preda
[email protected]

__________________
Lucian Preda
[email protected]

Hi,

Could it be that you are running a drop statement (thru VB code or thru Trigger). Plz verify your DB connection string.
Also plz send the DB error message you are getting.

regds,
Babloo

Hi,

I am not running any drop statements(neither thru vb code or thru triggers).

My error dll returns this:

The code asociated with this error is -2147217900
The standard VB error text for this error is 'Could not find stored procedure 'spUnionFromProductStructure'.'.

Wich means that somehow the stored procedure dissapeared.
When I checked the database I realized that ALL stored procedures and views were missing. Strange


Lucian Preda
[email protected]