GilaMonster (10/1/2013)

---

SQLRNNR (10/1/2013)

---

Good.

I'll probably be...

Another reason I love my wife. We invited about 20 friends & family, bought...

jasona.work (10/1/2013)

---

Grant Fritchey (10/1/2013)

---

Please. For purposes of employment, some of us cannot comment on politics because no matter what side I argue for, I'll yack off a customer or six....

Please. For purposes of employment, some of us cannot comment on politics because no matter what side I argue for, I'll yack off a customer or six. Can we keep...

I used Policy Based Management as a secondary check on backup age. It's really easy to set up and maintain. You can read an introduction[/url] about it here.

If you have to run these in parallel, then I would suggest using PowerShell. You can spawn multiple threads to have them all firing at the same time. I don't...

Another mechanism is to use PowerShell. You can pretty easily walk the structure and generate scripts. Allen White has an example where he does it for the entire database. It'd...

You're pumping 20000 rows (estimated, actual could be more) into table variables, where there are no statistics. Then you're combining that with a multi-statement table valued function, which also doesn't...

Yes. The most I ever had was SQL Server 2000, 2005, 2008, 2008R2 and 2005 Express and 2008 Express. That was six instances of various versions on one desktop. No...

To alter a database to a add a log file, you'd go through the processes outlined here.

Congrats Granddad.

hisakimatama (9/27/2013)

---

Rawr! I did it! Worked a full 8 hours on the stupid query that made me quite grumpy yesterday, converting it into a much better SQL statement...

As to permissions, it's pretty easy to script them out and reapply them as part of a restore.

But, if you have differences in structure, there is no way to run...

Yeah, I think the best mechanism is through security. You can't even set up a trigger on something like this.

Just through restricting access to it. You have a lot more granular security settings in SQL Server than Access. You'll want to read up on it.

Oh, and my name is...