To name a few, product - company

SQL Monitor - Red-Gate

Idera DM - Idera

Spotlight - Quest\Dell

Foglight - Quest\Dell

SQL Sentry - SQL Sentry

Solarwinds have started doing an application monitoring module which connects...

Do you have the right permissions on the SSRS 2008 R2 server to deploy and view reports?

could check the default trace, depending on how active the server is

other than that if you dont do custom auditing your out of luck

Whats is the full output of

DBCC CHECKDB .... ALL_ERRORMSGS, NO_INFOMSGS

msdb.dbo.backupset then database_name column, user_name column, count them, group them

create a parameter, assign the available values section the query, assign the right columns to the right drop downs, then use the parameter in the stored proc.

So two datasets, one...

Speak to Quest, they make the rules, they enforce the rules.

As I say its been 4 years since I last did a purchase, so get the information you seek from...

msdb.dbo.backupfile

msdb.dbo.backupfilegroup

msdb.dbo.backupmediafamily

msdb.dbo.backupmediaset

msdb.dbo.backupset

Join them together and pull out the pieces of information which are rellivant to what you want to show.

Yes, as at the time they didnt give the CPU option, which would of suited us better due to 70 of the 80 servers being virtual, so could of saved...

CREATE PROCEDURE ... (@param1 char(1))

AS

SELECT name FROM ps WHERE LEFT(Name,1) = @param1

As with any thing so legally binding as licensing, speak to the vendor or your reseller, dont take public forum as the truth.

But.....

Last time I purchased Spotlight licenses it was...

An easy option may be to set a job to run at the time SQL Agent starts up which sends a mail.

Well then as long as you have a linked server from ServerA to ServerB you will be ok.

But I seriously would recommend changing the connection string and not using dynamic...

If the proc is in A and A is down, then they wont be able to run the proc as they cant get to A, so your logic is flawed.

What...

michael.higgins (2/5/2013)

---

Unless i'm missing the point??

The stored procedure exists on the server. The application connects to that server. If you need to change the server in the application...