Viewing 7 posts - 16 through 22 (of 22 total)
Sure. Did you get a zip program which accepts DOS command lines?
Have you created the table to hold the data from the CSV file? You will also need to create...
July 4, 2004 at 1:11 am
I don't have the code at my fingertips, but I know how to approach the problem (sounds like a job interview, right?).
You can cycle through the collection of DTS packages,...
May 7, 2004 at 3:25 pm
Here's the Outlook part. Put this in the ThisOutlookSession class (open Outlook, hit Alt-F11, hit Ctrl-R, expand Microsoft Outlook Objects, open ThisOutlookSession).
This reviews your inbox every time a message...
April 20, 2004 at 4:05 am
There might be a few ways to structure this. Off the cuff, it seems that you might do well to do some Outlook Automation inside of Outlook first (using VBA...
April 19, 2004 at 12:18 am
Stan, you say:
"To conclude...the code for selecting the records I am more than happy with...the problem I have is that the output is in many 'recordsets' and I only...
April 17, 2004 at 11:01 pm
there is even a view of databases: INFORMATION_SCHEMA.SCHEMAS
April 12, 2004 at 11:03 pm
You can do the same thing using the INFORMATION_SCHEMA VIEW. The syntax would be:
SELECT CATALOG_NAME
FROM INFORMATION_SCHEMA.SCHEMATA
Supposedly the system tables could change in a future release of SQL Server, but the...
March 25, 2004 at 8:02 am
Viewing 7 posts - 16 through 22 (of 22 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy