Wouldn't the data still be on the handhelds and any lost transactions would end up causing conflicts (potentially)?

I'm not a repl expert, but I think that what you've outlined is...

Don't believe there is an ldf. I know that newer versions of Access can install with some storage mechanism like SQL Server Express, but I'm not sure there's an LDF.

Having gone back and forth from Technical worker to Manager and back again a few times, I think I can do either job, but they're very different.

Andy did an...

Dr. Andras is correct. You cannot restore this on SQL 7. The compatibility mode just determines how object names, keywords, and other structures are handled by SQL Server 2000. It...

If you assigned all roles that were there, then you have db_reader and db_denyreader, meaning you've granted yourself rights to read from all tables and then removed them.

The way it...

We used to have 4 servers here and I never ran a domain. It isn't needed and we can sync accounts that need to be synced.

I'd honestly set up both...

How are you reindexing? There is reindexing and rebuilding, which operate differently. Read the BOL entries and you'll see that one handles fragmentation.

How do you defragment? You rebuild the index.

Use an insert trigger.

create trigger mytrigger on mytable for insert

rollback

return

that's it. If you have a row in the table, you won't get more.

SSIS if this is repeatable.

If not, run the data export wizard.

If you stop SQL Server, can you get to the file?

It might be that the Service Account for SQL Server does not have permissions to the file on disk.

If I understand this, there's a SPID that's in rollback stage and you can't clear it?

Or is there something else?

That's a good list. I'd ask if you can change indexes or how well they've done work with indexes. Many vendors seem to fall short here.

I'd definitely quiz them on...

If you have to support the servers, you need a laptop or remote desktop connection from home. Trying to get things done ad hoc from a smartphone won't work.

Laptops are...

It's hard to tell if you have single quotes, doubles, multiple singles, etc.

Build the string

select @cmd = 'bcp ' + xxx ...

and then select it out

select @cmd

in a window and...

I'd actually consider designing so you can move clients to separate databases. SQL Server scales, but to a point. There may come a time when a client doubles or triples...