Forums
This topic is locked
SQL Database Problem
Posted 01 May 2007 10:59:52
1
has voted
01 May 2007 10:59:52 Ian Bateman posted:
I have just moved my SQL database to a server with another host. All my database tables are now showing in Dreamweaver with the user id in front of the table name. So now tbl_Customers is showing as TonyGrey.tbl_Customers.How do I get it back to where it was? I don't relish the prospect of re-coding all my pages ... Help
Ian
Replies
Replied 07 May 2007 23:31:14
07 May 2007 23:31:14 Lee Diggins replied:
Hi Ian
Can you make TonyGrey user the dbo for the database? Not sure if this will fix the problem for you, you might have to do a replace tbl_ TonyBrey.tbl_ in your pages.
Sharing Knowledge Saves Valuable Time!!!
~ ~ ~ ~ ~ ~
<b>Lee Diggins</b> - <i>DMXzone Manager</i>
<font size="1">[ Studio MX/MX2004 | ASP -> VBScript/PerlScript/JavaScript | SQL | CSS ]</font>
Can you make TonyGrey user the dbo for the database? Not sure if this will fix the problem for you, you might have to do a replace tbl_ TonyBrey.tbl_ in your pages.
Sharing Knowledge Saves Valuable Time!!!
~ ~ ~ ~ ~ ~
<b>Lee Diggins</b> - <i>DMXzone Manager</i>
<font size="1">[ Studio MX/MX2004 | ASP -> VBScript/PerlScript/JavaScript | SQL | CSS ]</font>