My prayers are with you and your family as you heal from this.

Have you tried using the [with(rowlock)] hint?

You're right - select @@version does give you everything. Mine is just more focused and helps with my lack of attention span 😉

Have you tried running:

RESTORE [DATABASE]

WITH RECOVERY

Just a question - did you use the NORECOVERY option when you restored the database?

This will give you the version and service pack level

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

This Microsoft Support article seems to address the issue that you're experiencing:

http://support.microsoft.com/default.aspx/kb/911845

I can't remember where I found this, but I use the following trigger to audit login events. This has the added benefit of writing the events to a table.

CREATE...

Yes, Kelvin's idea is fairly simple. You can use something like:

DECLARE @cmdstr varchar(100)

DECLARE @filedir varchar(50)

SET @filedir = path that the file should be copied to

SET @cmdstr = 'bcp...

I've run into this before. Here's my understanding (and I'm sure that I'll be corrected if I'm wrong): If ANSI_NULLS is set ON, NULL is some unknown value, so...

There's also this:

select b.uid, b.name as username,a.name as login

from master.dbo.syslogins a, sysusers b

where a.sid = b.sid

Thanks - I've seen that article and our sys engineer is looking into the spn issue. I still don't know why the passive node would be trying to access...

What Lynn and DaveB are saying is that they feel (and I agree) that it's the responsibility of the DBA to set up replication. While we've had developers...

The IP address of the client is the passive node of the failover cluster. That's what's making this confusing.

We're still experiencing these errors and I can't find anything online that explains them. If anyone else has experience with this, I'd appreciate it.