Loss of SQL behind views again...oops..:)
- From: "Adam" <askme@here>
- Date: Thu, 2 Jun 2005 17:24:27 -0400
oops, pushed send a bit early before, been a long day!
I am having a weird problem with SQL server 7.0 and Access 2000. I am
currently rewriting a database for a client and need to have some views
which have a lot of columns (don't ask why!! :)) and therefore a pretty
long script behind them.
The problem I am getting is occasionally when the view is opened in design
view, either in an adp project or using enterprise manager a large chunk of
the script seems to dissappear, never to be seen again, even if it is not
saved.
Anyone heard of this sort of problem before? More of an annoyance than a
real problem as I tend to design the views in Query analyser anyway so have
the scripts saved seperately, but it would be nice if I could fix it.
TIA
Adam
.
- Follow-Ups:
- Re: Loss of SQL behind views again...oops..:)
- From: Sylvain Lafontaine
- Re: Loss of SQL behind views again...oops..:)
- Prev by Date: Re: Stored procedures and parameters
- Next by Date: Re: Loss of SQL behind views again...oops..:)
- Previous by thread: Project on Server
- Next by thread: Re: Loss of SQL behind views again...oops..:)
- Index(es):
Relevant Pages
|
