Someone at my job who was a IT Professional before me wrote a SQL
statement. That statement or file is working with a program that we
use called Papervision and the purpose of that SQL is to assign data
to a table. I need help on how to locate this SQL file. I know it is
running because it is working with the program papervision but it is
not working correctly. Is there any easy way to locate SQL files off
the server we are using?

On Mar 13, 1:14 pm, "The Man" <LeJon7...@gmail.com> wrote:
> Someone at my job who was a IT Professional before me wrote a SQL
> statement. That statement or file is working with a program that we
> use called Papervision and the purpose of that SQL is to assign data
> to a table. I need help on how to locate this SQL file. I know it is
> running because it is working with the program papervision but it is
> not working correctly. Is there any easy way to locate SQL files off
> the server we are using?

Yes. Try the following:

On the server click "Start" and then choose "Search."
In the box that opens, where is says "All or part of the file name"
enter *.sql
Where it says "Look in" select "Local Hard Drives"
Click the button that says "Search"

Then just wait for the results.

On Mar 13, 11:14 pm, "The Man" <LeJon7...@gmail.com> wrote:
> Someone at my job who was a IT Professional before me wrote a SQL
> statement. That statement or file is working with a program that we
> use called Papervision and the purpose of that SQL is to assign data
> to a table. I need help on how to locate this SQL file. I know it is
> running because it is working with the program papervision but it is
> not working correctly. Is there any easy way to locate SQL files off
> the server we are using?

What is papervision? Are you familiar with this product? Maybe the sql
is located somewhere within this app.

On Mar 14, 4:56 pm, othell...@yahoo.com wrote:
> On Mar 13, 11:14 pm, "The Man" <LeJon7...@gmail.com> wrote:
>
> > Someone at my job who was a IT Professional before me wrote a SQL
> > statement. That statement or file is working with a program that we
> > use called Papervision and the purpose of that SQL is to assign data
> > to a table. I need help on how to locate this SQL file. I know it is
> > running because it is working with the program papervision but it is
> > not working correctly. Is there any easy way to locate SQL files off
> > the server we are using?
>
> What is papervision? Are you familiar with this product? Maybe the sql
> is located somewhere within this app.

I got some idea from your other post regarding asking for 'SQL Help'.
It seems that your app scans invoices and puts them into sql server
and when you tried to import new data (to match and merge) it failed
with an ODBC error. Your best bet is the product support help. Also,
the server might have some tables that store your invoices (scanned)
with all the information. You might want to find out from QA under
database-tables and view the data itself and might want to get to the
data itself using Enterprise Manager!