http://www.sqlservercentral.com/articles/Security/updatedsqlinjection/2065/

http://support.microsoft.com/kb/897615

Restore the full, be sure that you use the 2nd tab with "norecovery" option set. Pick the file manually for the restore in the dialog.

Same for the diff.

Then the logs.

When...

It certainly won't solve all issues, but it could help. The supervisor/2nd person would still be responsible for their actions. If they let something through because they gave out their...

The column in the destination server that does not exist needs to have a default so it is populated by the insert statement.

blandry (8/26/2009)

---

When you go to these Microsoft "talks" Steve, do you ever ask the people giving those talks if they have done any research on the ideas they are presenting?...

Thanks, Hugo, for the practical applications. Didn't think about something like searching the newsgroups.

SQL Server doesn't really release memory to the OS, but it will replace the memory it uses with new data as needed.

It is possible that you need more memory....

That's what I was going to post 🙂

Basically a lookup. Find the hash, look up the possible plaintext(s)

I like the car analogy!

And I hope they don't start charging more for SQL without Windows, but I wouldn't be surprised.

SQL 2005 Express is a database engine, not a management tool.

SSMS would be used in either case to "manage" the database.

The temptable approach (or table var) is what I've done in the past.

You can use TVF's, as Flo suggested, if you can rewrite the code.

It depends, and that's the best answer. It's how you use the keywords, not the keywords.

I'd say that you ought to engage someone to help you tune things if you...

I'm sure there's a use, but not a common one. Certainly I didn't quite get it.

I think half the questions we ask sometimes are trivia, or tightly focused, but it's...

Manage your online presence. It can help you, and it isn't that much work.

Employers not seeing what you've done online? I disagree. Don't post if you don't want it to...