Hi,

I have mssql set up on my pws and while Im building my site with record sets DW adds the "dbo." to a table name. When I upload my site to my hosting server (which uses there mssql server) it uses my username (i.e. mtnmandan.tablename) instead of "dbo.". As you can imaginge, this causes several issues as I cannot change what my hosting company does.
What I would like to know is, I set up DW to disallow entering dbo. before the table name? I know that I dont really need it to execute the query.

Any insight would be greatly appreciated!

Thanks
Dan


--------------------
MtnManDan

<!—I think, therefore I am. I think. - George Carlin

In your queries, can you simply manually remove the dbo.? The queries should still run without that.

Yes, that is always an option, but I have several pages with record sets and it would be difficult to manually change them. Sorry, but I guess im just lazy?

--------------------
MtnManDan

<!—I think, therefore I am. I think. - George Carlin