Doh!

Edited.

It is for replication. You might need to reset this up as a subscriber, or is this a publisher?

You don't want to use a variable. Think trigger. What if multiple rows are changed?

You use some table var and then drop that into your audit table.

This help?

http://www.databasejournal.com/features/mssql/article.php/3598636/OUTPUT-clause-in-SQL-Server-2005.htm

While you can hint for some types of joins, or indexes, I'm not sure you can control join order. The optimizer looks at statistics, data sizes, and guesses what would...

Roy Ernest (8/17/2010)

Steve Jones - Editor (8/17/2010)

Roy,

I'll...

Jeff,

Keep an eye here, and the newsletter. We'll publish something when we hear.

Roy,

I'll try to do one for you...

No word yet on a place. I have used ESPN and CBS in the past. I sent an email to Dan (the OP), and no response. If I don't...

My plan was to run W2K8 and HyperV on mine (I think it goes to 12 or 16GB of RAM), but then I found that the USB in a guest...

Lian,

You'd have to provide more information about what is happening. I assume you mean query timeouts from the table(s) that the job affects? What does the job do? What are...

I like my job, and mostly because I deal with all of you on a regular basis, way more than I work with people in my company. They're fine too,...

Do you mean in those tests that you cannot log in at all, or that you are not a sysadmin?

I assume this machine is a member of the domain, correct?

Here's what I would do. I had a friend doing something similar for clients. He had one "master" database that contained common information and tables for all the clients. This...

Good luck. They were great to work with, reasonable, made changes for me, offered advice, and helped me pick a great system that works for me. I emailed a bunch,...