The point is that you don't always have the luxury to take a full backup every 5 minutes like you can a tlog.

Also with a tlog, you can do a...

System table are out of range for such processes. It could be done in 2000 but it was extremely hard, hazardous, dangerous, at best. Not to mention that...

I didn't have an idea about binaries untll about 15 months ago... this was not thaught in my school. Not for sql anyways.

I'm just moving to 2k5. I don't consider myself behind... but I know I have a lot to learn on 2k5.

Pass certainly helped get back in the game in...

Just run that procedure after the code that runs the restore has done executing.

Thanks for sharing this. But as someone who's read a lot about your past work experiences. I strongly suggest you watch the movie The Secret. That could...

Best practice : ALWAYS mention the columns in the insert statment. You'll save yourself a lot of troubles.

So under what name will we see you from now on?

This is too funny... so much for that print statement :hehe:.

Just for the ones who never had this problem... what he did is enter something like this :

01/01/2007 instead of '01/01/2007'

The net result is often a date damn near...

You need to get that info first or you'll most likely have to rebuy a server after the initial one... or you'll overshoot the needs of the client and buy...

Steve, is there anyway to have the posts written to cookie BEFORE doing the postback? That way if the session timesout, the cookie can be read and the answer...

One last comment : After the data is in read-only mode (can't ever be modified ever again). You can move that data onto its on filegroup, do you thing...

Open Query Analyser (QA), hit f1, type hint, enter. Read. Thank you for doing that before posting a question here.

This is presentation stuff. In the best circonstances, this should be handled by the application layer. If not possible in this case, then use the replace option.