dependent tables

How can I find out all dependent tables to a table?
I don't see this information in sysdepends, sysdepends
provides information about dependent procedure, trigger,
views.
Thank you,
Linda
To show all tables with foreign keys to pubs..titles:
use pubs
select object_name(fkeyid)
from sysforeignkeys
where rkeyid=object_id('titles')
"Linda" <anonymous@.discussions.microsoft.com> wrote in message
news:1d9e801c45486$4ec39d50$a301280a@.phx.gbl...
> How can I find out all dependent tables to a table?
> I don't see this information in sysdepends, sysdepends
> provides information about dependent procedure, trigger,
> views.
> Thank you,
> Linda
|||Thank you Adams, this is what I was looking for.
-Linda
>--Original Message--
>To show all tables with foreign keys to pubs..titles:
>use pubs
>select object_name(fkeyid)
>from sysforeignkeys
>where rkeyid=object_id('titles')
>
>"Linda" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:1d9e801c45486$4ec39d50$a301280a@.phx.gbl...
trigger,
>
>.
>

dependent tables

How can I find out all dependent tables to a table?
I don't see this information in sysdepends, sysdepends
provides information about dependent procedure, trigger,
views.
Thank you,
LindaTo show all tables with foreign keys to pubs..titles:
use pubs
select object_name(fkeyid)
from sysforeignkeys
where rkeyid=object_id('titles')
"Linda" <anonymous@.discussions.microsoft.com> wrote in message
news:1d9e801c45486$4ec39d50$a301280a@.phx.gbl...
> How can I find out all dependent tables to a table?
> I don't see this information in sysdepends, sysdepends
> provides information about dependent procedure, trigger,
> views.
> Thank you,
> Linda|||Thank you Adams, this is what I was looking for.
-Linda
>--Original Message--
>To show all tables with foreign keys to pubs..titles:
>use pubs
>select object_name(fkeyid)
>from sysforeignkeys
>where rkeyid=object_id('titles')
>
>"Linda" <anonymous@.discussions.microsoft.com> wrote in
message
>news:1d9e801c45486$4ec39d50$a301280a@.phx.gbl...
>> How can I find out all dependent tables to a table?
>> I don't see this information in sysdepends, sysdepends
>> provides information about dependent procedure,
trigger,
>> views.
>> Thank you,
>> Linda
>
>.
>

dependent tables

How can I find out all dependent tables to a table?
I don't see this information in sysdepends, sysdepends
provides information about dependent procedure, trigger,
views.
Thank you,
LindaTo show all tables with foreign keys to pubs..titles:
use pubs
select object_name(fkeyid)
from sysforeignkeys
where rkeyid=object_id('titles')
"Linda" <anonymous@.discussions.microsoft.com> wrote in message
news:1d9e801c45486$4ec39d50$a301280a@.phx
.gbl...
> How can I find out all dependent tables to a table?
> I don't see this information in sysdepends, sysdepends
> provides information about dependent procedure, trigger,
> views.
> Thank you,
> Linda|||Thank you Adams, this is what I was looking for.
-Linda
>--Original Message--
>To show all tables with foreign keys to pubs..titles:
>use pubs
>select object_name(fkeyid)
>from sysforeignkeys
>where rkeyid=object_id('titles')
>
>"Linda" <anonymous@.discussions.microsoft.com> wrote in
message
> news:1d9e801c45486$4ec39d50$a301280a@.phx
.gbl...
trigger,[vbcol=seagreen]
>
>.
>

Dependent Service on MSSQLSERVER?

I have a ABC service on a server1 that is dependent on MSSQLSERVER service running on server2. Does anyone know how to setup the service ABC on server1 to have a dependancy on MSSQLSERVER running on server2?
Thanks,
jgsI don't think you can, unless server1 and server2 are nodes of Active/Active cluster. What is the ABC service for?|||The ABC service is a VB application that uses the SQL Server 2000 database on startup and operation.....|||How in blazes do you write a service using VB ?!?!

-PatP

Dependent report parameters help

I have four parameters for my report: StartDate, EndDate, TankID (the ID of a thank going from V01 to V20 and from S01 to S20) and Site (the location of the tanks, for example: the V-tanks are in Belgium (BE) and the S-tanks are in Spain (SP))

The thing I want to do is: If I set parameter "Site" to "Belgium" then only the tanks in belgium will be shown as values in the dropdown of the "TankID" parameter. If site = Spain, only spanish tanks will be shown in tankid parameter dropdown box.

I tried adding a new dataset which has as default value the parameter of the "Site". Also tried some other stuff but the only thing i get is this error:

Error 4 [rsInvalidReportParameterDependency]
The report parameter ‘BLABLA’ has a DefaultValue or a ValidValue that depends on the report parameter “BLEBLE”. Forward dependencies are not valid.

So the thing I want to use are parameters that depend on eachother. If anyone made that possible, please let me know how!

Greets
Wim

See this link on msdn:

http://msdn2.microsoft.com/en-us/library/ms155917.aspx

Scroll all the way down to the very last section entitled "Cascading Parameters". I believe this is what you are trying to do. Let me know if I can help further.

|||

Just Change the order of the report parameters

i:e if Changing ParaA updates ParaB Drop-down values, then place ParaA before ParaB

|||

I haven't read the msdn page yet, I just started with the second option (changing parameter order) to see if that works and IT DOES!!!!

You just have to place the depentent parameter below the one it depends on and all works fine! (so in my case I placed the tank parameter below the site parameter)

Thanks for your help
greets

Wim

|||

Hello

Can we make Multivalue parameters to play for cascading parameters. I am trying with different combinations of using query parameters and Report parameters.

