In the below database and schema, the default schema is dbo. When I type in
Select * from DbName.SchName. and then try to select the AccountAddresses table the auto-complete enters in double dots (..) before the TableName.
select * from gcma_CISMHS_STAGE_FV.dbo..AccountAddresses
Needless to say this is incorrect syntax being generated…
Category Timestamp Duration Message Line Position
Error 4/27/2012 10:20:04 AM 0:00:00.632 <link> - SQL Server Database Error: Could not find server 'gcma_CISMHS_STAGE_FV' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers. 1 0
Note: please advise if you are responding to the Beta Forum for issues such as this one ,,
Hank Freeman
Senior Systems, Database/Data Warehouse Architect
hfreeman@msn.com
678.414.0090 my cell Primary
Hank.Freeman50 (Skype)
