Check Constraint configuration

Hi all,
Where does SQL 2000 store all check-constraint configurations? i.e. I have a column in a table which I would like to limit the value to be > 10. Would like to retrieve the info via a client program.
Thanks
regards,
tswernall the constrainsts are saved in the table sysconstratints|||looked into sysconstraints table. seems like it does not contain any rules I specified for my check contraint column. Only have a number of ids. Any idea which tables these ids tie to the actual check constraint configuration?|||you might find this useful|||Thanks paul! Indeed it is very usefull.|||Thanks paul! Indeed it is very usefull.

Changing Virtual Directories

Hello, I'm installing reporting services on a new sql server 2005 box. While
on the machine, I go to Reporting Services Configuration Manager, I'm trying
to create the report server virtual directory and report manager virtual
directory. My issue is that I don't want to create them on the sql box but
on another web server. I don't get an option to tell it to create a New
folder on anywhere put the sql server.
How can you do this?
Thanksyou have to install RS on this second server... and you have to pay for the
license...
you can use the first server to host the RS database, but you have to go
through the setup process for the new web server.
"Don" <Don@.discussions.microsoft.com> wrote in message
news:96C0591D-C166-47B1-AF47-21CE26772036@.microsoft.com...
> Hello, I'm installing reporting services on a new sql server 2005 box.
> While
> on the machine, I go to Reporting Services Configuration Manager, I'm
> trying
> to create the report server virtual directory and report manager virtual
> directory. My issue is that I don't want to create them on the sql box
> but
> on another web server. I don't get an option to tell it to create a New
> folder on anywhere put the sql server.
> How can you do this?
> Thanks
>|||Are you sure that's how the licensing works? I thought you only had to pay
for additional licenses if you were doing it in a farm, or if your database
server was 1 cpu and the web server had 2 CPU.
So, If I run the setup on the web server then when i go into Reporting
Services Configuration Manager on the web server and select the database on
the sql server? Or do you do the configuration manager from the sql server.
Thanks
"Jeje" wrote:
> you have to install RS on this second server... and you have to pay for the
> license...
> you can use the first server to host the RS database, but you have to go
> through the setup process for the new web server.
> "Don" <Don@.discussions.microsoft.com> wrote in message
> news:96C0591D-C166-47B1-AF47-21CE26772036@.microsoft.com...
> > Hello, I'm installing reporting services on a new sql server 2005 box.
> > While
> > on the machine, I go to Reporting Services Configuration Manager, I'm
> > trying
> > to create the report server virtual directory and report manager virtual
> > directory. My issue is that I don't want to create them on the sql box
> > but
> > on another web server. I don't get an option to tell it to create a New
> > folder on anywhere put the sql server.
> > How can you do this?
> >
> > Thanks
> >|||On Oct 2, 8:06 pm, Don <D...@.discussions.microsoft.com> wrote:
> Are you sure that's how the licensing works? I thought you only had to pay
> for additional licenses if you were doing it in a farm, or if your database
> server was 1 cpu and the web server had 2 CPU.
> So, If I run the setup on the web server then when i go into Reporting
> Services Configuration Manager on the web server and select the database on
> the sql server? Or do you do the configuration manager from the sql server.
> Thanks
> "Jeje" wrote:
> > you have to install RS on this second server... and you have to pay for the
> > license...
> > you can use the first server to host the RS database, but you have to go
> > through the setup process for the new web server.
> > "Don" <D...@.discussions.microsoft.com> wrote in message
> >news:96C0591D-C166-47B1-AF47-21CE26772036@.microsoft.com...
> > > Hello, I'm installing reporting services on a new sql server 2005 box.
> > > While
> > > on the machine, I go to Reporting Services Configuration Manager, I'm
> > > trying
> > > to create the report server virtual directory and report manager virtual
> > > directory. My issue is that I don't want to create them on the sql box
> > > but
> > > on another web server. I don't get an option to tell it to create a New
> > > folder on anywhere put the sql server.
> > > How can you do this?
> > > Thanks
The licensing scheme that Jeje mentioned is correct (reference:
http://msdn2.microsoft.com/en-us/library/ms143238.aspx ). Also, this
link should help in terms of the Configuration process.
http://msdn2.microsoft.com/en-us/library/ms157293.aspx
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Thanks, so I have a sql server but I don't want to install the reporting
services piece on the sql server (using the IIS installed on SQL box) because
I want people outside of the network to see the reports using the report
manager.
I believe that if I have it installed on the sql server then only people in
the office will be able to see it. So, sql server reporting servies is only
really every included in your purchase of sql server if you want to only
display the data with people logged onto your network?
Thanks
"EMartinez" wrote:
> On Oct 2, 8:06 pm, Don <D...@.discussions.microsoft.com> wrote:
> > Are you sure that's how the licensing works? I thought you only had to pay
> > for additional licenses if you were doing it in a farm, or if your database
> > server was 1 cpu and the web server had 2 CPU.
> >
> > So, If I run the setup on the web server then when i go into Reporting
> > Services Configuration Manager on the web server and select the database on
> > the sql server? Or do you do the configuration manager from the sql server.
> >
> > Thanks
> >
> > "Jeje" wrote:
> > > you have to install RS on this second server... and you have to pay for the
> > > license...
> > > you can use the first server to host the RS database, but you have to go
> > > through the setup process for the new web server.
> >
> > > "Don" <D...@.discussions.microsoft.com> wrote in message
> > >news:96C0591D-C166-47B1-AF47-21CE26772036@.microsoft.com...
> > > > Hello, I'm installing reporting services on a new sql server 2005 box.
> > > > While
> > > > on the machine, I go to Reporting Services Configuration Manager, I'm
> > > > trying
> > > > to create the report server virtual directory and report manager virtual
> > > > directory. My issue is that I don't want to create them on the sql box
> > > > but
> > > > on another web server. I don't get an option to tell it to create a New
> > > > folder on anywhere put the sql server.
> > > > How can you do this?
> >
> > > > Thanks
>
> The licensing scheme that Jeje mentioned is correct (reference:
> http://msdn2.microsoft.com/en-us/library/ms143238.aspx ). Also, this
> link should help in terms of the Configuration process.
> http://msdn2.microsoft.com/en-us/library/ms157293.aspx
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||its a network and firewall issue.
you can install RS on the same box as SQL Server and open the HTTP door to
allow external users to access the server.
if you use ISA Server (or a firewall like this one) you can publish the
server easily on the internet.
"Don" <Don@.discussions.microsoft.com> wrote in message
news:B83002C5-DD7C-4220-818B-C796C2683889@.microsoft.com...
> Thanks, so I have a sql server but I don't want to install the reporting
> services piece on the sql server (using the IIS installed on SQL box)
> because
> I want people outside of the network to see the reports using the report
> manager.
> I believe that if I have it installed on the sql server then only people
> in
> the office will be able to see it. So, sql server reporting servies is
> only
> really every included in your purchase of sql server if you want to only
> display the data with people logged onto your network?
> Thanks
> "EMartinez" wrote:
>> On Oct 2, 8:06 pm, Don <D...@.discussions.microsoft.com> wrote:
>> > Are you sure that's how the licensing works? I thought you only had to
>> > pay
>> > for additional licenses if you were doing it in a farm, or if your
>> > database
>> > server was 1 cpu and the web server had 2 CPU.
>> >
>> > So, If I run the setup on the web server then when i go into Reporting
>> > Services Configuration Manager on the web server and select the
>> > database on
>> > the sql server? Or do you do the configuration manager from the sql
>> > server.
>> >
>> > Thanks
>> >
>> > "Jeje" wrote:
>> > > you have to install RS on this second server... and you have to pay
>> > > for the
>> > > license...
>> > > you can use the first server to host the RS database, but you have to
>> > > go
>> > > through the setup process for the new web server.
>> >
>> > > "Don" <D...@.discussions.microsoft.com> wrote in message
>> > >news:96C0591D-C166-47B1-AF47-21CE26772036@.microsoft.com...
>> > > > Hello, I'm installing reporting services on a new sql server 2005
>> > > > box.
>> > > > While
>> > > > on the machine, I go to Reporting Services Configuration Manager,
>> > > > I'm
>> > > > trying
>> > > > to create the report server virtual directory and report manager
>> > > > virtual
>> > > > directory. My issue is that I don't want to create them on the sql
>> > > > box
>> > > > but
>> > > > on another web server. I don't get an option to tell it to create
>> > > > a New
>> > > > folder on anywhere put the sql server.
>> > > > How can you do this?
>> >
>> > > > Thanks
>>
>> The licensing scheme that Jeje mentioned is correct (reference:
>> http://msdn2.microsoft.com/en-us/library/ms143238.aspx ). Also, this
>> link should help in terms of the Configuration process.
>> http://msdn2.microsoft.com/en-us/library/ms157293.aspx
>> Hope this helps.
>> Regards,
>> Enrique Martinez
>> Sr. Software Consultant
>>