You can test it in QA by running SP_setapprole, but that's not how users use it.

Your users still need to have a login/user on SQL Server, albeit with no rights....

I'd post this as a bug on Connect, ask for some votes (post the URL here) and see if you can get a good answer from MS. Or have someone...

Use the ms_foreachtable or just write a cursor that loops through the output from

select table_name

from information_schema.tables

where table_name like 'tbl_%'

This is a Windows error, and possibly a driver/hardware issue. I found a few references similar to this one: http://support.microsoft.com/kb/259573

You can read about it in Books Online, but as Kent mentioned, it's to handle objects that have names with quotes in them.

If it's a variable number of pages in the flow, I'm not sure what a good T-SQL solution would be. In fact, it might be worse than some loops. You'd...

Thanks for the notes and I agree with webrunner. Lots of us want to just add a server to distribute load.

Thanks for the RAC notes. I don't know a lot...

DST kicked in on Sunday in the US, which is how the servers work.

I think that the rest of the world might have a different DST date.

It is ultimately management's responsibility to find a balance (and yours), but having been through some long negotiations when selling this site, I'll tell you that it's hard to be...

I've actually had some reasonable NCAs, especially when negotiating with management. My experience has been the lawyers typically present these worst case scenarios, and end up trying to get things...

Detaching /Attaching on the same server will not orphan users. The users are mapped to SIDs on that instance, so as long as the databases are attached to the same...

Look up patindex or charindex in BOL. Perhaps SOUNDEX would work as well.

It seems some of your terminology is mixed up. There isn't a "Users" group on the server, unless you mean the OS, in which case, specify that. However the user...

The only way to test the backup is to test restore it to another database. You should periodically, perhaps monthly at least, restore a database from a backup that is...

Maybe someone here wants to write one and open source it! Or make an article. 🙂