Thanks for the advice.

I put another set of files in that folder and attached them in SQL 2005. Shut down SQL server, deleted the log file and put in...

I have the files now. They will not attach under SQL 2000 or 2005 directly.

I tried deleting the log file and using sp_attach_single_db under SQL 2000, this...

Thanks for the help in getting me thinking Ken. I turned off retention, did some testing, and the queue dropping the messages after they are processed, which will prevent it...

I will check into the possibility of posting the exact script for creating all this, but I would need to clear it with the original author.

To summarize what it is...

Ken Garrett (2/20/2009)

---

Would you mind sharing the output of sp_spaceused and sp_helpfile while connected to the database in question?

I believe the facts the you laid out in your post. ...

It's already gone to 285 megs, so I turned off unlimited autogrowth to see what error messages popped up in the logs. Pages and pages of this now.

2009-02-20 19:22:59.53...

Perry Whittle (7/13/2008)

---

installing sql2005 express should be no more than if you were installing another sql2000 instance.

Install a named instance and then remove it when you're done if you want...

If you are trying to script the database structure changes, we use Redgate SQL Compare to compare the development database against a reference database to generate a change script, then...

That looks exactly like SQL injection.

Our database got hit by just this kind of attack 2 days ago. The good news is, it happened about 10 minutes...

The latest Nvidia drivers (175.16) broke SSMS for me, as well as a few other programs. I rolled back to the previous version I was using, 169.21, and everything started...

Of course, the best way to get the book is buy it at a conference where Paul is giving a lecture, so you get an autographed copy....:P

I get to deal with this quite a bit in our databases. If you are using SQL logins, these may be helpful to you. If you are associating database users...

Thanks...I actually looked at that last night after I got home, and it looked like it might work, but the brain was too fried to make sense of it.

I have...

I'll take the heat because the example code is a gross oversimplification of what I am trying to do. I'm importing multiple (badly) linked tables and adding adjusting entries along...

The cursor is for the demo, but its in the live conversion...I'm sure someone can give me the flaming kill the cursor lecture, and they're possibly right, but for a...