Viewing 6 posts - 421 through 426 (of 426 total)
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...
March 17, 2005 at 11:45 pm
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....
December 15, 2004 at 11:05 pm
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,...
September 19, 2003 at 9:33 pm
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...
September 17, 2003 at 1:29 am
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...
March 26, 2003 at 1:03 pm
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...
March 24, 2003 at 11:31 pm