Those are...

Craig Farrell (11/8/2010)

---

I guess I need to learn intersects. 😉

And before I'd worry...

It's normal for the "script as" on DDL triggers.

Mike Caldwell (11/8/2010)

---

Dictionary words aren't as secure as you make them out to be. A dictionary word has far less entropy than a random sequence of characters, hence the...

DDL triggers can also fire for server-level actions, like creating/dropping databases. You just specify "on all server" instead of "on database".

I normally do ETL through SSIS, not through an external XML file, but it sounds like it should work, if I'm understanding you correctly.

I'd call Microsoft on that one.

You might not want the whole connection string for that. Has security implications.

If you add "@@servername" as a column in the query, and add that to the report, that...

Craig-315134 (11/8/2010)

---

Revenant wrote:

'Security based on biometric data is not a good idea because just like any other data, your biometric data can stolen - and if it is, you cannot...

Richard Warr (11/8/2010)

---

W!OW34f34D3h54qo looks like a nice strong password but it's just SQLServerCentral moved "one key up" when you type it in. Use that method in conjunction with a memorable...

First, managing the transactions from the calling code, is generally a really bad idea. You're most often much better off to manage the transactions in the stored procedures. ...

What I've got for something like that is an XML-based "before" log.

If you look in the articles on this site for my Audit Trails and Logging piece, and look in...

So if the sum ends up at 15.01015, and you want to round to the nearest minute, how does "round(15.01015, 0)" not get you what you need? It'll return...

15 seconds is still...

Craig Farrell (11/7/2010)

---

As Jeff mentioned above, that particular question is a trap. ...