You want to know who has installed the tools, who has SQL Server itself installed, or both?

The easiest way is with asset management software like Altiris or SMS. There are...

I would advertise for a Senior DBA/Database Architect. Explain the duties clearly in the job section. You'll find a lot of folks bearing either or both titles who do schema...

Unless the table definition changes a lot, script out the table creation using EM. Then dynamically build a SQL statement, except replace the table name with a variable. Then execute...

Why would the application spawn new connections without using the application role? Also, datareader and datawriter and indeed very, very broad. That also gives access to system tables. Can you...

Along those lines:

TANSTAAFL

What happens when you perform a four-part naming convention on the select like SELECT * FROM SAGE.<database>.<owner>.STOCK ? Same # of rows?

I have installed Analysis Services without issue on Windows XP Pro several times. If you had the error messages you received after the install, that might help a lot. However,...

They don't necessarily broadcast. Does your organization have any asset management tools like SMS or Altiris?

If not, you can use a tool like SQLRecon. It was developed by Chip Andrews...

Can you explain what you mean by make a copy of your DEV server? Are you looking to setup a second server and have the same databases, etc.?

Not my philosophy, but a saying I heard a lot while in the military (it's supposed to be the philosophy to use when captured, but it seemed to be status...

I'm not sure, most likely because they are internal to SQL Server. They behave very differently than user-defined functions in a lot of regards. For instance, you can sp_helptext a...

I don't believe there is. I don't recall one and we've run a lot of traces over the year. How many rollovers were you considering?

Run a Profiler trace of the production server. Make sure to toggle the Audit Object Permission Event with the Success data column. Have the user try and view Current Activity...

It's because it is a system function and not a user-defined one. You can't touch system functions in such a manner. For instance, do the same with any other system...

Check the permissions on a stored procedure in the master database: sp_MSset_current_activity. This is what Enterprise Manager calls to get that information. Permissions should be set where the public role...