Last post Jul 19, 2012 02:27 PM by Ramu Ajay
Jul 17, 2012 11:15 AM|Ramu Ajay|LINK
I created a temp Table #testTemp and I am inseting some values and using select statement works fine from c#.
But when I log in to Management Studio and If I run the query against the Db select * from #testTemp, It says "Invalid object name" or if I use in the sp also it has the same Issue
Jul 17, 2012 11:18 AM|Mudasir.Khan|LINK
seems wiered please check you are pointing to the right DB and no one has re started the instance
Jul 17, 2012 11:23 AM|Ramu Ajay|LINK
I am pointing and querying against the same db and I am sure no one has re started the Instance
Jul 18, 2012 09:21 PM|Decker Dong - MSFT|LINK
I suggest you trying to：
1）Use global temp table staring with "##".
2）Use View instead of temp table and do query with it.
Jul 19, 2012 02:27 PM|Ramu Ajay|LINK
Thanks I will try the same and let u know!!!