Just make sure you write it like that. I have...

There is nothing humble about your opinion.

If you read his post, you will see he is correct and...

Every INSERT/UPDATE/DELETE statement is it's own implicit transaction. If, for example, that transaction fails 90% through,...

I'm not in front of a server to test thins, but I wonder how this would perform an a large table. It seems to me the delete or update will...

doobya (7/17/2010)

---

My 2 cents

I never yet saw an automatic failover solution that made a good determination when to failover

I prefer for a fast manual failover

All servers are configured to perform...

If the Access front end is an ADP, then you're probably using the native SQL and could expand on the connection string.

If you're using an MDB and are thinking...

Your connection string would look something like this:

Data Source=myServerAddress;Failover Partner=myMirrorServerAddress;Initial Catalog=myDataBase;Integrated Security=True;

The application will connect to whichever one is available, if the primary fails, the application connections will automatically switch...

Rudy Panigas (7/15/2010)

---

I looked at database mirroring.

Here is what I found:

1) With mirroring, failing over (either way) requires work to be done at the application/workstation to point application to...

Two options come to mind:

1. Use the UNPIVOT command (http://msdn.microsoft.com/en-us/library/ms177410.aspx)

2. Assuming four columns:

SELECT CASE NUM

WHEN 1 THEN Col1

WHEN 2 THEN Col2

WHEN 3 THEN Col3

WHEN 4...

I would add that mirroring is pretty good (and fairly easy to set up) with automatic failover.

calvo (7/2/2010)

---

Mirroring is an option. But you need to decide what you are trying to protect against.

If you're worried about OS failure, either will work.

If you're concerned with disk...

I thought that might be where you were going with this. You may find this a more straightforward technique

DECLARE @Users VARCHAR(MAX)

select @Users = COALESCE(@Users + ', ') + fullname

FROM (

SELECT...

You will need to union your two sets inside of a subquery and apply the FOR XML outside the subquery. That will get you your desired result, but what exactly...

Keep in mind that most email clients do not automatically load images in emails for privacy reasons. I expect that isn't the issue, but I wanted to mention it.

The problem...

I'm not sure what an error 156 is, but you've got at least three syntax errors:

In TSQL, the syntax for IF...ELSE is:

IF expression

BEGIN

...

END

ELSE

BEGIN

...

END

There is no then (also...