Thanks for the suggestion. Unfortunately I had already tried that and got the following error: Microsoft JET Database Engine error '80004005' ODBC--connection to 'SQL ServerServer-SQL' failed. Any Ideas ?
Yeah! very nice, kkeeffe...always appreciate someone using "While" loops instead of cursors. Below is your code modified to: 1) Remove @Rowcount variable and use "IF @@Rowcount = 0 Break" instead. It's cheaper. 2) Removed Delete statement and added Where clause "Where Len(Name_) <> 0". Also cheaper, as it's checking a condition instead of modifying a […]
We do use UDT either. I think it is better to use strong Entity/Attribute data modeling software and let the foreign key migration enforce the data conformity. For non-keys we use LOGICAL ONLY UDT but translate them to standard data types in the physical model. We use ERwin. It is a little pricey but I […]
I've never heard of a change of password having such an effect. Your Windows account didn't change at all did it? Eg. Account deleted and then added back in with the same name? Or maybe account moved to another domain? Cheers, - Mark
Here's one problem with your script: and Fname LIKE '%%%' First, this selects ALL data from Fname. Second, it overuses the %. Are you trying to get everything from Fname? If so, delete that line. Are you trying to get Fname where there are only three characters? If so, change the theree %'s to three […]