Not sure if you've resolved your issue or not, but this might be the right tool for you:

http://www.toadsoft.com/toadsqlserver/toad_sqlserver.htm

It's a free tool called TOADSoft for SQL Server, and apparently...

What about searching?

Can you search through your saved scripts in EditPlus for keywords?

I fiddled around with Template Explorer, and the functionality is pretty limited.

I realize that this is probably much too late now, but you could always use SSIS, or the bcp utility, or a T-SQL INSERT ... SELECT statement to transfer the...

Thanks, Yelena!

The question is a bit misleading and should have been phrased: "What is the SYNTAX that begins the correct SQL statement?"

Isn't the CONVERSATION part of the syntax optional?

I just double-checked in BOL, and:

BEGIN DIALOG [ CONVERSATION ] @dialog_handle   ...

- Simon

Subu,

What about moving the table to its own Filegroup, and then doing a Filegroup backup?

This would require some work, though. Aside from moving the table to its own FG, you...

Hi,

I passed my MCTS 70-431 exam on the first try in June, after 5 months of self-study.

Besides the books you noted in your list, I would add "Exam Cram: Exam...

Robert:

Thanks for your advice, I appreciate it.

You weren't the first one to mention tag-team/cage match scenarios, which makes me wonder if there's a lobby group for tag-team/cage matches nested within...

I have several years experience working with Access, and consulting on CRM software, and am looking to make the jump to being a dba working with SQL Server 2005. I...

The project is being used for fun, and as a learning tool/active workshop.

When you say "take the time to normalize the data", I'm assuming that you mean normalizing part of...

That's an interesting idea, Matt, except that in some events, the Fighter1ID column needs to be the Champion, and the Fighter2ID column needs to be the challenger (in the case...

Thanks, everyone, for all the input.

I have decided not to normalize the Fight table, because there will always only ever be two fighters in the context of this database.... (famous...

If I normalized the table, wouldn't I have duplicate values in all the other fields, besides Fighter?

For example:

EventID     Fighter     Date      FightOrder     ScheduledRounds     WeightClass     Result     ResultRound    ResultTime   ....     ....

1              5             1/1/07   5                 3                           170               ...

Thanks so much for your reply, Jeff.

For your suggestion regarding normalizing my FIGHT table, should I normalize it even if there will always be two fighters in a fight?

-Simon

I agree that there are a lot of factors involved - especially experience, and the length of the contract. Nobody wants to be blacklisted, or bid themselves out of work....