Do you mean the account SQL Server will be running under or the account which will be used to INSTALL SQL Server?

For the account that you will use to run...

I'm pretty sure that users will only be able to see tables which they have access to, but I'm not sure. I typically do not grant direct table access...

Actually SQLSaturday is NOT a Florida only thing. There have been SQLSaturday's in Washington state, Alabama, and I...

Forget about missing a session by Steve Jones, you missed the opportunity to hear a session by Jack Corbett (of this post):P.

Hey, I wish you had made it to OPASS...

You can go to PASS to find official chapters of SQL Server groups. You can also find out by finding your areas Microsoft Developer Evangelist which you can find...

Probably the easiest way to do it is to create a calculated field in your dataset using the expression you already have and then putting it in the report both...

This is why I keep asking you to go get the Custom Component I posted. I included the source code which fixes the problem with illegal characters. I...

If you have data that has single digit months or days 1 instead 01 etc... you need to use this format:

"M/d/yyyy"

This will work with either 1/1/1970 or 01/01/1970 or 1/01/1970...

Those are all available to the user in SSMS as well, they are just found in the Views section and Access is showing them as tables. Those are available...

When I run it I get an error against DB's in 2005 mode, but it runs fine if I change the compatibility to 2000. So it is a change...

I don't think it matters. I think most SQL Server folks use decimal, but from what I understand they are handled the same way by SQL Server.

It would be easier to help with some more details. Take a look at the links in my signature.

I believe that this means MS DTC is not running on one of the servers involved in the transaction.

From BOL:

There are no temp files created, SSIS runs in memory which is why it is so fast. You can put a data viewer on the connector.