1) you don't put your sql server in subversion, or any VCS. You check in changes of the objects into the VCS. The benefits are that if you need to...

You want to select from the main table in your insert, so

SELECT ...

FROM tblSCR t

Then join that with the deleted table to look for previous status.

INNER JOIN deleted...

It sounds like something broke the connection in the install. I'd tend to agree that it's not rights if you use the same connection/credentials to run all the queries and...

Can you snapshot the mirror db and run checkdb there to see if the same errors occur?

First, please debug the consistency errors, and potentially call MS bfore you run this. If it cannot fix linkages, it will drop pages and remove data. Not what you want...

So the date is stored as an offset, not as '2011-11-12'.

Is the date stored as Nov 12 or Dec 11? That's what matters. The display is separate, but if...

I do that sometimes, not necessarily 10 sec, but maybe 15, or something else. It's fraught with danger, and I do end up making mistakes, but I might be talking...

Here you go: http://www.sqlservercentral.com/Forums/Forum3053-1.aspx

If that happens, dc loses, power, I'm not sure that the mirror will pick up. The mirror will think it's lost connectivity with the witness and principal.

What you ought to...

Stefan Krzywicki (11/15/2011)

---

A valuable lesson indeed 🙂

It is funny how keyboard shortcuts can baffle people. I was talking someone through writing a query in SSMS and finished with "now hit...

😛

PhilipC (11/14/2011)

---

What makes you so strongly say not to backup a SQL database across the network out of interest?

I've been doing this for a while myself, and found it very...

I like Lowell's technique, but I'd add that if you are sending this off, I'd send to a group, even if it's just a group of one. Usually I find...

+1, congrats

The products you listed don't do all three, really. #1 and #2 are SQL Monitor. I believe that #1 and #3 are more the other products. It's really a focus...