Maybe this'd do it. Thanks for your help one and all!

declare @C int

WHILE (1=1)

BEGIN

SET @C = (select count(*) FROM sys.dm_exec_requests req

CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext

where req.session_id...

Thanks all - but I don't want to kill any running queries, I'd rather avoid them. I think this'd be doable bearing in mind the periodic server activity. What's the...

Thanks Lowell, that's a useful snippet and works great.

Regards, Greg.

I've given up with openquery, I think there might be a problem with the ODBC driver for SQLite.

Am working around this using command line export of preformatted SQL INSERT statements...

Dear All,

Wrt the wrapped in Datazen product - I know this is to be given free for current Enterprise customers, but am wondering if anyone knows if it will be...

Just wondering if anyone has worked out how to control foreground AND background colours for cells in a formatted table?

In essence to combine these:

'font/@color' = case...(set up to return color...

Probably several years too late, but I've just been working in the same problem...

Assuming your Excel is set up with some report header information, then when you try to select...

Ah, because we receive a DB backup daily over SFTP from a disconnected data provider - another company.

Thanks Sean,

That'd be my best bet I think, a very fast cutover with hardly any down time. Many thanks.

Regards,

Greg.

Thanks Gail,

I checked and this was on...a copy of the DB already exists on the reporting server, we're replacing it though with a fresh copy.

OK, thanks for confirming that. I understand the EE position on filegroup restore better now. Didn't appreciate IFI would make a difference here, so will investigate.

Cheers, Greg.

Thanks Sean, will do.

Thanks for this. The query is quite simple, so I'm going to do it like this:

declare @route int

set @route = 2

if @route = 1

begin

select cast(1 as decimal(10,2)) as greg

end

if...

Thanks Chaps,

The data is ultimately passed back to the front end as a string, it'll look like this, either

10:5:2

or

12.50:16.50:10.25

I need to format each number before joining them in a...

I don't actually know as in my results set, there WERE no errors. So went back to basics and scanned the entire database for errors that failed the isdate() test....