Or use Truncate instead of delete.

Loren,

Great questions and I have no idea. We haven't gotten into the "review" process and I haven't heard of any censorship of the forums. AFAIK, I'm the only one administering...

Not sure about RHIE, but a friend got his CCIE a few months ago. He had to take a written test, a long one and then had a year to...

Aw, thanks, Steve

Where is the server located? Is it local or remote?

This is a connection problem. You can check the machine where SQL is running and see if the service is...

There's one here now: http://www.sqlservercentral.com/forums/messages.aspx?forumid=334

Be careful what you write.

Log PI from Golden Gate, Log Explorer from Lumigent, Apex Log from Apex, or Log Rescue from Red Gate can help you out if you save off the log backups.

select vehicleid, max( renewdate)

from licenses_renew

group by vehicleid

If you need trans id, wrap this in a select like

select transid, vehid, renew

from (select vehicleid, max( renewdate) as renew

from licenses_renew

group...

do you mean

- perform update 1

- perform update 2

- check for error

if error, undo updates 1 and 2

if not, do nothing

- do update 3

continue?

If...

small company or "old" application. seems like as they age, more and more people get rights to do this stuff.

I'm a "DBAs only" for schema changes. Developers can run them...

Thanks again for the comments. Rest assured everyone is looking these over and they will be considered before anything is changed.

The email list is now in fact Red Gate's and...

Thanks and you'll still be able to express opinions. I think having a vendor section in the forums is a good idea and I'll work on getting something setup for...

Thanks for the comments and I definitely have some things to think about.

I'd like to see more reviews, but they're tough to do. The only way I can be sure...

Subjects maybe, but the others aren't necessarily worth the join effort. From/to come from a table with lots of data as well. And this way the system can be...

Use a table to store your periods/dates/etc and join with it. That should get you a long way there.