Though no one has responded, here's an update:

I manually cleared the status column in sysdatabases for the database in question, then did a full backup & restore from my production...

Thanks for the replies, guys, will check things out. 

Spark up BOL and look for sp_create_removable in the index. This will present you with several topics on creating a db for usage on a cd-rom, dvd, etc...

Vik

I've got the same issue when trying to debug from my machine. Have to spark up an rdp session into the SQL server and run it there to make...

Thanks for the suggestions. Unfortunately, I cannot run distrib.exe from the command line in this situation, but I can and will run sp_who2 when and if this happens again.

Thanks...

Well will ya look at that!

http://www.sqlservercentral.com/columnists/glarsen/sequentialnumbering.asp

Ask and ye shall receive...

Yeah, identities are the way to go, but realize that identities aren't reused, so if you add record 02966 and then delete it, you'll end up with a gap in...

Doesn't look like price is a keyword -- it doesn't highlight as blue in QA.

Try accessing the price field another way, like:

rs!Price

rs(n).Value, where n is the ordinal position...

If your db is replicated using transactional replication, the log won't shrink unless all replicated transactions are marked as complete.

Check BOL for system sproc sp_repldone and the associated commands at...

Any particular reason you need the "order by" in your insert stmt? Try removing it & see if it affects the performance.

Allen_Cui makes a good point, maybe...

We have almost the exact same configuration deployed at a client's site with one major difference: the terminal server is on a completely separate machine.

This is an...

As NPeeters mentioned, look at the default locking done by the VB logic. We had a similar situation with a sproc doing large calculations on a table used for...

Interesting...

To quote dgermundson:

"He created some very minimal standards and the developers where cut loose. We pay for this today."

I think this is the biggest problem in development shops, bar none,...

Chris

I'm with you. Begin forgiving of bad database design is not in the "plus" column for me. Who wants to deal with optimizing or otherwise cleaning up someone...

Hello folks,

Good topic discussion. dovidf said:

>>>

Oracle has before and after triggers which is much better than an insteadof trigger. It is easy to write a single general trigger that...