Hi Jason,

thanks for that, I'll add them to the exclusions list in the query.

Ta

David

Hi There,

Have a look at this web page, it should give you what you need. I use this method and it works fine.

http://codebyjoshua.blogspot.com.au/2012/01/get-data-from-sql-server-stored.html

Ta

David

Hi resender,

Try using --execute sp_executesql (@SQL)

Rather than --execute sp_executesql @sql

Ta

David

I haven't tested this but i think your issue is with the ISNULL in the weird bit. When the name is NULL you set it to None. this does not...

Hi,

I suspect you have a non numeric character in a column which you are trying to populate a column which is numeric datatype. if the column in the source data...

I agree this should be done in the frontend app.

This code will give you the commas and decimal places

SELECT CONVERT(VARCHAR, CAST('1234567890' AS MONEY),1)

As for left or right justification, that...

Hi there,

If it is a straight like for like replacement then this would work

update [mytable]

set [mycolumn] = '#########'

where len([mycolumn]) = 9

If the task is more complex then you will need...

Hi there,

I would look to be using two CTE to replace your selects and then query those to produce your report so something like

WITH cte1 <columns>

<SELECT Statement>,

cte2 <columns>

<SELECT Statement>

select <columns>

from...

Hi There,

I don't really understand what it is that you are trying to do. Is it the backups which are failing, if so what are the errors or is your...

There maybe a better solution using Adam Machanic's WhoIsActive stored proc, he has a variable @show_system_spids so you can stop those appearing and you can filter by database. you could...

I have ripped this out of Glenn Berry's excellent Diagnostic Information Queries (go grab a copy of the script)

Anyway this should give you what you need.

SELECT DB_NAME([database_id])AS [Database Name],

...

Is there any BEGIN TRANSACTION.... ROLLBACK in the error handling, indeed are they hitting the error trap for some reason

Hi There,

If you go to D:\Data are there 3 files for this database? In your post the two .ndf files seem to have the same name?

Hi,

A quick google of the table name throws up alsorts of posts about this table growing hugely, so much so that there is a microsoft kb article about clearing it...

Hi Jend,

Can you post the table structure, it sounds like it is a very wide table or maybe it houses images or some such thing.

Ta

David