Ow, I really love SSRS, believe me, but I want to use this tool for ad-hoc monitoring without the need for installing SSRS etc.

I'd like to view...

Here's the whole script

DECLARE @sSql AS varchar(max)

DECLARE @cols as varchar(max)

SET @cols = '' + QUOTENAME( Convert ( nvarchar,dateadd("d",-1,getdate()),105 ) )...

Hi all,

thanks for the replies; I tried to create a dynamic query, it's almost working. Here's the code:

DECLARE @cols as varchar(max)

SET @cols = '' + QUOTENAME( Convert ( nvarchar,dateadd("d",-1,getdate()),105...

Sound like a little sarcastic to me or am I wrong ?

I hope he...

I will respect those who knows a lot of something, so I'll expect some respect too. He started SQL once and asked "stupid" of basic questions too.

I hate replies like...

I will listen, but I...

O Yes it is nice !

ever heard of background information wich can be usefull to share ?

...

Restoring transactions is not available in SQL Express (at least not in the SSMS), so I guess this isn't an option.

I just tested some stuff and I can restore my...

at the moment the recovery model is simple, but I can change it easily. I want to backup databases every 4 hours. I always thought that when I create a...

well, I guess this solution will work for me since there is no tool.

Thanks and a merry Christmas everyone !

Sorry for my start post, this is exactly what I mean: a tool to open & execute .SQL files with CREATE comands etc. I don't want to open and execute...