October 19, 2006 at 1:13 pm
I have a basic SP that will drops and creates a table and it runs fine.
The problem is that when I run the report and I go back to Enterprise Manager, the table does not show up in my list of tables. I have tried to right click and select refresh on both the sever level and the database level, and still nothing. The only time that the table shows up is I close Enterprise Manager down completly and then reopen it.
What is going on?
Richard
October 19, 2006 at 1:27 pm
Have you tried hitting the refresh at the table level?
October 19, 2006 at 1:41 pm
Yes, the only thing that I have not tried is the rebooting the system and going from there.
October 19, 2006 at 1:48 pm
Can we see the code you execute in the sp?
October 19, 2006 at 2:02 pm
I mispoke before, refreshing on the table level works.
October 19, 2006 at 2:06 pm
Thanx for the honesty .
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy