Real Newbie Post...

I was hoping there would be a newbie section in here... But I'll post anyway (And sorry in advance if its a really dumb question)

I am using VWDE and have a SQL DB which has been imported from one of my existing forums, when it shows in the database explorer its show like below

tblArcade (jdName)
tblArcadePB (jdName)

etc..etc...

What I want to know is why this DB has (jdName) after the Table name and my other DB's shown don't?? They are just shown as

tblArcade
tblArcadePB

etc..etc..

My main questions are "How do I remove the brackets from the forum DB" as when I try to preview data in VWDE I get a message

Invalid object name 'tblArcade'.

I know its to do with this extra bit as it only happens to the tables that have this on the end... Hope that makes sense and someone can help me, if you could reply as if I'm really dumb it would be appreciated

Guessing this must be a stupid question...|||Anyone....|||Dammit... I'll keep clicking away in SQL till I get it to work...|||

This is because the table belongs to another schema rather than the default schema of the login which you use in the database connection. To access such database objects, you need to use full qualified names including schema name. For example:

SELECT * FROM jdName.tblArcade

For more information about schemas in SQL Server2005, you can refer to:

http://msdn2.microsoft.com/en-us/library/ms190387.aspx