Not a problem

Just remember when you do go to production with this that you either give the Secondary's agent account the rights to access a $ share, so local admin,...

that's what I thought but the data isn't padded in the db with extra spaces, that was my first check, it must be something in bids which is doing it

The DB is in...

nothing jumps out at me, I do a checkdb once a month using

EXEC sp_MSforeachdb 'USE [?]; DBCC CHECKDB'

it then reads the error log and spits any errors into an email

takes...

thats the network path so the secondary can pick up the logs

as its the same box, put \\hostname\d$\sql\backups

or make the backups folder a shared folder eg \\hostname\backups

I think this is just BIDS trying to wind me up, and succeding. :angry:

Deployed the report the server, run it, all its all fine, no padding, the row isn't expanding....

Doh, of course, I knew it would of been something simple I was missing.

the columns where converted into NUMERIC and DECIMAL using CONVERT, please see my first post

converting them to FLOAT has solved the issue

Thanks Edward, totally appreciate that, I would of still expected SQL to come back with 4 and not 4.34

this is a CTE declaration

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

we get this from time to time, its usually down to locking, this has now gone away 99% of the time due to better indexes speeding up the queries so...

http://www.microsoft.com/learning/en/us/certification/exam-policies.aspx#revoke

Tab2 - NDA

Using unauthorized materials in an attempt to satisfy Exam requirements (this includes using brain-dump[/u] material and/or unauthorized publication of Exam questions with or without answers)

you could of installed a new instance of SSRS without uninstalling, but then you would have to do the following

http://hostname/reports_instancename

unless you created a host header record in DNS and...

Yeah, I cant help you on Progress, never touched it.

Have you tried here

http://www.datadirect.com/product-downloads/connect64-odbcwin.html or even just the root, they seem to have a host of drivers

yeah, you should see that option, its on the very first screen before you have clicked anything.

if you dont mind me asking, what DB provider are you linking to and...