Maybe... but I think he has better things to do .

How do you suggest to implement that with unlimited and unknown amount of Population groups?

BTW you might want to change your login credentials now .

Wasn't me !

If you can't alter one of the columns, then you have to enforce it with a trigger.

Why not use an identity column?

You can always use something like this... but you must lock the table for inserts when you do this :

Select @MyNewID = ISNULL(MAX(IdCol), 0)...

Damn, did I just fix it or did somebody else deleted/edited a post???

It's happened before... it's most likely and unclosed <table> statement that is causing this... nothing to worry about .

One thing you can do is this :

DECLARE @cmd VARCHAR(5000)

SET @cmd = 'OSQL -S support-ts2 -dNCL_REMOTE_SP6D '

    + ' -Usa -Pseaward'

    + ' -Q"select notes from...

Please do not cross-post, we monitor all forums.  Continue this thread at this URL :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=306209

Works well for me... maybe it's just an html formatting problem .

Thanx for the info... I'll keep that in mind when I'm asked to do that .

Woops... 7,2000 not 2005 .

Sounds like you have a problem with IIS and not sql server itself (unless you are missing permission to do inserts/updates/delete from a remote server)...  Just throwing ideas in there...

Sounds like a lot of work... it's not... it's just a bit different, the Developer's are going to pitch a real bitch at first, and it will save your database...