Posted on 2002-06-20
Last Modified: 2012-05-04

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

Sankar S.
Question by:sankars98
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
LVL 49

Expert Comment

ID: 7099769
Are you sure of the spelling?  I read the it creates
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

Author Comment

ID: 7105530

   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?

Sankar S.
LVL 49

Accepted Solution

DanRollins earned 150 total points
ID: 7105664
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

Author Comment

ID: 7107629
What happend to my comment... ???

Author Comment

ID: 7107651

 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.

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Errors will happen. It is a fact of life for the programmer. How and when errors are detected have a great impact on quality and cost of a product. It is better to detect errors at compile time, when possible and practical. Errors that make their wa…
Container Orchestration platforms empower organizations to scale their apps at an exceptional rate. This is the reason numerous innovation-driven companies are moving apps to an appropriated datacenter wide platform that empowers them to scale at a …
The goal of the video will be to teach the user the concept of local variables and scope. An example of a locally defined variable will be given as well as an explanation of what scope is in C++. The local variable and concept of scope will be relat…
The goal of the video will be to teach the user the difference and consequence of passing data by value vs passing data by reference in C++. An example of passing data by value as well as an example of passing data by reference will be be given. Bot…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question