Just a thought if your company wrote/controls the application source code. This functionality could be added to a screen so that authorized people could add users (which adds them...

To upgrade from standard to enterprise see http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_install_1d7y.asp

SQLEM is not designed for repeatable safe processes. I know you said you don't want a "Don't Use SQLEM kind of answer" but if you use SQLEM for copying...

I have removed guest from MSDB on all servers excecpt one. On this one a third party application is running that submits jobs on the user's behalf and it...

What if you removed the BEGIN TRAN and allowed SQL Server to commit prior to the update. Or at least moved the BEGIN TRAN after the DROP TABLE statement?

...

Randy's idea is interesting. Although ultimately I don't think the db fixed roles are very useful within the context of an application. They are fine for administration but...

Hmmm.

I noticed the UPDATE refers to prcore.dbo.blpu_load while the INSERT refers to the unqualified blpu_load. When you execute the stored proc check you are pointing to right db...

This sounded ok to me so I tried it and got the same error you did,

I then created my own role and found I could add members to my role....

Not a good situation.

You need to take control. Restricting the use of 'sa' is a question of security, especially with multiple people using the account. If you audit your...

Is security set up so that users have write access to the actual tables? (db_datawriter or db_owner) If so can this be changed so that all write access id...

The different behavior has to do with the different collation sequences. To see what the collations you defined are run:

SELECT * FROM ::fn_helpcollations ()

WHERE name = 'Latin1_General_CI_AS'...

Look at the table definition (from Enterprise Manager, right click on the table, select aALll tasks, Generate SQL Script. Make sure the id field is like:

CategoryID int IDENTITY (1,...

I assume you mean that the drop down box on the ODBC data source administrator called "Which SQL Server do you want to connect to?" isn't showing the SQL...

Yes Jennifer, we often have ids that only have read permission, while others can read /write. The best idea is that no one but the DBA has access to...

Matt1: Its hard to know what you want because you are not using the correct terms. I assume when you say "binid is the row name" you...