|
Replies:
9
-
Pages:
1
-
Last Post:
May 3, 2012 2:59 AM
by: sergio_b
|
|
|
Posts:
38
Registered:
4/5/12
|
|
|
|
Error in window Service Broker
Posted:
Apr 12, 2012 2:57 AM
|
|
|
|
|
Dear Support,
I use your TOAD Beta to set service broker property of my DB and I obtain this error message.
To reproduce the problem click on the cell of the grid, for example Queue Name.
Best regards.
Sergio Bertolotti
|
|
|
Posts:
437
Registered:
12/7/06
|
|
|
|
Re: Error in window Service Broker
Posted:
Apr 13, 2012 12:27 PM
in response to: sergio_b
|
|
|
Sergio, have you tried to use this feature or just played around?
I'm quite interested to hear your use-case (if possible please) if you wanted to use it.
|
Regards, Valentine
/R&D @ DELL
|
|
Posts:
38
Registered:
4/5/12
|
|
|
|
Re: Error in window Service Broker
Posted:
Apr 13, 2012 2:44 PM
in response to: sergio_b
|
|
|
Dear Valentine,
I restore DB TasselliTabacchi from another server SQL 2005.
I must to re-generate the service broker ID and I use your menu voice - Service Broker Configuration.
After this I go on various voice, like for example QUEUES - to see if all is OK and then TOAD generate the problem that previously I send to you.
Best regards.
Sergio Bertolotti
|
|
|
Posts:
1
Registered:
5/1/12
|
|
|
|
Re: Error in window Service Broker
Posted:
May 1, 2012 11:55 AM
in response to: sergio_b
|
|
|
How does the new release of Toad/Sql Server for Denail look for Service Broker 2012 ( with regard to Service Broker Manager ) ?
|
|
|
Posts:
38
Registered:
4/5/12
|
|
|
|
Re: Error in window Service Broker
Posted:
May 1, 2012 1:51 PM
in response to: sergio_b
|
|
|
I don't know How this new beta release of TOAD look to service broker in SQL Server 2012/Denali.
It's better if someone of TOAD answer to you about this question.
Best regards.
Sergio Bertolotti
|
|
|
Posts:
437
Registered:
12/7/06
|
|
|
|
Re: Error in window Service Broker
Posted:
May 2, 2012 1:02 AM
in response to: sergio_b
|
|
|
|
|
Sergio,
Here is the latest update, now you can generate new service broker while restoring database backup - take a look at the attached screen for details.
it will generate the addition to restore script as following:
ALTER DATABASE [ChangeDirector_rep] SET NEW_BROKER WITH ROLLBACK IMMEDIATE
GO
|
Regards, Valentine
/R&D @ DELL
|
|
Posts:
437
Registered:
12/7/06
|
|
|
|
Re: Error in window Service Broker
Posted:
May 2, 2012 1:04 AM
in response to: wilder_bellamy_...
|
|
|
wilder_bellamy_031,
We didn't update Service Broker facility with support of 2012 in upcoming release of Toad. Are you looking for something special? I can create ER if you share more details with me.
|
Regards, Valentine
/R&D @ DELL
|
|
Posts:
38
Registered:
4/5/12
|
|
|
|
Re: Error in window Service Broker
Posted:
May 2, 2012 3:36 AM
in response to: sergio_b
|
|
|
Dear Valentine,
many thank's for your explanation about this question.
In the future I use this new feature to regenerate Service Broker ID on my DB's.
Best regards.
Sergio Bertolotti
|
|
|
Posts:
38
Registered:
4/5/12
|
|
|
|
Re: Error in window Service Broker
Posted:
May 2, 2012 3:44 AM
in response to: sergio_b
|
|
|
|
|
Dear Valentine,
there is still problem with service broker after update to the last update of the beta version of TOAD.
See my screenshot in attach.
Best regards.
Sergio Bertolotti
|
|
|
Posts:
38
Registered:
4/5/12
|
|
|
|
Re: Error in window Service Broker
Posted:
May 3, 2012 2:59 AM
in response to: sergio_b
|
|
|
|
|
Dear Valentine,
I try to use new feature with restore DB about service broker, like you suggest to me in your previous message, but I don't find it.
Is it available in version 5.7.0.483 of beta or in the future beta version ?
Take a look at screenshot that I attach to this message and as you can see there isn't any voice about Service Broker, under Destination option.
Best regards.
Sergio Bertolotti
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
