This

and this

are contradictory statements. Your explanation needs to be clearer. Do you...

This is a little silly, IMHO.

Send them a backup, let them make changes, and then use diff tools, like SQL Compare/Data Compare from Red Gate (Disclosure, I work for Red...

Yes. Well not quit, but looked for a new job and moved on a couple times. The lack of challenge or excitement is a problem in work.

One time it was...

I dislike linked servers, especially do non-SQL databases since I have seen errors, especially memory errors from third party drivers in the past. This is usually over time, and in...

I tend to do what VikingDBA has done. I don't always have 3 roles, but I do always have the user role, and an admin role. Note the latter isn't...

I would use Anthony's code. He is correct that you are escaping out the parameter and making it a literal when you use quotes.

What you want from the code is...

Interesting discussion. Freedman does mention inserts and deletes, but he never wrote on the subject. Perhaps he was mistaken, perhaps he hasn't had time. The KB also mentions it, but...

1. Set some up right away. You'll forget until performance goes down and then you look bad. I'd create a clustered index right away, and then index PK/FKs as well....

Specify a default database that you know the login has access to. Joie has some good questions that need answering as well

Still here, buried in presentation demo testing, which is not going well. #$%^$#% full text search

Hey!

We are looking at publishing these as books. Most of them are still in progress, so it might take some time.

I think so. We've had it both ways in...

paul.knibbs (10/24/2012)

---

Surely, for the faulty transaction to still be in the log file, the database must be in full (or bulk-logged) recovery, so you ought to be able to do...

It has been released. At the top of the article are links to purchase a physical copy or download the ebook.