you say the table has four columns in the following order

DirName | ReadAccess | WriteAccess | FullAccess

And you want the table to be returned as

DirName | ReadAccess | WriteAccess |...

the 4gb limit still applies to 2008 Express R1, the limit was increased to 10GB in R2

this is a limitation of FILESTREAM from what I have been reading, the FILESTREAM file needs to be on a local drive to the SQL server hosting the DB.

I would...

you could create a role, put the users in the role, grant the access needed to that role, that way you can add and remove users as you wish and...

Is this a 64 bit server?

There are some issues in connecting on 64 bit SQL

http://social.msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/4887d91f-6ac7-40c0-9fc8-5cdd0634e603, its about Vista x64 and SQL 2008 x64.

can do it one of two ways

format the report so that its no wider than 1 page wide so when exported to excel it is one page wide already

or

when printing...

declare @string varchar(max)

set @string = 'SOME STRING'

sp_executesql (@string)

or

EXEC (@string)

it does look like conditional logic errors with all the AND's.

if not and the logic is how the OP requires it then we need DDL, data, expected outputs and paramter...

direct responces to this link http://www.sqlservercentral.com/Forums/Topic1216888-146-1.aspx

please post your full ddl scripts including sample data for all tables (inc indexes) and insert statements for the data so that we can assist you better

if you lookup sp_send_dbmail in SQL BOL or google it will provide the information you are looking for.

you first need to ensure that you have configured DB mail and that...

if your using SQL Mail already then you need to find where you use SQL Mail and apply the same syntax to the new procs.

SQL Mail is a depreciated feature...

I'm sure I will get a moment to sit down and learn this stuff instead of just copy and pasting a tablix every time I need different row groups. ...

will need to use database mail

msdb.dbo.sp_send_dbmail

will need to be configured with a mail profile if not already done so and then where xp_sendmail is in the scripts replaced with the...

you will want to look into row groups, these baffle me a lot of the time.

i still cant get them to work by doing it manually, so i just copy...