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 |
|
jesus4u
Posting Yak Master
204 Posts |
 Posted - 2002-08-22 : 14:46:02
|
| New to triggers but is there a way to have SQL 2000 query a table behind the scenes in a stored procedure while other code in a VB app is running? Kind of like an 'Out of Process EXE' would do?Thanks |
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2002-08-22 : 15:32:15
|
| I think what you're asking is: is there a way to asynchronously call a stored procedure? There is, and it has nothing to do with SQL Server - it's entirely dependent on the capabilities of the caller. With VB5/6, your choices are limited to creating a multithreaded ActiveX EXE. With .NET your multithreading and synchronization options are more expansive.Jonathan Boott, MCDBA{0} |
 |
|
|
jesus4u
Posting Yak Master
204 Posts |
Posted - 2002-08-22 : 15:34:18
|
quote:
I think what you're asking is: is there a way to asynchronously call a stored procedure? There is, and it has nothing to do with SQL Server - it's entirely dependent on the capabilities of the caller. With VB5/6, your choices are limited to creating a multithreaded ActiveX EXE. With .NET your multithreading and synchronization options are more expansive.Jonathan Boott, MCDBA{0}
no what I want is a stored procedure to run automatically without being called |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2002-08-22 : 16:05:39
|
| How about a JOB that calls a stored proc. That would allow your stored proc to run at schedule intervals, totally independant of the client application.Is that what you are looking for?Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
jesus4u
Posting Yak Master
204 Posts |
Posted - 2002-08-22 : 16:22:06
|
quote:
How about a JOB that calls a stored proc. That would allow your stored proc to run at schedule intervals, totally independant of the client application.Is that what you are looking for?Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda>
Yes! But what JOB? A VB APP or something? |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-08-22 : 16:46:51
|
quote:
Yes! But what JOB? A VB APP or something?
Nope... he means a SQL Job. Running under the SQL Agent. Look up Jobs in BOL, or browse in EM to Mangement, SQL Agent, Jobs. |
|
|
|
|
|
|
Auto Triggering