A few email replies

#1 - Has been a good job, but things have changed and it's time to move on.

#2 - f)negotiating with someone else right now for a new...

You can set up tracing or auditing in SQL Server 2008, but it can be a tremendous amount of data. It depends on what you capture.

If you want data changes,...

Yep, I'd do what Anthony suggested. Data Compare isn't that expensive, and it will help you figure out what to move between the databases. It could be cheaper than manually...

Did you set up replication recently? It does require a PK of some sort on tables, and I believe it adds a column if there isn't one already.

Red Gate offers a couple tools to help here. Object Level Recovery can help, but really you want to look at what you are restoring and make sure it's correct....

That's odd. usually the login shouldn't be slowing it down, especially in SQL 2000. There must be something that's not happening in sa, but can't think about it.

If you can,...

The only thing that seems off is the GameTeam table. Why do you just not have two teams in the Game table thet FK back to the Team table? There...

I use CTRL+R to whack the results in demos and quickly get back to the coding window.

You'd also have to store passwords as characters, likely plain text or ever so slightly obfuscated. If you do any conversion to binary, you can't have case insensitivity.

A big security...

Ugh, my apologies. In the copy/paste, I lost C somehow.

The option was supposed to be c) get me out of here ASAP

Strange. If you give another login, perhaps a db_owner, but not sysadmin, is there a change?

Any chance of client side tracing through ADO?

Revenant (5/31/2012)

---

jarick 15608 (5/31/2012)

---

It's like a mechanic says, "Pay me a little now or a lot later." Companies are overly concerned with the next quarter's profit statements at the...

In addition to Sean and Lynn's advice, buy a book. Work through it page by page. You'll learn a lot.

Pick a few problems to solve. For example, read the SSIS forums, find a question on scripting and try to solve it. Or re-implement it on your system, using someone...

Fat Tire is my current favorite, but I do enjoy an Avalanche Ale as well. Mostly looking for Amber ales when I'm out of CO

For cooking, I'll boil brats in...