?
Solved

Debugging SQL and MSDEV_TRAIL_XXXX

Posted on 2002-06-20
5
Medium Priority
?
224 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
[X]
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
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 600 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: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone 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

C++ Properties One feature missing from standard C++ that you will find in many other Object Oriented Programming languages is something called a Property (http://www.experts-exchange.com/Programming/Languages/CPP/A_3912-Object-Properties-in-C.ht…
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 tutorial is to teach the user how to use functions in C++. The video will cover how to define functions, how to call functions and how to create functions prototypes. Microsoft Visual C++ 2010 Express will be used as a text editor an…
The viewer will learn additional member functions of the vector class. Specifically, the capacity and swap member functions will be introduced.

719 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