Nothing like missing the obvious...

Thanks for your help!

Tom.Thomson (3/22/2010)

---

Gilles Willard (3/15/2010)

---

Maybe this is due to my lack of experience, or the fact that it's been several years since I last studied database normalization, but:

It seems to me...

Maybe this is due to my lack of experience, or the fact that it's been several years since I last studied database normalization, but:

It seems to me that what Timothy...

Don't mean to sound like a wild-eyed proselytizer, but THE way to both prevent back trouble and take care of it when you already have it is yoga.

I had a...

Oh, duh, never mind...:blush:

We have a small database (~850MB), so speed and efficiency were not huge factors.

The INDEXDEFRAG script took less than half an hour to run and afterwards, I noticed that our...

Got it, thanks for clearing that up for me!

I understand, thank you for your reply.

Just in case I do decide to reduce the size of the log file, though, would manually changing the Initial Size value in SQL...

Gary,

That is of course a very good point, and I will keep it in mind from now on...

Actually, what I meant to do at first, which would have...

DavidB and GSquared:

Both my production database and its copy are on the same server, under the same instance of SQL Server, so the scripts you both provided for that purpose...

The whole table

Thanks!

I've read about the techniques you describe, but haven't used them yet.

Now's the perfect time, I guess...:cool:

Once you have your basic query in place with Import External Data and an ODBC connection, you can use the following VBA code instead, which has one advantage, that of...

You are right again...

I will check with tech support before I do anything.

Thanks again to all of you for your advice!

That is actually a good question, and I will look into it: our SQL Server database is part of an off-the-shelf accounting and manufacturing software package we bought a few...