I have a system that came with the MSDE database, because of the 2G limit I am trying to point it to the enterprise version of SQL 2000. All connection strings have been changed to the enterprise (With vendor help). The connection is established and according to a trace from Profiler, all queries are running and inserting the data in the right table. But there is no data in the tables! No errors either.
One of my tests was to point it to another MSDE and it worked fine. What is different between these two versions that will cause data not to be written to the tables.
ThanksHi,
Can you insert few records in to the tables manually and see what is
happening. I feel that application is
still pointing towards a different database.
Thanks
Hari
MCDBA
"Niles" <Niles@.discussions.microsoft.com> wrote in message
news:4937BB3E-CD2B-4DA1-9C83-2C03E8470989@.microsoft.com...
> I have a system that came with the MSDE database, because of the 2G limit
I am trying to point it to the enterprise version of SQL 2000. All
connection strings have been changed to the enterprise (With vendor help).
The connection is established and according to a trace from Profiler, all
queries are running and inserting the data in the right table. But there is
no data in the tables! No errors either.
> One of my tests was to point it to another MSDE and it worked fine. What
is different between these two versions that will cause data not to be
written to the tables.
> Thanks
No comments:
Post a Comment