Mind me asking why would you want to your instance to be in single user mode ?

Couldn't a user db in restricted user mode serve you well enough ?

This is what I would propose:

As last step of your JobA just run a ISQL script connecting to your ServerB and raising an alert at that sql instance and have...

Good job, Koen.

😎

dito.

Never seen it being used that way, never been pointed to this "feature" at any course followed and so we just never used it that way, but this opens a...

AFAIK the scope of a returned result set is the calling proc, unless you store it in a table...

A little bit of feedback / progress would be welcome. :blink:

Please do keep in mind we don't want to give you a hard time by not just giving you...

You are using SQLusers that have another internal id on the sqlinstance that hosts your stand-by database.

If these accounts are only supposed to use that database, you could try to...

Brandie Tarvin (5/11/2011)

---

Shameless self-promotion moment, for which I will probably get thwacked. @=)

The Science Fiction and Fantasy Writers of America (SFWA) will be in Washington D.C. on May 20th, doing...

GilaMonster (5/10/2011)

---

ALZDBA (5/10/2011)

---

Steve Jones - SSC Editor (5/10/2011)

---

Just rated some sessions for the PASS Summit. This has to be one of the poorest implementations of a rating tool I've seen,...

GSquared (5/10/2011)

---

Gail, sent four devs to your Catch-All Queries blog entry today. Thanks again for writing that. They all got it and one even got excited about it....

Steve Jones - SSC Editor (5/10/2011)

---

Just rated some sessions for the PASS Summit. This has to be one of the poorest implementations of a rating tool I've seen, but I...

Thank you for the suggestions on the Beer1 vitamines. 😉

Added to the list.

Koen Verbeeck (5/9/2011)

---

I've got a MSDN Livemeeting going on this afternoon (European time). Two demo's of each 15 minutes, so 30 minutes of talking.

Any tips from the professionals around here...

BenWard (5/10/2011)

---

yep thats fixed it.

asp does not seem to like varchar(max) - I can only assume a colleague changed the table for some reason whilst I was on holiday!

appologies for...

can you provide:

- @@version info ?

- ddl of both objects

- did this start all of a sudden or is this a new release ?

- can you find anything in sqlserver...