If you are using replication, you will need to stop and restart SQL after you do the drop and add server.  It appears to grab the server name when SQL...

Encountered very similar situation but where a database grew to a large size very quickly (reasons not pertinent). I had to move it to a machine where I could get the SAN...

I've worked with active/active in the past with 2 or 3 instances on each cluster.  My advice with installs and upgrades is they work best on one instance if the others are shut...

Simple database, 1 simple UDF, one simple test to test for the correct answer and UDFs are included:

select name, object_name(id), xtype from syscolumns where object_name(id) like 'udf%'

answer:

ind_id              udf_PeopleQualifiedForAJob 56

@strJobName    udf_PeopleQualifiedForAJob 167

ind_lastname    udf_PeopleQualifiedForAJob 167

@dtToday       ...

I've had this problem consistenly with 3rd party tape backup software that appears to be finished backing up a file but in reality it somehow still maintains a lock on...