Viewing 15 posts - 38,026 through 38,040 (of 39,456 total)
February 12, 2002 at 3:08 pm
Can you provide some more information?
If you are receiving the "call to sqlmaint.exe" failed, I get this on some things and haven't found a solution, other than to not...
February 12, 2002 at 2:17 pm
Nice article with good examples. Personally, though, I have a rule of thumb: NEVER use dynamic SQL. That being said, I have used it in places, but only when I...
February 12, 2002 at 12:31 pm
Nice article. I too tried this last year, but was a little ticked that I had to use a cursor to get this info. This should be queryable for all...
February 12, 2002 at 12:26 pm
February 12, 2002 at 12:00 pm
Rule of thumb:
February 12, 2002 at 10:55 am
February 12, 2002 at 10:47 am
Can you post more information. This doesn't really make sense. Version of SQL, what tasks? code for the tasks? etc.
Steve Jones
February 12, 2002 at 10:42 am
Not sure what you mean. What is a connectoid? Where is the data? In SQL Server?
Also, what version of SQL are you using?
Steve Jones
February 12, 2002 at 10:33 am
Haven't really developed any as of yet. Be interested to see what you come up with.
Steve Jones
February 12, 2002 at 10:31 am
You can also query information_schema.tables.
Ref:http://www.sqlservercentral.com/columnists/rsharma/informationschema.asp
Steve Jones
February 12, 2002 at 10:11 am
Antares686 has a good suggestion, but you can just apply multiple UPDATE clauses using the WHERE clause for each case. This might help.
Alternatively, you can use a second column that...
February 12, 2002 at 10:07 am
It's not a total waste, and I agree with Andy. Obfuscation does help. Lots of people are lazy and won't keep trying if the easy thing doesn't work.
However, keep in...
February 12, 2002 at 10:03 am
Is this a production site or dev site? If it's production and the db changes, why not get some log backups? Even in Dev, we've started some log backups. Once...
February 12, 2002 at 10:00 am
good advice above. One side note, I had a freind that had some issues when fully populating a motherboard with an AMD processor. Probably not applicable to this site as...
February 12, 2002 at 9:55 am
Viewing 15 posts - 38,026 through 38,040 (of 39,456 total)