Posted by Greg D. Moore \(Strider\) on 11/28/07 03:28

"Tony Rogerson" <tonyrogerson@torver.net> wrote in message
news:figb7m$gpp$1$8300dec7@news.demon.co.uk...
>> CREATE TABLE FOO
>> (
>> FOO_ID int identity(1,1),
>> Server_name varchar(20)
>> )
>
> Just get them to do this....
>
>> CREATE TABLE FOO
>> (
>> FOO_ID int identity(1,1),
> Server_name varchar(20) ----> UNIQUE <-----
>> )
>
> Then all is well, well it would have been if they are started out properly
> in the first place.

Unfortunately, on my list of things to fix, this isn't the highest on the
list!

(and just found a case where the Product team WANTS the "Server_name" to be
non-unique. It makes absolutely no sense to the developers or me, but
that's a fight for another day.)


>
> Tony.
>

--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

• Next in forum: Re: ORDER BY AND GROUP BY CLAUSE
• Prev in forum: Re: SQL Server moving to larger drive
• Thread view: Re: SQL Express - Identity specification property - how to change

[Reply to this message]