1 server with 2000

3 servers with 2000 & 2005

2 with 2005 (public facing, soon to be 2008 R2)

1 TFS server (which requires 2008) has 2008 R2

We've skipped 2008 entirely as...

First:

I really enjoy your editorials and I read as much and as often as I can.

I’m a developer, but I unofficially serve as my group’s DBA – like...

My group is similar.

Note there are other groups...

Nope, not "always".

Yes, it will (almost always) fix the example given for 'symmetric change' (I think...

If you understand what a checksum is then you know whether it is appropriate to use it. It is a type of hash, so sometimes it is appropriate and sometimes...

I wanted a data compare tool and a schema compare tool.

We never purchased because of 'business reasons'.

I'm very happy that VS 2010 has both of these, it has already...

I think some of you may be looking at the question of losing data differently than I do.

I'm not saying you should turn off the transaction logs, I'm saying...

Yeah. So if I follow, that would create an in-memory temp table, but because of the very small footprint (Max 2 rows) I shouldn't have to worry much about memory.

(It...

Ken McKelvey (1/27/2011)

---

I would be inclined to look at:

1. Just using union all for the default result set...

2. Returning the results as OUTPUT parameters, not a result set.

3. Using ASP.Net...

would this trigger work if the update was done on a linked table from Access? I support users touching tables directly, but not writing UPDATE statements. They go into the...

---

I am working for a company that is just getting off the ground...

1) How do you slow the boss down to document the environment, plan backups and develop a...

I don't see an answer directly.

does the error come when you run the code to create the sp, or when you EXEC the sp?

Sounds like the problem is when you...