I disagree with respect to processmon because we're comparing apps that run on workstations versus servers. Quite simply, just about everything a DBA would need to do (if looked at from...

SysAdmin = abbreviation for System Administrator. This is actually where Sybase/SQL Server got it from. For instance, SysAdmin magazine. I should have been more clear, but usually when I...

It does sound like udp/1434 is not going through on both sides. Can you have a network analyst do a network capture looking specifically for that?

You are using one arbitrary example and the database engine will use whatever techniques it can in order to get the data back as quickly as possible. Somewhere along the...

Keep in mind that if you are dealing with an RDBMS, you are not guaranteed sorted data unless you specify an ORDER BY clause.

I think he's referring to the service account the SQL Server service actually runs under. If you know its password and it is granted administrative rights over the system, you...

Actually, unless you're installing things all the time, running with a normal user account in Windows XP is quite possible. Not just for the home user, but also for the...

Use a DDL Trigger on the CREATE_VIEW event. Something like:

GRANT

TRIGGER trigDDL_CreateView

ON DATABASE

WITH EXECUTE

Why shouldn't they? The Principle of Least Privilege is why. If the DBAs aren't expected to be responsible administratively for a server, they shouldn't have those rights. This just isn't...

Brandie,

  you are right, this is something that most DBAs wouldn't be doing. However, this is certainly a great prompt to the GPO/directory services administrators. Those guys are also supposed...

This is true... and those templates can be applied via GPO so you can push out to all SQL Servers. However, if you go down this road, don't forget to...

First thing I'd check is a firewall on the client. After that, determine if your networking folks have any ACLs in place to restrict access. Also, you may see if...

To echo what's been said: local administrator rights aren't strictly required but often granted. Why?

1. Ability to stop and restart services (although power user can give you this, Mark Russinovich demonstrated...

1. Use Database roles
2. Don't use the public role
3. Put the users into database roles
4. Assign permissions against the roles, not the users
5. Assign permissions at the Schema level if they need to be able to...

In order to be able to stop/start services, the Windows user must be a member of the local administrators or power users groups on the Windows side. However, if this...