You are likely executing this from the master database. As a result, that's where you're encountering an issue. That also suggests, though, that the logins have users created in the...

Have you tried reloading the counters?

1) Stop SQL Server

2) Open a command prompt and navigate to the BINN directory for that SQL Server

3) Execute lodctr sqlctr.ini

And speaking as someone who sits on both sides of the fence in my organization, it's sometimes very hard for me to get strictly server guys to understand that the...

The default database is based on your login's default database setting on the SQL Server. For SQL Server 2005, you can set the default database by:

ALTER LOGIN <loginname>

WITH DEFAULT_DATABASE =...

After you made the network connectivity changes, SQL Server was restarted? Also, when the SQL Server was last restarted, was it able to bind to the various network libraries you...

You can configure SQL Agent to fire on alerts, but you'd have to determine the right error message #. I was looking last night but didn't narrow down on exactly...

Not via anything automated, no. You can query tables like sysprocesses, but you'd have to write a job to do so. Also, a knowledgeable user could connect from Excel using...

A lot of this is dependent upon how the data is accessed (OLTP, OLAP, etc.). Here are some references that might help:

Planning for Consolidation with Microsoft...

If you have sysadmin rights, this takes care of everything easily:

dSQLSRVD

Typically, yes, HR is given its own security group. There should be files and folders only HR would have access to (personnel actions, specifics on benefit plans, etc.) so creating...

In case you need a reference, here's the BOL section on what you can and cannot run together:

Working with Multiple Versions of SQL Server

Are you wanting to rename an individual database or the SQL Server itself? If the latter, are you trying to make a default instance a named instance?

Get two reasonably large USB thumb drives. For instance, I've got a 4GB one that was about $100. Get all of your queries onto one of them and organize them...

If you database and log files are on the same disk it's also likely with the autogrow that your database and log files have become interleaved on the disk. To...

Yes, it can be done as many of us do this. However, a cursory glance of the Windows Server Catalog and I don't see BlueArc listed...