I think the best way to set security in any database is create (or use SQL Server) roles. That way you just create the user and assign the new user...

Thank you. I did that already. The script worked perfectly for any other string, but GUID. Here is the exact location of the script

http://www.sqlservercentral.com/scripts/contributions/831.asp

I used this one to create...

Sorry guys, I meant asc for ascii, not "as c" as I typed. my mind sometimes works faster than my fingers!!!! Thank you very much for your input.

Thanks Phil, I modified the script before I post it, but the basic lines are there and not it is not that sensitive. Is just some data we want to...

Hello. I had a problem with the most recent hotfixes from Microsoft (it is not the same problem you had, but I just wated to mention what happen to us)

We...

Thank ypou for your input to al of you. I get the files via FTP from offices around the country, then the files are moved to the data server (SQL...

Maybe this can help a little. I did run into similar issue a few weeks back.

First the error message you are getting is for each record SQL Server is trying...

Thanks to all. I will try those solutions first. I think that solves the problem, but I need to test it and pass it along to the developer. Thank you...

Thanks Shaji. Recording the changes via SQL Server is not really the problem if the users is using an account (windows or SQL Server) the problem is how to write...

Thanks for your input. I will try that now.

Is the job a DTS package? or is a regular maintenance job? If DTS, you can set a log for the DTS which track every step of the package and...

Thank you guys!! with all your input I solve the issue. I used a combination of your sugestions and it works perfectly. Thank again!!