Thanks for the note Ron; it was my understanding that we were very lucky as volunteers to get invited to the dinner and that generally the volunteers are not invited,...

I've founnd that the delimiter is not passion but self confidence. It takes more self confidence to say "I don't know, but I'm willing to find out. Will...

I've inherited the role of DBA from time to time, although never officially. I've always tried to balance the "best practice" approach versus what makes sense at the time.

I...

I'm not familiary with sp_makewebtask; what does it do?

I'm not familiar with Reporting Services, so I can't comment on the merits; however, if you are using it successfully then I would be interested in your experience.

One aspect of...

Seth,

take a look at the second post in the string; there is a great link to an article that shows how to create an HTML email, and it would be...

Seth,

I'm not sure about Blackberry's support for HTML ( maybe someone else could comment ).

For this specific solution, the email is built only of text, so no HTML tags are...

Its remarkable; once a user gets a taste of data on their berry, they are hooked. 😉 Its really a unit of work to reward issue; to get...

Jon,

I think it is good to have consistency in where your users go to get their data. In my case, pushing the data to the execs was an add...

Jeff,

Thanks for the feedback. I had meant for the title to be a "grabber", but I honestly had taken the ability to send email ( have it setup and...

Tony,

Great link! This would make a great addition. That also answers a very long standing question I've had; specifically, how to send emails as HTML from SQL server:...

Paul,

Regarding changing your front end to something other than Access, it is going to depend on two factors:

1. How much time you have to convert against how many forms and...

OK, I have a solution for you. 😀

This script will automatically handle generating the SQL statements to clean up your tables and foreign keys.

There is a table variable called @WorkingList...

Where you have that exception some logic can be run to find possible matches and a human will have to interceed for those; with those exceptions, the names will match...

rhcomputer:

1. Grasshopper is the rank on the site; the username is metawizard2 😀

2. Other way around:

What is common among the user records that you can hook on?

In your first post...