Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vimaldreams
Starting Member
17 Posts |
 Posted - 2010-11-10 : 09:57:55
|
| When i try to execute this query in the SQLserverit says the following error : I wonder wat could be the problemINSERT [dbo].[MK_DB] ([ID], [Salutation], [Name], [Client_search], [Address_line1], [Address_line2], [Town], [Postcode], [Telephone_no], [Mobile_no], [Email_address], [Organisation], [Org_type], [Client_PartnerId], [Work_type], [MK_mailinglist]) VALUES (11101, 'Matt', 'MR M Horseman', 'Chillcott', 'Cirensecter House', '2 Apsley Road', 'Bristol', 'Bs8 2SP', '0117-2345678', '0787654327', 'Roger.Blacke@hotmail.com', 'Meade King', 'Partner', 'KWM', '78', 'Chrismas cards') |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-11-10 : 10:01:54
|
| There's no table called [dbo].[MK_DB] in the current database--Gail ShawSQL Server MVP |
 |
|
|
vimaldreams
Starting Member
17 Posts |
Posted - 2010-11-10 : 10:08:16
|
| No there is a table : Can you suggest me wat could be the other problems |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-11-10 : 10:11:03
|
| may be you're running query in wrong db. or it may be that table is existing but in different schema not dbo------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-11-10 : 11:07:12
|
| The error is saying that the table is not there or not accessible. Either you're in the wrong database, or connected to the wrong server or it's in a different schema or you've spelt it wrong.--Gail ShawSQL Server MVP |
|
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2010-11-10 : 11:16:29
|
| Another possibility is that the account that you are connecting with does not access to that table.Be One with the OptimizerTG |
|
|
|
|
|
|
|
|
Error :Invalid object name 'dbo.MK_DB'.