Kris - look for .tql extension files on the local drive (local to sql server ie...) - they're normally to be found under the "...\Tools\Templates\SQL Query Analyzer.." folder...

It sounds like...

David - just curious - do you pat yourself on the back regardless of feedbacks ?! That's a catch-22 right there - you know you can congratulate yourself because the...

I've sworn for years by the OReilly and Wrox publications since they both have a simple and direct way of explaining things - instructing without "talking down to" or being...

Don't know about free tutorials (maybe someone else does) but you could try going through the Sybex exam study guides and doing the exercises given there for some good practice!!!

Two things:

1) Why did you set the default db to Master and not the actual database that the users will be using ?!

2) Here's something from BOL that should help:

"After...

Dave - what I meant was - in the 350 rows that are incorrect, they both have the same values...but what about all the other (remaining) "right" rows ?! What...

Chiranjib - your understanding of data retrieval is not correct - read up on table scans, index scan & index seek and that'll explain how data is retrieved at various...

Who's Remi ?!?! <;-)

Gogula - sorry - here's a third person with same opinion - "not a good idea!"

psif someone held a gun to...

First do this to make sure you get what you're looking for before updating the table:

select ((col1 + col2)/2) as rightInfo

from table1

where info = wrongInfo

you say that you have 2...

You also don't mention if this is the only table that the employees "mess around with"!!

What kind of db backup plan do you have ?! You could try using differentials...

So if I understand this utterly nightmarish (employees have direct access ?!?! they update without specifying a "where" clause ?!?!) situation correctly:

1) Your change log table captures the old value...

Mike - very comprehensive and love the presentation - simple and direct!

If you do something like...(see below)...what do you get ?!

select su.name as username, so.name as tablename

from

sysobjects so

inner join

sysusers su

on

so.uid = su.uid

where

so.xtype = 'U' and

so.name in ('table1', 'table2', 'table3', 'table4')....

Jesper - I'm curious - did you get this to work & if so could you please post the solution ?!

I was just wondering if openquery was not the right...

Alright! Have you tried alternately passing the t-sql through openrowset instead - just to see if it makes any difference in getting the parameter across ?!