November 5, 2002 at 5:46 pm
How is it that certain application, particularly MS Project, keep data in a local database? How is the sql server agent involved in this?
November 5, 2002 at 5:52 pm
This is a design thing usually, what exactly do you mean by keep data in a local database, it is usually an Access database, other vendor DB, or some other proprietery thing for the app. Not sure unless it does a psuedo replication process back to the local database or similar???
November 6, 2002 at 10:20 am
SQL Server Agent is the equivalent of the NT Scheduler or the W2K Scheduled tasks. It performs things for SQL Server based on it's configuration.
An application can store data in a database (as Antares mentioned), which is a file. A formatted file, but still a file. You could easily store data in a plain text file, like the old INI files. Database are usually optimized for access, storage and retreival.
Steve Jones
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply