I agree with Dave, script the DB changes, document the changes, have QA review the docs and scripts, and finally test the deployment scripts on a copy of the production...

The trouble with IN clause is when the subquery returns NULL you then get all records. Not critical when you use it in a SELECT, but trouble in a DELETE WHERE clause....

The syntax for linked Jet4 ISAM linked server is probably the issue, try:

SELECT * FROM PDMdBASE...ATAB

Basicly you have to use the 4 part table naming, and for Jet ISAM databases,...

Thanks for the reply Steve,

The measures are also complicated, basicly each Question (text string) can be of a varying type, some are: single Option selections (option button), multiple choice (check...

Trying your original code, I think I have found a flaw in the sp_helprotect stored procedure! My setup is to never grant database level permissions for any login or...

I found that for a service pack 3 install failure, if I ran the sqlredst.exe from service pack 3 (it is a silent install), then rebooted the server, I could...