run this in the reportserver database

SELECT

U.UserName AS SubscriptionOwner,

C.Path AS ReportPath,

CONVERT(XML,S.ExtensionSettings) AS SubscriptionSettings,

S.EventType AS SubscriptionType,

CONVERT(XML,S.Parameters) AS ReportParameters,

S.DeliveryExtension AS DeliveryMethod,

Sc.Name AS ScheduleName,

Rs.ScheduleID

FROM

Subscriptions S

INNER JOIN

Users U

ON

S.OwnerID = U.UserID

INNER JOIN

Catalog C

ON

S.Report_OID = C.ItemID

INNER JOIN

ReportSchedule...

your problem is your storing binary in a textual data type not as a binary data type which is why you are getting the different errors

select CONVERT(binary(16),'0x2139aec19f212447bb23ba307d611a1e') will give you...

so back to my original post, please provide the create table definition for the table containing the ntext column, please provide sample data and also post the full query you...

someone call my name?

well looking at the cast/convert MSDN page

http://msdn.microsoft.com/en-us/library/ms187928.aspx

it details that ntext to binary convertions are not allowed, you will need to convert to varchar or nvarchar

unsure on that, what I would ask you do is post the query in question, along with data DDL and the rdl file, and detail what the results should look...

take a look at the key word UNION and UNION ALL, it will allow you to specify an additional query which you can create a blank row with a dummy...

please can you post the DDL for the table and some sample data with the results you expect to see and what you do actually see so we can take...

no it wont as your not affecting the transaction log

how are you licensing the servers? CPU lics or Server&CAL lics?

if CPU then you only need to purchase the amount of Enterprise licences which match the number of CPUs,...

the only way to backup the secondary would be to restore it with recovery so that it comes online for you to back it up. this will terminate the...

i've done this in the past when consolidating hardware, there are no issues with it as the binary files are installed in different folders, the only limitation we had was...

truffle shuffle

now your just being cruel :crying:

think we need to change the word now, as all this talk about fish and tartar sauce is making me want fish and chips for my evening meal, which will...