database migration query not executing in database

[cinsters]

We moved over our SQL database to another server. We have a few .cfm template files that have queries to get 'content' from our database. These queries in the .cfm template files work fine and execute properly. However, for some reason, since we moved over our database, the queries in the actual database don't execute/run anymore. In the old server we didn't have this problem. Our queries in the database would run properly then. The data would display correctly on the webpages.

Is there some kind of properties setup that was overlooked when migrating over our database?

The output we now see when viewing our pages is the actual query code.

Example:

SELECT lname

FROM table

This is actually displayed on the website and therefore the query is not executing/running. Our code was never changed. So why is it not outputting the same?

Thanks for any help provided.

[Dan_Bracuk]

Your problem description is not clear.  You start by saying that the queries in the cold fusion templates work fine and then you say that sql code displays on your web page instead of query results.

If you run your query in Management Studio, do you get the expected results?

If you put the query on a standalone web page, and cfdump the resulting variable, do you see the records or sql?

[cinsters]

Sorry for the confusion.

The coldfusion templates and database queries both worked fine on the previous old server.

Now since the migration onto the new server, only the coldfusion templates work fine, but not the queries in the database.

So for example, a query in the coldfusion template will run fine, and execute the intial pull of data. But once the content is pulled from the database, the queries inside the database (including stored procedures) don't execute.

We do get the expected results when we run our stored procedure in Management Studio and if we put the stored procedure on a standalone web page we do see the records. 

We only see the sql code when we have the stored procedure inside of our w_content table of our database, and its being called by the first query in the template.  For some odd reason the stored procedure does not execute if it is inside the database.  

Hopefully that clarifies our problem.

Thank you for helping!