I'd not think that cross training is prohibited, but cross training to some people.

You can't have the dev DBA take over for the production DBA. The Windows sysadmin or someone...

Glad to see you supporting the authors. Many of them speak for free, give up time away from family and career, to help others. Books provide some income.

Feel free to...

Are you running the SQL 2000 Profiler? I've seen some bugs where some filters just didn't work.

you could also use something like this:http://www.sqlservercentral.com/articles/Miscellaneous/exchangefromsqlserver/1526/

Be careful of automating too much of attachments. This can be a security issue if someone can send an email and you import it...

Glad you enjoyed them. I also blogged from a few sessions. Didn't get to that many because of commitments, but I have a few up here: http://blogs.sqlservercentral.com/steve_jones/default.aspx

You should be doing log backups as well. those will have the updates, independent of diff backups.

I'd agree as well that 32bit isn't necessarily dead.

However, if you can consolidate servers, if you're considering virtualization, if you basically need bigger servers and more memory can help, you...

Is this recompiling constantly? Or is it set to recompile on every call?

I haven't heard of this, but it might be a PSS call is needed.

It's not clear what you mean. Are you getting an error or deadlock? Can you explain more what you are trying to determine or what the problem is?

If the service account is expired, you might not have an issue until the SQL service restarts. It is running and like a live user, it doesn't necessarily get kicked...

You need to better define requirements. If the user can change the fields or determines them, how do you determine uniqueness? You can use a GUID to guarentee uniqueness,...

I've had issues with the wizards as well. Use a backup / restore or a detach attach to move databases.

Full Text searching is for searching large values of text for some data, similar to what you get with Google, Live Search, etc.

If you have queries that you are using...

Not sure if this is possible, but you might ping Steve Lasker. He worked on the Compact team.

http://blogs.msdn.com/sqlservercompact/

Looks good to me!

Be aware that I've seen in SS2K jobs change to a new owner if they're edited, so keep this around. Not sure if that's a problem in...