:), whoops.

not implying developers are not people, but you need a person that is not a developer.

I can appreciate their dedication to VB 6, but that's part of why I suggested SSIS instead of going with BCP or something else. It's a programming environment, and sometimes...

Ted,

Thanks for the update.

http://www.sqldts.com/204.aspx

Is this data queried in real time? Any reason not to move to a more structured procedure like SSIS? If they can load 1TB in less than an hour, doesn't...

Uh oh....

I've had people suggest chiropractors, but I used a couple years ago for my neck and didn't think they helped.

Acupuncture helped my legs a couple years ago. If this went...

They should support the restore of SQL. not the application, but the restore process.

It's more than services, there are registry settings along with the proper paths for files. If it's...

Can you switch Agent to your account and see if it executes?

I'm not sure, but I pinged RG support here.

I would suggest you look through the error logs to determine why it was marked as suspect.

Actually what I'd suggest if you call BackupExec and complain to them. It might be something simple.

I wouldn't necessarily uninstall and reinstall SQL, especially as I'm not sure how to...

There needs to be controls on the production data. If it must be used for testing, and sometimes it must be, then it needs to be controlled, and you shouldn't...

Each set of permissions needs a different role.

If you need 20 people with read/write and 20 with read only, you need 2 roles.

A user can be in multiple roles, and...

I limit their ability in development. The reason has been to ensure that change is controlled and the don't make sweeping changes that cause a halt to development.

I would give...

What is the question? Is it Configuration Manager or model? You've put a lot of information in the post which doesn't make sense.

It sounds like you don't have the proper...