1) Yes, multiple people can map into dbo. Also, there is a fixed database role called db_owner. Multiple users can be a member of that role.

When creating objects, those mapped...

Here where I work we tend to use the default collation for the server and specify the collation on the database if that's required unless we know the SQL Server...

I understand your Network Admin's concern about the passwords. I agree with one of the other posters that I think both of you have a lot of reading to do...

Actually, SQL server will search for <owner>.<object> where <owner> is the current user. If it doesn't find an object matching, it drops back to dbo.<object>. Unless, of course, it's a...

Doh! Thanks, Frank, I completely missed it.

Check your version of Books Online. If you have the one that shipped with SQL Server, I believe it left off the local. That's been fixed, along with a slew...

If you use SQL Server logins and connect to SQL Server without IPSec or SSL, then the password doesn't go across in plaintext, but it might as well. It's trivial...

To piggy-back on Allen, rebuildm.exe is how you rebuild the master database.

I think you have this the other way around. The binaries are on the local drives. The data files are on the shared...

Keep in mind that when you run DTS from Enterprise Manager, the DTS package is actually executing on your workstation, not on SQL Server. When you schedule it to run,...

Steve makes a good point. We tend to leave ours in as well in case of emergencies like when they're onsite and we're at home at 3 AM. I happen...

Could the account have expired? Can you log on to the server with the account in question?

What you've seen from the others is correct...

BUILTIN\Administrators is a member of the sysadmin fixed server role by default. Domain Admins are getting sysadmin rights through this login. All members...

If it is SQL Server 2000 Enterprise Edition, you should be able to do so.

In BOL, Index Tab: "failover clustering, upgrading clusters." In the pop-up, "How to upgrade from a...

If possible, also cite similar technologies and work experiences... for instance, if you've been a Sybase DBA, that's a lot closer to being a SQL Server DBA than say someone...