Ya learned that the hard way...

Installed the full evaluation version over express but the profiler didn't get installed.  Tried uninstalling the tools and reinstalling but that failed too. So I uninstalled...

Sorry to kill your groove, But you either to that check before the insert in a stored proc or in a trigger.  The simple constraint checks just can't handle that...

I'm certain it queries sysobjects but I never saw the query so I'd just be speculating at this point...  But as long a syour query works now

Couldn't find anything out about that... but that was the only thing I could see that may have a chance of screwing something up.

I'm saying that when you're presenting the data like in a asp report.  You can manually add that counter with a variable.  Isn't this option available to you?

Did you check in tempdb.dbo.sysindexes?

hmm, maybe this...

Why can't you simply add the counter in the application when displaying the data?

Damn, I'm still to green to understand that joke .

How about someone provides some oracle solutions while I come up with the Access 2K version?

This is for the evaluation version of 2005... I assume they'll be there too in the "real" version.

This is the management studio link.

"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe"

That'll take too long.. The longest threads here have gone far in the 100s so I got other stuff to do .

I never came up with this problem.  What query have you come up with and what is the problem you are encountering?

The only problem with that solution is that if a number is written like this abc012, your query will return abc12.

That's why I wrote mine that way......

Select dbo.FunctionImageNo(@CustomerEmail, @CapNo), Cola from ...

However this would result in a cursor like process.  In this case...