Problem inserting data into database name having a '.'

hi all,
I am facing a problem while i try to insert data into a database (database
name has a '.')
The insert statement is something like this
insert into <servername>.<databasename>.dbo.<tablename> values...
ie INSERT INTO [blrkec42046d].[asdos1.1].[dbo.DLD_Customer]
I tried enclosing the servername,database name and tablename with in square
brackets([]). Still it is giving error 'Invalid object name'.
Please suggest some solution
TIA
Deepu[blrkec42046d].[asdos1.1].[dbo.DLD_Customer]
The problem here is that both the owner and the object name are enclosed in
the same brackets resulting in an invalid object reference.
Try this:
[blrkec42046d].[asdos1.1].[dbo].[DLD_Customer]
And catch up on your reading, please.
http://msdn.microsoft.com/library/d... />
3_9c8j.asp
ML|||Including a periods or spaces as part of an database object name is not only
wrong, it is exceptionally silly. Just go ahead and replace that period with
an underscore '_' and , if someone complains, tell them to change their
programming as needed.
"Deepu V" <DeepuV@.discussions.microsoft.com> wrote in message
news:36447E5C-0AE0-4208-9DAE-348BF4E5E615@.microsoft.com...
> hi all,
> I am facing a problem while i try to insert data into a database (database
> name has a '.')
> The insert statement is something like this
> insert into <servername>.<databasename>.dbo.<tablename> values...
> ie INSERT INTO [blrkec42046d].[asdos1.1].[dbo.DLD_Customer]
> I tried enclosing the servername,database name and tablename with in
> square
> brackets([]). Still it is giving error 'Invalid object name'.
> Please suggest some solution
> TIA
> Deepu
>