Y, I mean, afterall you're there to provide a service, and you can't provide it unless they tell you what they need. They're your customers, and name any other...

Try going into those component properties and selecting 'Delay Validation'.

Fair enough... I've been through such a thing many times and yeah, the best way to handle it is to get a list of rights/objects the devs think they'll need,...

You know, I've always been so displeased with the filesystem tasks I usually just bust out into script for these types of ops. It's so easy in .NET and...

Sounds like something is still trying to use these DBs. Are they in maint plans or are they the default DB for anyone? Maybe there are still some...

I agree with yann... they shouldn't be in there in the first place. And should you get audited, you'll have to show a good reason why devs are in...

Y, I haven't picked it apart piece by piece either. What problems are you having?

Y, I agree. You might be able to use another type of monitoring tool, but profiler will prob get you what you need.

Separating data and logs will really only improve performance if you've got the spindles to support it. In general you're better off having everything on a lot of spindles...

At this point you're using .NET functions.

Y, he's right. Derived Column is the way to go.

Y, it really just depends on how busy those services are going to be. There's nothing wrong with putting them on the same box as long as the box...

Here's a backup routine I wrote yrs ago. It deletes files. All you gotta do is switch it from deleting by GetDate() to DatePart... but this'll get you...

I can see how localhost would fail, but servername outta get it. Check that the machine name is what's also registered in SQL as local.

So select * from sysservers.

I don't remember RedGate having OLR, but Idera and HyperBac both do. Though I've talked to several people and Idera's OLR isn't getting good reviews at all. People...