You will need a different maintaince plan for T-Logs and Full Backups.

the ideal situation really depends on what your business needs are, a typical scenario might include a full back-up...

I may be missing something, but if you don't need the where condition why don't you remove it?

SELECT index, B.Value

FROM table1,A.table2, B.Table2

WHERE index = A.index AND

index = B.index2

Also...

I am happy you solved this, Thanks for the Feedback..

If your witness and primary failed then i guess you are in trouble , that is why it is recommended to put your witness on a different server in...

There is not a load of overhead from a witness, it really is just pinging the servers to see if they are still alive.

If high availibilty is your priority...

If the Id is not important then all you need to do is not connect a data flow to the ID column and it will populate itself.

If it is important...

Why do you not add a witness?

alad (9/19/2008)

---

I am considering setting up mirroring in High Protection Operating Mode (Principal and Mirror only; no witness). My question is what happens in the event the principal server crashes/disk...

Terri (9/19/2008)

---

Matt Miller (9/18/2008)

---

It makes sure that the trailing spaces don't get truncated before you count them. (LEN will not count trailing spaces). by adding it to both -...

Insert the count into a table, and then execute the next step based upon what is in the table.

you could also create a SSIS package to do this, may be a bit overkill but will enable more fuctionality if needed in the future

Try using MAX and Group By for this.

SELECT

item_id as "Item ID",

( fifo_layer_number ) as "FIFO Layer Number",

( item_desc...

I have had a similar problem when i was setting up replication, it turned out to be an issue with running sql under a local account.

Could this be the...

I really like this solution nice and clean.

okay sorry,

what account are you running sql under?

Full text search in SQL Server will only work if SQL Server is running in the System account