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 |
|
jones_d
Yak Posting Veteran
61 Posts |
 Posted - 2004-10-07 : 14:13:20
|
| Hi,I have 2 stored procedures on SQL Server 7. The first one creates a table called ft_bse_client. In the second stored procedure an index is created on the table ft_bse_client. Both of these stored procedures are called from a VB application. When I run the application the ft_bse_client table is created. However, the second stored procedure fails. I am getting the following error:ERROR: Module: RunStoreProcedures S0002: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot create an index on 'ft_bse_client', because this table does not exist in database 'clientfig'.When I run the line of code to create the index in Query Analyser it runs fine. Also when I run the stored procedure from query analyser it also runs fine. It's just when the second stored procedure is called it is failing.B.T.W - The table is created properly in the 1st SP.Any ideas or suggestions appreciated.Many Thanks |
|
|
surefooted
Posting Yak Master
188 Posts |
Posted - 2004-10-07 : 14:51:13
|
| Try running a trace in profiler so you can watch the application to make sure it is running the procs in the correct order.-JonNow a "Yak Posting Veteran". |
 |
|
|
jones_d
Yak Posting Veteran
61 Posts |
Posted - 2004-10-07 : 14:54:25
|
| We are logging each step to an application log and the stored procedures are running in the correct order.The create time on the table is well before the time the error occurs (i.e. that it tries to create the index on the table.) |
|
|
|
|
|
|
Cannot create index - table does not exist???