|
|
Posted by Erland Sommarskog on 06/08/05 01:56
Boris (supermanreloaded@gmail.com) writes:
> 1 and 2 are not true, however, I am creating and dropping table
> dynamically.
So this where you would concentrate on changing things. I would
never permit tables being created dynamically in databases I am
responsible for.
If all you want to do is to clear out the table, just use TRUNCATE
TABLE instead.
But what happens if two instances of that ASP page runs at the same
time.
> Since I can not turn off that warning message, I guess I need to do the
> error handling, or warning handling in my ASP code. I just need to know
> how. If you know how can I do that, please let me know. Any help would
> be really appreciated.
You are likely to know more ASP than I do, because I know nothing about
ASP. (It's a tree, isn't it? :-)
But assuming that you use ADO as the client library, you can check
the Errors collection for errors. The Error object has a .Number
property, and this is the error number from SQL Server. Which number
you should check for, I don't know, but that's very easy to find
out.
If you have more detailed questions about ASP programming, you are
definitely better of in an ASP forum.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
Navigation:
[Reply to this message]
|