one drawback of using identity columns as primary key is that all inserts go to the end of table, and last page of course. so when multiple users try...
a bettre way generate an integer random number by RAND function and then SET @@ROWCOUNT @Rnd SELECT * FROM RandTable ORDER BY NEWID() SET...
how do you find out there is a SHARED LOCK on the table? I might have some suggestion.
if other users have EXECUTE permission on the functionn they can use the function. but if your function create a real table (sorry for the term real)...
maximum size of a record in sql rerver 2000 is 8060. but you can virtually create a table with a record length more than 8060. if you have columns...
Separate names with a comma.
