Based on the numerus responses to my original post I have, I think, a better understanding of the compatability mode setting. As soon as my database was restored to...

Probably it's just a case that they haven't tested fully on SQL 2005 and hence won't support the product on that. Personally, I'd have some words with the company's support...

Gail,

Thank you for the quick reply. i did have a follow-up question about this.

I know that you can't make any guarantees about whether this should work or not but...

The whole Meta-Data process in SQL 2005 seems a bit over kill. I as a developer can appreciate the entent of control & options that SQL Server 2005 enables...

If a company isn't willing to sign a no-hire for X months, where they won't hire someone to do your job for that period of time then they shouldn't require...

I don't know about the delete option but each time I try to click the Delete link on the post, nothing happens.

One last question for all regarding this issue.

How do large organizations with VLDB's (Very Large DB's) far larger then my 100GB database, how do they hanlde this kind of situation?...

SSComitted - Thanks for replying. So far all my inquiries (not just here at SQLServerCentral.com) have resulted in this same answer. You either have to backup the log file...

Thank you GSquared

Thanks to all who responded. Since I first posted this, we have been forced (due to requirements of Microsoft's DPM software) to change from using the SIMPLE recovery model...

K. Brian,

So based on what you've quoted from BOL would you say that those conditions when a Checkpoint occurs are not RECOVERY MODEL specific so that my using a SIMPLE...

I've hit a roadblock that I'm hoping someone hgas some ideas on.

I'm versed in SQL Server's core DB product/service but am very new amd green with regards to Reporting Services....

If we use a view then we have to handle changes to the table be they UPDATES, INSERTS and or DELETES. This opens up a lot of issues because...

K. Brian Kelley (4/12/2008)

---

I'm not familiar with the product, but there are a couple of things it might be.

First, did anyone remove BUILTIN\Administrators or reduce its permissions within SQL Server?...

acrouch (4/16/2008)

---

I am having this exact same problem... SQL 2005 sp2, WinXP. For testing purposes, I created a totally empty ssis package except for an FTP Connection Manager and...