There is a tickbox when creating the subscription called "Include Link". Simply don't tick it.

If you are using your above logic, ensure you change your Current DOB logic as well. Otherwise, you'll notice that some other current ages will be wrong (such as 01-Nov-1987,...

As everyone else has said, you're going to find it unlikely that anyone will be willing to download your Archive file and open it.

We would be better off troubleshooting your...

Duplicate of http://www.sqlservercentral.com/Forums/Topic1828598-3077-1.aspx#bm1828640

DATEDIFF will give the difference in the years between two dates, not the actual number of years that have passed between two. So, for example, using DATEDIFF to provide the...

Is this the actual format your data is in, or do you have further tables. For something such as this, I'd be hoping for a TimeSlot table, Student Table, and...

Firstly, your INSERT statement is malformed. let me fix that for you:

CREATE TABLE StudentCourse (ID VARCHAR(10), --Is there any reason why this is not an INT value? It seems that...

Briefly looking at the data, however,I'd hazard a guess that the form links to the attachment by AttachmentUID, as both fields appear in both tables.

As said above, it's apparent that...

Data can be linked between two databases just as easilyas between one, joins, etc, still work exactly the same way.

The only way to know how data links together is to...

Mirroring between 2 different version of SQL Server is not supported (MSDN). Here you're attempting mirror a instance that is 2 versions later, so I'm not really surprised by the...

I've attempted something that is based on your explanation, using J's DDL (many thanks), however, it doesn't return the same result set you have, if I'm reading it correct.

For starters,...

Please supply DDL and Insert statements when giving data. A copy and paste of data like that is awful to look at, and almost unreadable. To my eyes, it looks...

I assume you mean by gridlines the borders on your table? You can do this using an expression on your cells.

This is using the assumption that all your cells have...

Who are you trying to access it as, yourself? Who did you set as an administrator of Reporting Services when you did the install? Log into the Portal using that...

The permission role on the ReportServer DB is something completely separate to the ability to deploy reports. That role is there mainly for the SQL service agent, so that when...