Yes it's syntaxe only... but I preffer the read something that looks like an inner join. That way I can't miss the 2nd table in the query... But...

Nice variation... first time I see it.

Here's the kicker...

Compare colid to colid2 .

I know it's not perfect but the syscolumns handle the colid in strange way in functions and...

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 :...