I'm using SQL Server 2005 and trying to select columns from a SQL Server 2008 linked server that have periods in them.

I've checked this post: 

[Selecting a column with period in the column name SQL Server](https://stackoverflow.com/questions/3284929/selecting-a-column-with-period-in-the-column-name-sql-server)

But I'm not getting the same error.

This is the code

```
    INSERT INTO [Linked_Server].Database.dbo.Table
           ([Column_Name], [Column.Name])
    SELECT 
           [Column_Name], [Column.Name] FROM local_table

```

I can select from the table locally, but when I try to select the same columns from the same table on the linked server, I get this error:

```
    Msg 207, Level 16, State 1, Line 3
    Invalid column name 'Column.Name'.

```

EDIT: Fixed a typo with "[Column\_Name)". This was a typo only in stackoverflow however.
**The typo is not the problem**