Nope... glad to see someone else thinks the same thing, Jacob.

You don't like the idea of SELECT 1 instead? 

Heh... nothing breaking is good

Good catch, Lowell...

I've seen it where the view totally recalculates for each individual update... kinda drags performance down a bit

And, Peter's fine method works not only for single variables, but for a whole table, as well.

SELECT (ABS(CHECKSUM(NEWID())) % 10000) AS RandomNumber

FROM Master.dbo.Syscolumns

Nicely done... but, what if it takes 6 numbers to make the desired total?

Yes... don't allow developers to have access to write to production machines.  Works for us.  Create a new server with snapshots of the production box and use that as the...

Heh... forget PayPal... UPS will ship a keg

I don't have access to 2k5, yet, Michael... did they keep the information schema views named the same way?

Heh... yeah... Just look for anything that uses MAX(somecolumnname)+1 or @@IDENTITY in the code.  If the aren't "in sync", it'll cause Primary Key violations which is the error you're getting.

Also,...

I'd also like to throw my hat in the ring with the others that expressed some disappointment in certs... or rather I should say in some of the people that...

I like that answer, Rudy!  My similar favorite is "I don't know, but here's what I'm doing to find out!".

DateTime columns have no format... the dates are actually stored as a special form of FLOAT (BOL says 2 INTs but that's not quite right).  Changing the column to a...

I don't use Power Builder so this will likely not be much help... but, if it were me, I'd select 1 column at a time to troubleshoot which column is...

You cannot use a column name as a parameter for a table valued function.  From Books Online...

Multi-statement Table-valued Functions

CREATE FUNCTION [ owner_name. ] function_name

    ( [ { @parameter_name [AS]...