You can always script the replication setup, which you should have done already for disaster recovery.

Do try and test the detach/attach, etc on a restored copy of the database if...

When you reattach a database without specifying the log file, SQL Server will create a new log file for you.

If you take this route, there should not be an issue...

When you are *certain* about the way the database is being used, you can do the following:

1. execute sp_removedbreplication '<database name>' at the publisher;

2. try your shrink strategy again;

3. if...

Was this database acting as a publisher in a transactional replication before snapshot replication was set up? If so, you may need to perform some 'cleaning up' in order to...

Firstly, use a good backup tool such as SQL Litespeed; secondly, check the integrity of the database using DBCC CHECKDB before doing the backup. Please be aware that the check...

You certainly can! Search using the following keywords: "How to Contact the Microsoft Wish Program".

Paul

Try this instead:

IIF( Fields!Date_Received.Value < "01/01/00"

AND Fields!Exam_Date.Value > "01/01/00"

AND NOW() > DATEADD("d",8,Fields!Date.Value)

AND Fields!Mark.Value = -1,

Fields!Description.Value & IIF( InStr(Fields!Description.Value, "Real") > 0, "", " (Not submitted)" )

, Fields!Description.Value...

Hi David, please change the 'SELECT' keyword at the beginning to the equal sign '='. My apologies if the code I posted was not compatible for RS.

Paul

Hmm...I think this might be asking for too much from a Microsoft product! Have you tried breaking up the packages into sub packages?

Paul

Or the COALESCE() function...

Paul

Try this instead (changes in BOLD):

select

IIF( Fields!Date_Received.Value < '01/01/00'

AND

Sorry about the misunderstanding. What happens if you leave the Code Page to its default (1252 - ANSI Latin I) and Format as 'delimited'?

Try breaking the problem into two steps:

1. A SQL to determine NumOrders using the aggregation;

2. A second SQL to use the returned results from [1] (in the same vein as...

Whilst searching on the description "Bulk data stream was incorrectly specified as sorted" on google, it brought up this solution: make sure that both the publisher and subscriber are set...

The "Code Page" configuration can be found in the "Flat File Connection Manager Editor".

The default code page would most likely be that set for your OS.

Paul