Try changing the provider to SQLNCLI.  See http://www.connectionstrings.com for lots of connection string examples.

I ran across a way to generate the numbers list in Itzik Ben-Gan's book "Inside Microsoft SQL Server 2005 T-SQL Querying".  Itzik is a genious, and I highly recommend his...

Enter CTRL+ALT+X to enable the Toolbox window.  

Make sure the "Report Items" section is expanded.

If you still see no controls, right-click in the toolbox and choose "reset toolbox"

Some errors are not handled by TRY/CATCH.  If you have an invalid object or column name, the batch will fail and the CATCH block will not execute. 

One thing I learned when networking with other DBAs at the local user group or PASS is that there is always someone who knows more than I do about any...

I played around with linking to Exchange through Access and noticed that there was a checkbox at that point that allowed you to save the default profile.  I assume that you left...

LDAP can be used to pull information from Active Directory and Exchange. CDO can be used to pull information from Exchange.  Basically, you would have to write a script to...

You will need to write a script using CDO or LDAP to get the Exchange data.  It is not necessarily easy to learn. You can search the web for sample...

It sounds like you are using Access to link to Exchange, then pulling the data into SQL Server through Access.  There are other ways to get Exchange data, like using...

If the job is disabled, it shouldn't automatically run.  Could someone have started the job manually?  Or, is there another job or stored procedure that starts this job?

Ignore that last post.

Look into "Instead of" triggers.

In SQL Server 2005, you can do this:

1. Create a new database role

2. Add the user account to the role

3. Using SQL Server Management Studio, expand Security, Schemas under the...

It you want to automate it, create a SQL Server Integration Services (SSIS)  package to do the work.  You can schedule it as a job from SQL Server.

what is the error when it opens from the switchboard?