Debugging SQL and MSDEV_TRAIL_XXXX

Hi,

I have created a database project in VC++ 6.0. I selected an odbc DSN name from the list. Now when i go to the database tab and tried to expand the "table" , VC++ creates "MSDEV_TRAIL_TABLE" table in the database. for view, it creates "MSDEV_TRAIL_VIEW". If they are already there, it creates "MSDEV_TRAIL_TABLE1" and "MSDEV_TRAIL_VIEW1" in the database. How to avoid this temp. tables/views ? Is there any way to tell VC++ not to create those items in the database? I am using SQL Server 2000

Thanks,
Sankar S.
LVL 1
sankars98Asked:
Who is Participating?
 
DanRollinsConnect With a Mentor Commented:
I could find no direct information.  But it would make some sense if the Wizard needed to try to create a new table as part of its setup (so it could dim out controls and so forth).  

It might use a name like "Trial Table" because a "trial" is when you "try" something.  So why doesn't it just delete the tables after verifying that it could create them?  That could be a bug.  

>>Is there anyway to not to create these tables/views in the db?

Have you installed the latest service pack update?

If so, then you might need to just delete the tables manually.  Be careful... I could be wrong in my guess that they are purely for temporary purposes.

-- Dan
0
 
DanRollinsCommented:
Are you sure of the spelling?  I read the it creates
     MSDEV_TRIAL_TABLEx
This text string can be found in the file DEVDTG.PKG It may be related to the need to verify that it can create a SP, View, or Table so that it can complete its functions.

-- Dan
0
 
sankars98Author Commented:
DanRollins,

   Thanks for the response. You are right. It is MSDEV_TRIAL_TABLE. I dont understand the remaining parts in your post. Could you please explain it? Is there anyway to not to create these tables/views in the db?

Thanks,
Sankar S.
0
 
sankars98Author Commented:
What happend to my comment... ???
0
 
sankars98Author Commented:

 Thanks for your response DanRollins. Yes, I was also expecting that those tables will get deleted when i close VC++ or if i open another project in VC++. But it didnt happen. Like you said, it could be a bug. I couldnt find any information about this table in msdn or in the net. Now I am manually deleting those tables/views/sps. Thas for trying to help me.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.