Solved

Debugging SQL and MSDEV_TRAIL_XXXX

Posted on 2002-06-20
5
219 Views
Last Modified: 2012-05-04
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.
0
Comment
Question by:sankars98
  • 3
  • 2
5 Comments
 
LVL 49

Expert Comment

by:DanRollins
ID: 7099769
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
 
LVL 1

Author Comment

by:sankars98
ID: 7105530
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
 
LVL 49

Accepted Solution

by:
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
0
 
LVL 1

Author Comment

by:sankars98
ID: 7107629
What happend to my comment... ???
0
 
LVL 1

Author Comment

by:sankars98
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.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
how to convert c++ code to Android App 3 108
Arduino EDI - Programming language 3 103
Unable to start eclipse ? 17 153
Embarcadero C++ Builder XE10.1 Berlin red arrow Indicator 2 53
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…
Basic understanding on "OO- Object Orientation" is needed for designing a logical solution to solve a problem. Basic OOAD is a prerequisite for a coder to ensure that they follow the basic design of OO. This would help developers to understand the b…
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 viewer will learn how to use the return statement in functions in C++. The video will also teach the user how to pass data to a function and have the function return data back for further processing.

840 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