I ran this:

exec sp_change_users_login 'Report';

and it returned nothing. Not sure what that means.

Sadly, the detach/reattach thing was not an option this time. Long story.

I will try the SP. Thanks.

I don't generally bump things, but since this was posted late on a Friday night and has no replies, I'm hoping that a Monday mid-day bump will help things.

thanks in...

In which field, though?

george sibbald (8/27/2009)

---

This can happen if you have orphaned users and try to use the GUI, it gets confused. Usually works fine via query window so run all your create...

A couple of problems with that:

1. The users didn't exist in Master until I ran that script which told me they were already in existence.

2. When I tried to drop...

and just as important, why would redgate generate code that doesn't work?

Yeah, that's what I meant. I checked in both the security section for the desired database and the main security folder.

Having said all that, I just discovered they are in...

AAAAAUUUUUUGHHHHHHHHH!

It's OK if I yell here, right?

Sorry, I am inheriting other people's code and totally didn't catch that there is a temp table and real table with almost the same...

I'm sorry for causing confusion. I have several of these jobs. My question was about the # signs, so I copied and pasted the particular one I had highlighted at...

But that wouldn't explain why this thing works just fine on the old database. It runs successfully every morning.

That...

bitbucket (7/31/2009)

---

You might want to look at this freebe from Microsoft:

Log Parser 2.2 available from:

http://www.microsoft.com/downloads/details.aspx?FamilyID=890cd06b-abf8-4c25-91b2-f8d975cf8c07&displaylang=en

Microsofts description

Log parser is a powerful, versatile tool that provides universal query access to text-based...

BenBooth (7/31/2009)So basically if the command was a sql injection attack unless you log the commands sent from the web app somewhere and can tie those commands back to session...

These are all great suggestions, folks! Thanks very much!