You guys have too much time on your hands.

Quoting myself :

"Also I feel I must mention that this presentational stuff should be made at the client."

.

It's rare that I don't... but that happens too .

You'll have to start the profiler and run on trace based on his login. But this will have to run for all the time he's in the office. ...

Frank, Rob. I'm not sure you got exactly how the update is working (unless you're keeping it to yourself). You're right about incrementing a value, but you're still...

Why can't you create different stored procs for different update statements?

Time to go to bed... and still no correct answer.

Maybe tomorrow morning .

Wouldn't it be nice if we could just do :

ALTER TYPE [dbo].[city] FROM [varchar](50) NOT NULL.

Is it because it's impossible or not recommended to do so?

Unless you logged the searched, or the results, I don't think it can be done.

You could always use a log reader but then don't log selects so I doubt that...

R u trying to remove duplicates from the data, or are you trying to find the primary key?

Thanx for the tip... Will try to test that tomorrow.

God I'm slow tonight.

Just remembered that one of the unique indexes in SysObjects is :

Name, Owner (always the simple little things that trip you up).

Michael Du Bois :...

Took me about 3 minutes the first time to write it. Then I lost the code and retried to write it. Guess what, it took over 30 minutes....

Ran fine on mine too... I'm anxious to see how I can make it fail now .

So what did you think it did...

Hehe.