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.

Is the SQL Server running as an adminsitrative account on the server? I think that is an issue. Hard to remember since I haven't used this in a long time.

It...

These come from different places and they can get out of synch. I think one is the registry and one if the file information.

North of 4million

I think you can learn enough without the book, but one nice thing about the books (any of them) is that the authors take the tests and so can focus...