It depends on what an Application DBA is.  I would guess that the Application DBA is a development DBA?  If this is true, then here are a few possible differences (depending...

Use SQL Profiler and capture the Security Audit>>Audit Login Failed event.  You should be able to capture the login that is failing.  You can then at least see if it...

Have you tried bouncing the OS?

It sounds like you want to implement your own locking control.  There are a couple of ways to do so.  First, you could wrap your stored procedure up in a...

First of all, you need to make sure you have SQL Server running on your workstation.  Open up your services window in control panel.  Look for MSSQLServer.  If it exists...

Just double-click on the Maintenance plan in the Database Maintenance Plans window and you will be able to edit the activities that that plan will perform.  Doing this will automatically...

Using the Database maintenance plan wizard is an effective way to schedule backups.

1. If you create the job using the DB Mainenance plan wizard, make changes to the job using...

We are using Windows 2000 Advanced Server.  I just read a kbase from Microsoft stating that the 3GB switch will only work for SQL Server 2000 Enterprise or Developers edition.  We...

AWE is required for memory above 4GB.  You do not need it unless you plan on using more than 4GB.

Logically partitioning the mirrored pair will not get you the benefits you are looking for.  The only way to better the performance of SQL Server through the disk subsystem is...

When you say the database is locked by its user database, what does that mean?  Doesn't it give you a user name?  Do you recognize the host name? 

Right-click on...

Use EM to find out who is connected to that database.  I imagine it is your EM session.  Shut down your EM and try the QA command again. 

Using QA:

USE Master

sp_dboption '<your DB name>', 'SINGLE_USER', false

SQL Server 2000 does not include triggers in any of it's INFORMATION_SCHEMA's.  Try using the system tables:

select * from sysobjects where type = 'TR'

I'm not sure I understand the question.  This comes from BOL, maybe it will help: 'Contains one row for each stored procedure and function accessible to the current user in...