Multi Value Parameters

Hi,
I am new to RS and the very first project that I had to implement was to
enhance a report which was taking a single param into multi value(not
multiple parameters). I bought 3 books and all were useless. Thought about
for a week to come with the design. I designed the application and it works
absolutely marvellous..
I will be posting the details by COB today so that everybody can see how it
works and also would like to know the feedback..Hi,
I am very interested in Multi Value Parameters. Did you post anywhere how
you managed to create these ?
Thanks
--
Best Regards
Maria Sartzetaki
"Suresh" wrote:
> Hi,
> I am new to RS and the very first project that I had to implement was to
> enhance a report which was taking a single param into multi value(not
> multiple parameters). I bought 3 books and all were useless. Thought about
> for a week to come with the design. I designed the application and it works
> absolutely marvellous..
> I will be posting the details by COB today so that everybody can see how it
> works and also would like to know the feedback..
>sql

Multi Server Administration

Hi,
We are about to implement MSX across our servers, we have some 400 SQL
Servers. What is the recommended number of master servers in sites as big as
this? Is there a maximum (recommended) number of target servers you can have
per master server?
Thanks
Julian
There is no hard recommended number that I know of. But before you
implement that you may want to check out SQL Sentry at
http://www.sqlsentry.net/ first. It can save you a LOT of headaches with
trying to monitor that many servers.
Andrew J. Kelly SQL MVP
"Julian" <Julian@.discussions.microsoft.com> wrote in message
news:0927CB87-4430-4860-9BDE-E3555B1168F7@.microsoft.com...
> Hi,
> We are about to implement MSX across our servers, we have some 400 SQL
> Servers. What is the recommended number of master servers in sites as big
as
> this? Is there a maximum (recommended) number of target servers you can
have
> per master server?
> Thanks
> Julian
|||The Quest tools for SQL Server also have multi-server execution capability.
It's similar to Query Analyzer, except that you can select as many servers
as you like to execute against. There's a freeware version too. Check out
http://www.quest.com/quest_central/s...ver/freeware/.
"Julian" <Julian@.discussions.microsoft.com> wrote in message
news:0927CB87-4430-4860-9BDE-E3555B1168F7@.microsoft.com...
> Hi,
> We are about to implement MSX across our servers, we have some 400 SQL
> Servers. What is the recommended number of master servers in sites as big
as
> this? Is there a maximum (recommended) number of target servers you can
have
> per master server?
> Thanks
> Julian

Multi Server Administration

Hi,
We are about to implement MSX across our servers, we have some 400 SQL
Servers. What is the recommended number of master servers in sites as big as
this? Is there a maximum (recommended) number of target servers you can have
per master server?
Thanks
JulianThere is no hard recommended number that I know of. But before you
implement that you may want to check out SQL Sentry at
http://www.sqlsentry.net/ first. It can save you a LOT of headaches with
trying to monitor that many servers.
--
Andrew J. Kelly SQL MVP
"Julian" <Julian@.discussions.microsoft.com> wrote in message
news:0927CB87-4430-4860-9BDE-E3555B1168F7@.microsoft.com...
> Hi,
> We are about to implement MSX across our servers, we have some 400 SQL
> Servers. What is the recommended number of master servers in sites as big
as
> this? Is there a maximum (recommended) number of target servers you can
have
> per master server?
> Thanks
> Julian|||The Quest tools for SQL Server also have multi-server execution capability.
It's similar to Query Analyzer, except that you can select as many servers
as you like to execute against. There's a freeware version too. Check out
www.quest.com/quest_central/sql_server/freeware/.
"Julian" <Julian@.discussions.microsoft.com> wrote in message
news:0927CB87-4430-4860-9BDE-E3555B1168F7@.microsoft.com...
> Hi,
> We are about to implement MSX across our servers, we have some 400 SQL
> Servers. What is the recommended number of master servers in sites as big
as
> this? Is there a maximum (recommended) number of target servers you can
have
> per master server?
> Thanks
> Julian