Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Query to find rows with upper case characters.
Hi all. I'm using SQL Server 2000 and have a large table with a varchar field containing email addresses. I need to find those rows whose email address any upper case letter in any position in the address. Other than running a query for each upper case letter is there a better way to find such...- fal762
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
Still Yet Another SHRINKDATABASE Question
Hello all, I am trying to reduce the size of a SQL Server database after a major purge of old data. I have tried using: DBCC SHRINKDATABASE (<db name>, TRUNCATEONLY) And the result is the message: Cannot shrink log file 2 (<db name>) because all logical log files are in use. (1 row(s)...- fal762
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
-
Looking for structure of an Access 97 mdb file
Hi all, I recently inherited mainainence of an Access 97 mdb that consists of several dozen macro, several dozen queries used by the macros and several dozen import load mask specs. There are no forms or reports but a few tables without data that the queries reference. Data from an upstream...- fal762
- Thread
- Replies: 2
- Forum: Microsoft: Access Other topics
-
Returned Structure Reference Problem
I thought this would be easy. All I wanted to do was to return a struct pointer instead of a char pointer from a function. The idea was that instead of listing numerous parameters when the function was called I would have all the returned values put into a structure and just the address of the...
