Recent content by datamat

I appreciate all your feedback. SQLSister hit the nail on the head with respect to payroll production data. I was hoping there was an alternative that permited a db_owner to control access outside the sysadmin's span of control at the database level. Thanks ALL!!

Using SQL Server 2000. We want to restrict DML access to the data in a particular db from sa. Yet, sa is granted sysadmin privs across all db's on the server. Can these privs be restricted for sa or any other sysadmin on this one db or does the db have to reside on a separate server...

Using SQL Server 2000. We want to restrict DML access to the data in a particular db from sa. Yet, sa is granted sysadmin privs across all db's on the server. Can these privs be restricted for sa or any other sysadmin on this one db or does the db have to reside on a separate server...

How can I remove sysadmin privileges from the sa account? Or, assign another account sysadmin and deny sa access to certain objects on the server?

I want to set up a restricted access instance of a SQL Server 2000 db on a common server. If I had my own server that I could dedciate to this one relatively small db I'd set it up locally and be done with it. Yet, if I need to set it up on a common server, by don't have the luxury to set...

If you are inclined to spend a little $, You can get a low end ETL such as Data Junction to do this quite simply. It's not a free solution but it won't cost much either. I scan download an eval copy from their site. It will read EBCDIC code pages and unpack packed decimal, comp-3 type data.