you are welcome and thanks for the update.

I think there's a lot of confusion out there and different rest results.

http://www.baarf.com

Go with R1. It's better at everything.

Hate to deviate, but apart from what's put down already, both Windows and SQL auth suffer from the problem that anyone can connect with any application and access the data....

It won't necessarily cause performance problems. While I like dedicated SQL Servers, depending on the resource usage by SQL Server and by the other app, and your hardware, they can...

I'm assuming you know something about clustering. If you don't, then you probably should hire someone (consultant) that does. Asking a general question like that concerns me. If you know...

OK, check under the SQL Server, Security, Logins folder in Management Studio. Is this user listed? If not, that could be the problem. I'd expect to see the domain listed...

and where right(string,1) = 'O'

I haven't gone through Daryl's logic, but i'd be thinking of something similar. With complex logic like this, I'd probably break this into multiple steps.

Is this run constnatly or...

The problem with floating trial balloons to gauge interest is you're never sure who sees them. I happened to have someone point this out to me, or I'd never have...

Rebuild the clustered index on the new filegroup and that will move the table.

I think that's "if your friends jumped bridge..." 😉

It can be done and it can work, but it has to be done right. I've seen people try to move their...

Very strange. Have you tried a Profiler trace to see what's happening here? Maybe limit to the SQLAgent user to see if that's the one calling this?

I'm not sure this is worse than a linked server (or opendatasource), but I'm with Jeff and I'm nervous about allowing this.

If you enable it, use your judgement, be careful...

If a tree falls in the forest ...

Kenneth, I think you're splitting hairs. It's not enabled, meaning able to be used until you reconfigure.

Wow, 14 days is a lot, but if you need it, or feel comfortable, then use it.

If you are post SP2, then the maintenance plan has a checkbox for "first...