Thanks Lucky,

Don't know how I missed that!

Elliott

The databases are essentially separate regarding mirroring and fail-over.  There could be many conditions triggering a fail-over of one or more of the primary databases.  It also depends on whether...

Jeff--

We don't think there's any fool-proof logic that SQL can follow to identify last names.  Multiple middle or last names are likely to escape machine analysis.  Complex logic (such as...

Ahhhh,  the light comes on 

Thanks.  I can't wait to try it.

Elliott

Thanks Sergiy, Ronald

I agree that putting the logic right into the insert statement would be better.  But I was asked to provide a function, and so I did.

Sergiy--I'm not quite...

OK, I went to Services and re-started SQL Server Agent to fix the problem. 

I have no idea what occurred to this service while I was gone, but I am...

Andrew,

Log shipping is an important part of the solution, but will require manual intervention to activate your remote database as the new primary.  You might want to look at database...

The only other issues I can think of to check are the service accounts for each of the 3 servers.  If the same account is used for each one, then...

I also had that error.  I finally achieved witnessed mirroring when I specified port numbers other than the defaults that the Wizard chose.

Once it started working, it's been very smooth...

Anita,

I'm not aware that there is any way to "rotate" backup files kept in a backup device, and I'm pretty certain the parameters you listed (Retaindays, etc) will not help.

I...

Pradeep,

Your query should work if the referenced columns are indexed for full-text.  By way of refinement, you may want to specifically list the columns of interest ('ColumnA', 'ColumnF', ColumnT',...

Maybe I don't fully understand your requirement, but start with something like:

Select title, creator, subject, entrydate from metadeta

where entrydate>GetDate()-90 and subject like '%english%'

Note the % used for wildcard symbol,...

Charcoll,

Unless the connection to the witness is broken, the two messages seem to carry a contradiction:  Both databases cannot be attempting to be Principal.  If you refresh the view, are...

Declare @db varchar(50)

Declare @id int

I use the following code to make backups of all relevant databases (including any newly created databases) except for the system databases and those that are...

Frans,

Could you give a littlel more information?  The trigger addresses INSERT, but not update, so I'm not sure what behavior is expected.

Elliot