<div>
No comment has been added lately, so it's time to clean up this TA.<br />
I will leave a recommendation in the Cleanup topic area that this question is:<br />
<br />
- Points to cheekycj<br />
<br />
Please leave any comments here within the next seven days.<br />
<br />
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!<br />
<br />
girionis<br />
EE Cleanup Volunteer
</div>


No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

- Points to cheekycj

Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

girionis
EE Cleanup Volunteer

<div>
<div class="content wysiwyg-content">
I have a production server (SQL Server 2000) with my production database on it. &nbsp;In a specific application, we reference the server on numerous places. &nbsp;Should we have a test-data directory on the server, what is an easy way to swing between accessing the prod and the test environment? &nbsp;One option is probably creating a script to change the reference from prod to test db in our code. &nbsp;Is there any other way you could suggest overcoming this problem?
</div>
</div>


I have a production server (SQL Server 2000) with my production database on it.  In a specific application, we reference the server on numerous places.  Should we have a test-data directory on the server, what is an easy way to swing between accessing the prod and the test environment?  One option is probably creating a script to change the reference from prod to test db in our code.  Is there any other way you could suggest overcoming this problem?

How do I reference test data with SQL Server 2000?

JavaServer Pages (JSP) allow the development of dynamically generated web pages. It uses the Java programming language; JSP pages are translated into servlets at runtime, with each servlet being cached and reused until the JSP is modified. JSP allows Java code to be interleaved with static web markup content, so the resulting page can be compiled and executed on the server to deliver the content.