Greg,

I have Enterprise Manager for this Classs ID and then right next to it with a little bit different first numbers as 00100106  or 00100110 are parts of EM...

Did someone try to create local logins, similar as in the workgroup? The same local login on both workstation and server? I just tried, it worked.

I have the same local...

Troy,

why don't you test first even if on your workstation?

For the production box: perform ASR backup and full file system backup after SQL database backup.

Troy,

I tried to install SQL Server 2005 Standard Edition on my Windows XP SP1 workstation. First it told me to install IIS, which I did. Then it told me to install...

Question / suggestions:

1. Question:  They say "Enabling Volume Shadow Copy" on Windows 2003 server lets you to Windows-backup open files. Who knows anything about that for SQL Server databases?

http://www.microsoft.com/technet/technetmag/issues/2006/01/RapidRecovery/

says: "It...

Hi,

There is something on the server open with sa connection. Could it be Enterprise Manager open through terminal services? I would reboot the server, check that there is no jobs...

Hi,

Good article.

The problem is even more general then just importing from UNIX-generated files. I had recently to show one of the business ladies why the data import jobs for...

Stop using.

Go to Current Activity window, processes view, sort by database name, see who is using this very database, log off everyone except for yourself (call 'em first). Yourself, close...

I saw performance issues like that several times on the very good hardware (2 to 4 GB of RAM and very good multiple processors) with only a couple of users...

Peter,

What are your requirements for the trace retaining period? Is the machine backed up every day so trace files could go to tape? In this case I would consider adding...

Troy,

it is By Design. Users are stored in Sysusers. Logins are stored in Syslogins. Both have SID (Security ID) that have to be the same. If you move the database...

Glynne,

can you execute this query yourself from the query window in Management Studio without sp_send_mail, just the query? Also, can you execute sp_send_dbmail with another query? Is your query going...

It may be DBA for the QA environment. Very important in the regulated enterprises.  Skills that you develop on this job can be valuable.

Daniela,

You do have to know locks. 3 cases out of 4 when users call me complaining they can not access databases deal with locking problems. You have to know why...

Glynne,

Is DDDD\xxxxxx domain or local Windows account? Is Domain Controller for the domain available? You say it is your login account. Login to Windows or login to SQL Server with...