I do the same as Jeff, with a little bit more data: i save the filename, file size, and the CRC of the file in a database;

I do this because...

Rudy and David are right on target;

You KNOW it is only a matter of time before one of your developers runs an UPDATE or DELETE statement against production as well;...

id like to hear why they cannot use an identity column. is it because the application is using the borland BDE as the provider to the database?

the correct solution is...

multiple file groups are always recommended; I'm pasting a script to help you out with a tiny slice of it: after you've created multiple file groups, the script below can...

hard to track down; good question;

if a table is assigned to a filegroup, it stays within that file group.

if the filegroup is comprised of more than one physical file, when...

the identity function is smart....if there is a max value in your db with the value 1058, if you try to reseed with a value LESS than the current max...

normall, you just do ALTER TABLE UsersImport ADD userIdInt int IDENTITY (99,1) to start at #99.

with a variable, it's a two step process:

declare @C1 int

set @c1=99

ALTER TABLE UsersImport ADD userIdInt...

note that the log readers are great, but only work if your recovery model is set to FULL; if it is simple, then there's no log to read, and thus...

updated!

Thanks again for all the feedback.

Thanks to David Russell for pointing me towards the fix for some subqueries returing more than one row;that bug is fixed.

other things i did:

added functions...

thanks everyone for the feedback; some folks were kind enough to give me feedback on specific issues they encountered, so I'll tweak the logic to make it even better; my...

aww nevermind; you stated that it occurs every time; that shoots down the easy fix;

Greg is every connection, or just once in a while? if it is just once in a while, could it be something as simple as the db AUTOCLOSE being set...

the bugs are from the forum converting things like semicolon + close parenthesis into a winking smily face.

the code worked perfect when i posted it; it just got a but...

this might help:

http://databases.aspfaq.com/database/how-do-i-page-through-a-recordset.html

I've seen this before; it is caused by editing the name directly in Enterprise manager, and not via drop create/alter statements;

to prove it:

go to enterprise manager and find any view;

click...