Can any body help me?

Regards

Raj Deep.A

Dependent report parameters help

I have four parameters for my report: StartDate, EndDate, TankID (the ID of a thank going from V01 to V20 and from S01 to S20) and Site (the location of the tanks, for example: the V-tanks are in Belgium (BE) and the S-tanks are in Spain (SP))

The thing I want to do is: If I set parameter "Site" to "Belgium" then only the tanks in belgium will be shown as values in the dropdown of the "TankID" parameter. If site = Spain, only spanish tanks will be shown in tankid parameter dropdown box.

I tried adding a new dataset which has as default value the parameter of the "Site". Also tried some other stuff but the only thing i get is this error:

Error 4 [rsInvalidReportParameterDependency]
The report parameter ‘BLABLA’ has a DefaultValue or a ValidValue that depends on the report parameter “BLEBLE”. Forward dependencies are not valid.

So the thing I want to use are parameters that depend on eachother. If anyone made that possible, please let me know how!

Greets
Wim

See this link on msdn:

http://msdn2.microsoft.com/en-us/library/ms155917.aspx

Scroll all the way down to the very last section entitled "Cascading Parameters". I believe this is what you are trying to do. Let me know if I can help further.

|||

Just Change the order of the report parameters

i:e if Changing ParaA updates ParaB Drop-down values, then place ParaA before ParaB

|||

I haven't read the msdn page yet, I just started with the second option (changing parameter order) to see if that works and IT DOES!!!!

You just have to place the depentent parameter below the one it depends on and all works fine! (so in my case I placed the tank parameter below the site parameter)

Thanks for your help
greets

Wim

|||

Hello

Can we make Multivalue parameters to play for cascading parameters. I am trying with different combinations of using query parameters and Report parameters.

Can any body help me?

Regards

Raj Deep.A

Dependent Records

I want to delete a parent record.

Is there a simple call I could make that would tell me if there are dependent child records, without me having to hard code in all the child tables and manually calling each child table one at a time.

A .net framework call that that returned a Yes/No to a "Are there any dependent records?" sort of query, or better still if it told me the table the dependent record is in.

I would then know if I could delete the record.

I have referential integrity turned on and am using a Access 2000 .mdb, but will soon be upsizeing to SQL Server Express (the MSDE thingy).

I realise I could use the sledge hammer technique and let the Referential Integrity stop me, but a more polite approach would be better, and I am not sure if you can have Referential Integrity in SQL Express like you do in Access.

Warm regards

NeilReferential integrity in SQL Server Express is pretty much the same as Access, although you'll have more methods available for creating and maintaining the constraints (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_04_9183.asp).

If you want to delete all child records associated with a parent record, you can use cascading deletes (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_04_92ib.asp). This is not a good idea as a rule though, since most times you'll want the application to throw an exception if a parent record is deleted before the child records. In a typical application, you'd delete the child records first, then delete the parent record(s).

If this is a UI, I always like it when developers catch the RI exception if a user attempts to delete a parent, then displays a message such as "there are other records associated with the row you want to delete, all associated data will be deleted, are you sure this is OK?".

Hope this helps,
Josh Lindenmuth

Dependent Objects

I am trying to find all the objects - SP, triggers, Views that depend on
some Table.
I was trying to use sysdepends table but it seems to me that it doesn't
return all the dependent objects. It misses obvious Update and Insert SP for
this table.
Is there a reliable way to find dependent objects.
thank you
ShimonThere is no reliable way to find dependent objects because of delayed name
resolution. However, you can try to parse syscomments :)
"Shimon Sim" wrote:

> I am trying to find all the objects - SP, triggers, Views that depend on
> some Table.
> I was trying to use sysdepends table but it seems to me that it doesn't
> return all the dependent objects. It misses obvious Update and Insert SP f
or
> this table.
> Is there a reliable way to find dependent objects.
> thank you
> Shimon
>
>

Dependent columns

I have three columns (CWOC, C, and PWC). both CWOC and PWC are dependent on the value in C, yet C is dependent on the value in PWC.

Basically:

C = PWC * BR
PWC = MR - CWOC
CWOC = MC - C

In setting up these columns in the database how do I set up columns like these that are so dependent on each other?

This was set up previously in Excel using iteration, but now I'm recreating the application in VB.net and SQL Server.

Thanks for your suggestions.There is no single logical solution to that set of equations. There are, in fact, infinite stable solutions. So how are you going to select one? And what good is it? Is this some sort of fractal database or chaos theory experiment?|||That's just how the client calculates their commissions.|||Oh.

My.

God.

I once had the task of setting up a commision and compensation system for territory sales reps. The Regional Director wanted something simple and understandable. So I gave them something simple and understandable. Then they wanted it to consider existing market saturation in each territory, so I threw in weighted averaging. Then they wanted it to account for seasonal variations, so I added an exponential smoothing model to the algorithm. Then they wanted it to account for historical performance, so I included a linear regression model in the algorithm.
You guessed it. None of the sales reps would accept the compensation model because it was too complicated. They would rather have something that was less than fully fair which they could calculate on their own, and I understood their point.

So how in the world did they end up with a non-linear commision structure?

I'm not just asking to be nosy, or out of incredulousness (ok, a bit of that...). But if you explain a bit more about the algorithm MAYBE I can help you come up with something...|||I give you my 2 cents opinion.

I put everything is under the hat of "business logic" in a stored procedure (with the aid of UDF if needed) or into an intermediate COM+ component. In this case, since the logic must be applied to the data contained in the database itself, i'd prefer the stored procedure solution.
This won't dirty your database design with business logic implication, so that in the future, if the business logic change it won't be necessary to change the db schema and vice-versa.