That's interesting, and I think you are in for some heartache.

My guess is that signing things, or maybe not including the functionality would be better. But ultimately, if you are...

When you restore the users move, but not the logins. The sp_change_users_login procedure can help you.

http://www.sqlservercentral.com/questions/T-SQL/67309/

Offline works great if you don't need to access the instance. I like that.

But if you want to kick everyone out, Lowell's first command is what I thought of.

why do...

LOL, the only reason I know this is because it's happened to me 🙂

Always be sure that you check data in SQL Server when examining code. It can introduce strange...

Ultimately you can't stop anyone. Unless the app has the keys to encrypted data, if someone has control of the machine and domain, they can get in. The service account...

That's what you need to aspire to in technology. You need a good general knowledge about a lot of things, and then a specialty or two.

Nope, can't modify it: http://blogs.technet.com/beatrice/archive/2008/04/29/sql-server-default-trace.aspx

But you can set up your own trace that includes the events and settings you need.

That's a data issue. something is calculating a parameter for substring (liekly) and passing in something like a 0 for a parameter that doesn't accept it.

Are you looking for instance of SQL Server Express or databases?

This is easily answered in Books Online. There is a section for this. This also sounds like a test question....

If you have to ask....

I haven't tried mixing, but I would assume it wouldn't matter. Each publication and subscription should be separate.

There are 3 servers involved. Some actual instance might perform 2 roles, but...

We used local settings, which still caused issues. Users would travel, forget to move settings, and call us.

However if someone moved and used another machine locally, they got the correct...

Nice one, Bob.

We had a similar setup to AJs when I was at JD Edwards. Production instances, almost all 1 instance / physical server, were in the 200-300 range. Two DBAs.

We also...

I think what we're looking for is what would you like? I'm not sure PASS has benefits for you now, but if they could offer something, what would be helpful?

I'd...