plenty of example scripts on this site you can tweak to meet your needs

try this one

http://www.sqlservercentral.com/scripts/permission/76841/

Can I assume you followed the steps listed in this article?

http://blogs.msdn.com/b/farukcelik/archive/2010/06/04/accessing-excel-files-on-a-x64-machine.aspx

I am also having this issue with 2008 SP1. I can add users but not groups.

it looks SYNONYMs may be my best bet for this as you can create then via script for each environment. You can create a "short name" for each table...

can you explain further about the login script method?

You can have an active/active you just have to give them unique names. You can have one default, sort of, instance with no instance name.

so instead of:

MACHINE1

MACHINE1\instance1

MACHINE1\instance2

you'd have to...

this returns the details of the SSMS report. Not formatted as nicely unfortunately

USE MASTER

GO

exec sys.sp_help_log_shipping_monitor

Oh no, you said "kerberos". :w00t: I was afraid of that when I noticed no authentication was being passed but I was hoping it was something I could do differently...

different accounts in the same domain group. the domain group is a sysadmin on each server.

This is still 95% his code but I modified it a little to work with databases that have schemas other than DBO. It also uses the newer 2005 tables...

This is an example using the PatIndex. I believe it's just one of many options but will work. Just add this WHERE Clause to your statement to return...

This one walks through each database, non-system, and changes the owner. You should simply see a list of your databases it executed against in your output.

I would...

I agree you should know your application before you do this. In most cases this should not cause issues especially using SA. That is unless you have SQL...

Free version here:

http://www.microsoft.com/downloads/details.aspx?familyid=08E52AC2-1D62-45F6-9A4A-4B76A8564A2B&displaylang=en

I have received this error twice in the last couple months. I also could never track down a root cause. The only thing I noticed is my server...