sql server how to enable transaction logging for table created through select into clause

I have created a table by using the Select Into statement and the table appears as an invalid object in the SSMS 2008 query analyzer due to intellisense enabling  (see example below). Note that the table still is valid and can be queried but only the intellisense enabling displays a red line below it and the tooltip feature shows it as an invalid object:

-- SELECT INTO is minimally logged - inside transaction only
-- SELECT INTO not logged into the transaction log file
-- SELECT INTO table cannot be recovered with transaction log restore
-- SELECT INTO table can only be recovered after full database backup
USE AdventureWorks2008;
BEGIN TRANSACTION
SELECT * INTO ProdZ FROM Production.Product
SELECT COUNT(*) FROM ProdZ
-- Result: 504
ROLLBACK TRANSACTION
SELECT COUNT(*) FROM ProdZ
/* Msg 208, Level 16, State 1, Line 6
Invalid object name 'ProdZ'.
*/

Is there any way to enable transaction logging for the table created through select into clause and make it appear as a valid object in the SSMS 2008 query analyzer due to intellisense enabling ? (Again, note that the table still is valid and can be queried but only the intellisense enabling displays a red line below it and the tooltip feature shows it as an invalid object)
LVL 1
skaleem1Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Guy Hengel [angelIII / a3]Billing EngineerCommented:
which exact version do you have?
I don't have the issue on my  sql 2008 RTM
0
skaleem1Author Commented:
Microsoft SQL Server Management Studio                                    10.50.3720.0
Microsoft Analysis Services Client Tools                                    10.50.3720.0
Microsoft Data Access Components (MDAC)                                    6.1.7601.17514
Microsoft MSXML                                    3.0 5.0 6.0
Microsoft Internet Explorer                                    8.0.7601.17514
Microsoft .NET Framework                                    2.0.50727.5472
Operating System                                    6.1.7601
0
Anthony PerkinsCommented:
Perhaps I am stating the obvious, but have you considered using the hot key Ctrl + Shift + R after the table is created?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
skaleem1Author Commented:
I tried and it removed the red lines and the error. What does this do?
0
skaleem1Author Commented:
Oh, it refreshes local cache, but how does it remove the error tooltip
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.