Chris:

How do we know that a report was run manually or via a schedule ? Will this be correct ?

Use ReportServer

go

select ReportPath , COUNT(*) as CNT ...

Cool

Our server is 2008. So the following worked

Use ReportServer

go

select TimeStart ts , * from ExecutionLog order by TimeStart DESC

select TimeStart ts , * from ExecutionLog2 order by TimeStart...

Lowell, Luis Thanks

Your solutions work.

I am using the code for a one time test.. So it doesn't mater LOOP or OTHER .

Lowells solution is great ( in one...

THOM A: I wanted you to modify the code for me.. (Please )

Never mind!

Done!

It works!

No Help needed.

Declare @c Bigint

Declare @i int

Declare @str NVARCHAR(1000)

Select @i=1

While( @i <= 24 )

Begin...

Ed: It used to send , suddenly it stopped.

ZZartin: Found the error. There was a value '4,000.00'

I managed to take care of that by doing a CAST( (CAST ( COL as MONEY )) as ...

YES

It works for me ( because I have VS2015 installed on my desktop 0 So the connection info is perfect. It is a compatibility issue where a report produced in...

Thanks GM and LUIS..

The following command did work

CREATE DATABASE AdventureWorks2012_Data

ON (FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\AdventureWorksDW2012_Data.mdf')

FOR ATTACH_REBUILD_LOG

Go

GM

I am assuming that this Db will have those tables that start with the "DM" prefix ( Ex: DmDate )

Did a RightClick on Database and Selected [highlight="#F5CC33"] Restore Database[/highlight]

I followed the steps on http://www.techjunkieblog.com/2014/08/installing-adventureworks-sample.html

However the "OK" button is greyed out.

See the attached picture .... Somehow when...