"Dan" <d@er.df> wrote in message
news:O2G9R1NwHHA.4528@TK2MSFTNGP03.phx.gbl...
> Hello,
>
> we have an intranet application using Windows Integrated Authentification.
> When an user starts the application, he gets a form for inputting data.
> The first time he does that, the application creates in a specific
> database a table with the name of his account (read with
> Request.ServerVariables("remote_user") and creates in that table the
> records he enters. From the second time the user starts the application,
> still the same form appears but the table may not be recreated.
> How can i check in code-behind (VB) whether that table (e.g. table 'dan'
> exists)?

"Mr. Arnold" wrote:

>
> "Dan" <d@er.df> wrote in message
> news:O2G9R1NwHHA.4528@TK2MSFTNGP03.phx.gbl...
> > Hello,
> >
> > we have an intranet application using Windows Integrated Authentification.
> > When an user starts the application, he gets a form for inputting data.
> > The first time he does that, the application creates in a specific
> > database a table with the name of his account (read with
> > Request.ServerVariables("remote_user") and creates in that table the
> > records he enters. From the second time the user starts the application,
> > still the same form appears but the table may not be recreated.
> > How can i check in code-behind (VB) whether that table (e.g. table 'dan'
> > exists)?
>
> You make a stored procedure and ask the question.
>
> If exist(tablename)
>
> The stored procedure returns a Return code of zero if it's there or non-zero
> if it's not there, which you'll check in code the return code that you have
> set and returned, taking take the appropriate action.
>
> Use Google where you can ask *How to check if a SQL Table Exist* or
> something along those lines. Also look up *How to get a output parm or
> return code from a Stored Procedure using ADO.NET* or something along those
> lines.
>