SQL Select INTO Query

Question

I am trying to running the following command to copy a table to another database and it is saying incorrect syntax near "tbl_SecurityNamespace". Any ideas? TIA

select * into ForMSDB  tbl_SecurityNamespace
from Tfs_configuration  
go

Answer 1

This should be as

select * into ForMSDB..tbl_SecurityNamespace
from Tfs_configuration; 

Answer 2

If it's another database in the same environment:

select * into ForMSDB..tbl_SecurityNamespace
from Tfs_configuration