Oops that wasn't supposed to get posted, I've been playing around with various ways of writing it but I have to concede the rest of the world is right, you...

Hi Gareth

What's your overall objective with this script?

If you simply want to monitor database and log file useage from a central location there are a number of things you could...

That does look like the result of a lost argument between a dba and a business user 😀

Try

EXEC DB2.dbo.Test @DB = CAST(SELECT DB_NAME() AS SYSNAME);

Hi Anand

You are approaching this in the wrong way using SQL. As mentioned by Lutz, you need to approach this using set based logic rather than row based.

There...

You could add a parameter to the sproc and pass the db name into it. This would of course need to be recorded somewhere.

Jeff Moden (8/28/2010)

Hi Brian,

That's not the recommended way to do things because 1)... 23:59:59.999 rounds UP to the next...

It appears I also made a mistake, I totally misunderstood the initial question.

I'm not going to go back over Jeff Moden's answer it's correct. However if you would like analyse...

You might be better off simply returning the result set to your application and then generating the file with that rather than have SQL Server push the file out to...

The last row inserted causes SQL Server to allocate a new 8K page for your table, this means your table now has two 8K pages therefore its size is 16K....

I forgot to add, I believe the nvarchar(max) is roughly 2GB

Try

WHERE [Timestamp] >= '2010-08-28 00:00:00.000' and [Timestamp] <= '2010-08-28 23:59:59.999';

Hi Preethi

Please could you post the DDL of the tables involved?

Hi Anand.

What is your analysis function (AnalysisProduct()) doing with each row? What, if any, other tables are accessed?

I'm assuming at present this script resides somewhere on a file system as a .sql script file and is manually executed after each restore.

You could add the following code prior...