I assume you also checked that sql server is configured to allow remote connections?

Are you trying to connect to a named instance or is it just a default instance?

Are you...

Is TCP/IP enabled? Check this in sql server configuration manager.

1) What authentication mode are you using?

2) Are you trying to connect to the server remotely?

3) Have you enabled remote access?

4) Is TCP/IP enabled?

You need to provide more info.

So you want to have a report to allow you to select a SQL instance name from a drop-down box then display all index stats on all databases on the...

Possibly a bad attempt at solving this on my tablet. There has to be a cleverer way to do it lol give it a go anyway

If datepart(mm, your-date) >7

then...

eusanpe1 (12/11/2012)

---

Hi All,

I am trying to write a query to pull out the next order but it isn't working if the next order is equal to the order that I...

Possibly..... I would add DatabaseMail.exe to the Prevent mass mailing worms from sending mail rule

Thanks for the confirmation.

I provided you with a working solution earlier. Have you tied it?

What happens if the start date parameter is not a monday?

I'm assuming that the start of the week is Monday. Also this solution uses a tally table.

First create a tally table (numbers table)

If exists (select 1 from information_schema.tables where...

Okay let me thave a go.

Cadavre introduces the concept of a tally...

Have you seen this? http://www.nevron.com/Nevron.Home.aspx

Lowell (12/3/2012)

---

glad it's working for you!

one more thing to consider:

if you create a new database via a RESTORE, that does not trigger the CREATE_DATABASE event. that triggers the event AUDIT_BACKUP_RESTORE_EVENT,...

Thanks for the confirmation.

I have managed to resolve the problem with the following trigger which I have tested and seems to work like a charm!

CREATE TRIGGER [DDLTriggerCreateAlterOrDropDatabaseBackupSchedule]

ON ALL SERVER...