Thank you all for you input.

JamesNT

Sean,

Thanks for the article. But I'm asking for YOUR opinion on what has helped YOU the most.

JamesNT

Excellent. Thank you!

JamesNT

I'm leaning pretty heaving towards having the table and a web page so users can update it. That seems to be the way to go. Poling a table...

Chuck,

Can you offer a possible scenario on how Service Broker would do this?

JamesNT

Lowell,

why involve end users to start the job?

you could have a regularly schedule job that checks newly entered data every x minutes, and sends an email to someone if...

LOL!

We have an issue where after data entry, certain fields need to be verified. I was hoping to create a SSIS package that end users could invoke...

We created the views in order to allow us to change the underlying tables. We are hoping to better normalize this database as time moves on but the application...

I think I've got it. I'll post details as soon as I get a few free minutes as this may prove useful to others.

JamesNT

I just created the linked server. Under the SQL Server Management Studio, I can see all the folders under the PDM fax folder as tables.

Now I just have to...

Thank you for the response. I just figured out that my connection string is completely wrong. It should be

file:\\.\backofficestorage\mydomain.com\public folders

Looking at the folder view from Outlook, directly under...