CLOUD based setup: Do you mean that the monitoring tool should run in the cloud

And you want it to monitor on-premises databases (Servers ON-Prime)?

Or a monitoring tool that runs in...

Thanks for posting the commandline.

I can't help you further with rs.exe. We execute reports using urls. Does it stop immediately, after a fixed amount of time, ...

Any oracle timeouts set...

ORA-01013: user requested cancel of current operation

Your Oracle command is likely timing out.

Have a check on RPTUSER.CM_UNBILLED_DATA_P1

Did you set the -l parameter of rs.exe? (timeout)

Thanks for posting the solution

Where do you find "run in debug"?

It isn't build in to restore selected tables. Perhaps with 3th party software?

I hope benefits / motiviation of consolidating all databases into one outweighs the hassles with recovery (recovery time...

If you are only interested in EntityType, you  could use an nonclustered index on it. With a bit luck it only uses this index on one field instead of the...

If I run your code I get

Msg 137, Level 15, State 2, Line 17
Must declare the scalar variable "@listid".

Is it possible to have some sample data in...

MS has a whole page on it

https://learn.microsoft.com/en-us/sql/relational-databases/security/sql-injection?view=sql-server-ver16

You could use sp_humanevents (Erik Darling) https://www.erikdarlingdata.com/sp_humanevents/

To capture the waits while it is slow or log it to a table

Tools like sp_Blitz, sp_Blitzfirst (Brent Ozar) to have a quick...

• This reply was modified 2 years, 11 months ago by Jo Pattyn. Reason: added XESmartTarget

Can you elaborate it a bit more? What is meant with "generates a output of adding 1 every second month"

0 = beginning of month?

1= end of month

float, secondes passed since...

Do you work with the "Join" function in SSRS for passing multiple values?

https://devinknightsql.com/2010/10/08/ssrs-join-function/

Not sure why it displays double ??

Wikipedia contains an overview of western codepages https://en.wikipedia.org/wiki/Western_Latin_character_sets_(computing)

https://en.wikipedia.org/wiki/Code_page_850

Looks like is is due memory limitations in the earlier days of MS-DOS

Thanks for the story glhohman

What do you mean exactly with but how do I format this for SSRS?

SSRS has date functions http://venkateswarlu.net/MSBI/ssrs/SSRS_Common_Functions_Date_Time.aspx