Thank you very much...

It's easy and usefull...

Brandie Tarvin (11/5/2009)

---

One by one? Ah, you need to be more creative. @=)

If you can only "fix" certain users, try putting the specific logins in a table on a DBA...

Brandie Tarvin (11/5/2009)

---

You're going to have to write up a script.

The way I do it is to have my restores created in jobs. After the restore step, I have...

Piotr.Rodak (11/4/2009)

---

Hi,

Just curious - do these developers and programmers have db_ddladmin role membership on production system?

If they use Windows authentication, the sp_change_users_login will not work.

Maybe permissions set on production database...

Piotr.Rodak (11/4/2009)

---

Hi,

Just curious - do these developers and programmers have db_ddladmin role membership on production system?

If they use Windows authentication, the sp_change_users_login will not work.

Maybe permissions set on production database...

I understand an agree perfectlly with your point...

But... now.. the problem is installed, I have to correct it... and I think, I should not do it looking for...

K. Brian Kelley (10/7/2009)

---

Totall agree with Lynn here. You'll want to make sure the objects don't belong to an actual person. Probably need to institute that as a standard in...

Hello Everybody...

I got my problem solved by using the stored procedure sp_validatelogins

Thank you very much

CirquedeSQLeil (9/18/2009)

---

One more thing to try is to check your ansi_warnings setting.

Try

set ansi_warnings on

execute your proc

If you get an error, then reverse the setting. And then add set ansi_warnings...

Remembering...

the Error only happens when I run it using a JOB...

CirquedeSQLeil (9/17/2009)

---

When you execute it manually, does it produce any warnings?

Also, are there any other inserts happening inside this proc?

Lastly, inside the sql agent job, what is the command you...

The commands you've posted previously, was already in the procedure...

the...

No... It isn`t a SSIS job...

follow a part of the code

declare @v_Max_Lote int

declare @r1_cd_serie_doc_transporte int

declare @v_ini_faixa numeric(18,0)

declare @v_fim_faixa numeric(18,0)

set @v_Max_Lote = 977

set @r1_cd_serie_doc_transporte...