sp_lock

http://msdn.microsoft.com/en-us/library/aa213025(SQL.80).aspx

what does the error log show for listeners?

what about netstat -a?

Run a trace. There must be some shrink command being run.

Is there a listener on #1? Check the error log, be sure that it's listening for remote connections. It could be set to only local connections.

Thanks for the feedback. I'm not sure that I'll eliminate them since it adds a lot to the processing time (can't let it run) and many people seem to like...

Are you capturing suser_sname() as well?

If you have permissions denied, there shouldn't be a way they can update the column. I bet you have some strange permissions mismatch.

Can you check...

1. Yes, less resources available.

2. Depends, SErver is better suited to server resource management. for one user, probably not.

3. You change this to match needs, there is no better. If...

Use CAST to convert data types.

Not sure about that algorithm, but one way hashes seem to work well. Just be careful that someone can't copy the hash and submit that in your application. Only plaintext...

Glad I'm on this side of the pond 🙂

Most people I know don't really like VSS. SourceGear, SVN, PVCS, etc, are better systems.

If you need to use SourceSafe, I'd start here: http://msdn.microsoft.com/en-us/library/bb509342(VS.80).aspx

http://www.softsteel.co.uk/tutorials/vss/index.html

Read Books Online for information on this

http://m.podshow.com/media/15351/episodes/125321/sqlservercentral-125321-09-09-2008.mp4

If you restored without using the NORECOVERY option, there's nothing you can do. You brought the database out of standby and log shipping can't restart. I'd delete it and run...

yes, principals and mirrors are database level, not server level.

yep.