Given that you haven't provided a sample sql query you are running, I'm going to say it is because you are trying to query out of it by saying
SELECT * FROM dbo.New LP
When instead you need to be using something like
SELECT * FROM dbo.[New LP]
Sql server doesn't like spaces in table names, so when this happens you need to use the brackets like i've shown to query a table with a space in the name.
To replicate, do something like this
CREATE TABLE [Test Data]
(
Id INT IDENTITY(1,1) NOT NULL PRIMARY KEY,
Name VARCHAR(20)
)
SELECT * FROM [dbo].[Test Data]
SELECT * FROM Test Data
You'll see the first query works but the second does not.