Search results for query: *

I have a Publisher database which is also a Distributor. I want to initiate a mirroring session with this box as the Principle and with the mirror on a separate box. In the case of a failure of the Publisher/Distributor box, the mirror will take over of new Principle of the mirroring session...

I am getting technically distinct records since one of the fields is different, but I don't want all of them, just the one with the largest number in it. Here is an example of what my current sql statement is returning: field1, field2, field3 apple, fruit, 50 apple, fruit, 43 apple, fruit, 32...

I have set SQL Server Agent to restart automatically if it stops unexpectedly. Unfortunately we have brief power outages, sometimes quite frequently. I take a look at the server after it is restarted and SQL Server Agent is stopped. I have some fairly critical jobs that need to run on a...

I keep running into the problem of my sql server database not being able to delete large numbers of records. It just sits and spins so to speak, and I have to eventually just stop it. It is pretty good hardware, dual xeon, 2 gigs ram, etc. How can I do large deletes and updates in SQL Server...

I have a document library under Home and want it to also show up in another area. I change the settings>location to include not only home but the other area, click ok, and it stays only available in home. Same for a message board, will not show up in another area. After I save these changes, it...