Relationships getting deleted (MS SQL)

Dear All,

I got a wierd problem which I haven't been able to explain.

I am working on MS SQL 2000. I don't know for what reason, the
relationship between Parent/Child table is getting deleted. When I
open up the ER diagram in MSSQL Enterprise Manager, I see the
relationship line come up for just a split of a second, and disappears
afterwards. This is the second time I am seeing this thing.

I realized it when I accidently deleted the rows in the Parent Table.
They should not have been deleted as I had associated records in the
Child Table (because of Key Constraints).

Has anyone ever come across this situation? Do you have any
suggestions?

Regards,
TinTin"TinTin" <lalalulu24@.yahoo.com> wrote in message
news:2d5425d1.0410071018.663f4082@.posting.google.c om...
> Dear All,
> I got a wierd problem which I haven't been able to explain.
> I am working on MS SQL 2000. I don't know for what reason, the
> relationship between Parent/Child table is getting deleted. When I
> open up the ER diagram in MSSQL Enterprise Manager, I see the
> relationship line come up for just a split of a second, and disappears
> afterwards. This is the second time I am seeing this thing.
> I realized it when I accidently deleted the rows in the Parent Table.
> They should not have been deleted as I had associated records in the
> Child Table (because of Key Constraints).
> Has anyone ever come across this situation? Do you have any
> suggestions?
> Regards,
> TinTin

The best suggestion is probably don't use EM for this task - it has a
history of glitches and small bugs, and some tasks are simply not possible
at all. The most reliable way to manage your database objects is with TSQL
in Query Analyzer, as you have complete control over what's happening, and
you can easily save scripts for common tasks.

In this case, you can look at sp_help, sp_pkeys and sp_fkeys to get
information about the table and its current primary and foreign keys, and
ALTER TABLE to add or remove constraints.

Simon

Relationship - Integrity Check - Burden on SQL

Dear Experts
While doing a Package i need to create a lot of relations for integrity
check. Am putting a burden on SQL Server for doing the hard work!
Question
Somewhere i read that it is better to do the integrity check from the front
end itself so that perfomances are not affected with many relationships in
force. What is the real style? or the right way to do? I am using MSDE 7.0
with VB
Thanks for your help
Manish Sawjiani
Three Cheers to Technet for the Help!
hi manish
Performing Integrity check from front-end is not a good practice. You will
be increasing
database hits by doing so and there by incereasing the network traffic.
This will definetely brings down the performance of your application.
Database Management Systems are designed to hold take database related loads.
If you perform integrity check in the front end then the integrity is
restricted.
i.e the check is done when you perform operations from frontend only, if
some one tries to
add data in the backend, the check is not performed and you will end up
having invalid data.
so dont wory and use Integrity check at backend itself
hope this answers your question. Is there anything that you would like to know
thanks and regards
Chandra
"Manish Sawjiani" wrote:

> Dear Experts
> While doing a Package i need to create a lot of relations for integrity
> check. Am putting a burden on SQL Server for doing the hard work!
> Question
> Somewhere i read that it is better to do the integrity check from the front
> end itself so that perfomances are not affected with many relationships in
> force. What is the real style? or the right way to do? I am using MSDE 7.0
> with VB
> Thanks for your help
> Manish Sawjiani
> --
> Three Cheers to Technet for the Help!

Relationship - Integrity Check - Burden on SQL

Dear Experts
While doing a Package i need to create a lot of relations for integrity
check. Am putting a burden on SQL Server for doing the hard work!
Question
Somewhere i read that it is better to do the integrity check from the front
end itself so that perfomances are not affected with many relationships in
force. What is the real style? or the right way to do? I am using MSDE 7.0
with VB
Thanks for your help
Manish Sawjiani
--
Three Cheers to Technet for the Help!hi manish
Performing Integrity check from front-end is not a good practice. You will
be increasing
database hits by doing so and there by incereasing the network traffic.
This will definetely brings down the performance of your application.
Database Management Systems are designed to hold take database related loads.
If you perform integrity check in the front end then the integrity is
restricted.
i.e the check is done when you perform operations from frontend only, if
some one tries to
add data in the backend, the check is not performed and you will end up
having invalid data.
so dont wory and use Integrity check at backend itself
hope this answers your question. Is there anything that you would like to know
thanks and regards
Chandra
"Manish Sawjiani" wrote:
> Dear Experts
> While doing a Package i need to create a lot of relations for integrity
> check. Am putting a burden on SQL Server for doing the hard work!
> Question
> Somewhere i read that it is better to do the integrity check from the front
> end itself so that perfomances are not affected with many relationships in
> force. What is the real style? or the right way to do? I am using MSDE 7.0
> with VB
> Thanks for your help
> Manish Sawjiani
> --
> Three Cheers to Technet for the Help!

Relationship - Integrity Check - Burden on SQL

Dear Experts
While doing a Package i need to create a lot of relations for integrity
check. Am putting a burden on SQL Server for doing the hard work!
Question
Somewhere i read that it is better to do the integrity check from the front
end itself so that perfomances are not affected with many relationships in
force. What is the real style? or the right way to do? I am using MSDE 7.0
with VB
Thanks for your help
Manish Sawjiani
Three Cheers to technet for the Help!hi manish
Performing Integrity check from front-end is not a good practice. You will
be increasing
database hits by doing so and there by incereasing the network traffic.
This will definetely brings down the performance of your application.
Database Management Systems are designed to hold take database related loads
.
If you perform integrity check in the front end then the integrity is
restricted.
i.e the check is done when you perform operations from frontend only, if
some one tries to
add data in the backend, the check is not performed and you will end up
having invalid data.
so dont wory and use Integrity check at backend itself
hope this answers your question. Is there anything that you would like to kn
ow
thanks and regards
Chandra
"Manish Sawjiani" wrote:

> Dear Experts
> While doing a Package i need to create a lot of relations for integrity
> check. Am putting a burden on SQL Server for doing the hard work!
> Question
> Somewhere i read that it is better to do the integrity check from the fron
t
> end itself so that perfomances are not affected with many relationships in
> force. What is the real style? or the right way to do? I am using MSDE 7.0
> with VB
> Thanks for your help
> Manish Sawjiani
> --
> Three Cheers to technet for the Help!

reindex one database with fatest way

Dear all,
How to re-index in one database with fastest way (not per-table) ?
Regards,
Koronx
SQL Hobbistphysically, how would you imagine that? Index is strictly related to table
so reindexing also has to be done per table.
Peter
"Kornx Koronx" <KornxKoronx@.discussions.microsoft.com> wrote in message
news:1A8C4AA7-85BF-4C5F-8B64-FAF0E98B2E28@.microsoft.com...
> Dear all,
> How to re-index in one database with fastest way (not per-table) ?
> Regards,
> Koronx
> SQL Hobbist

registry access

Dear Professional
Through Sql Server Stored procedure can I fetch the userid and password
which saved in Registry.
Thanks
NOOR
hi Noor,
"Noor" <noor@.ngsol.com> ha scritto nel messaggio
news:%23SKzZyyuEHA.1264@.TK2MSFTNGP12.phx.gbl
> Dear Professional
> Through Sql Server Stored procedure can I fetch the userid and
> password which saved in Registry.
> Thanks
> NOOR
you can have a look at xp_regread undocumented strored procedure...
http://www.mssqlcity.com/FAQ/Devel/xp_regread.htm
please note that undocumented features can be modified/dropped at any time,
without notification... and there's no support for them
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Register SQL Server BCP.exe utility

Dear All,

I am facing problem related bulk copy program utility. I have both SQL Server 2000 and SQL server 2005 installed on my PC. The current registered BCP.exe is of version 8.0. When i give command BCP.exe with database of SQL Server 2005 on command prompt it actually check the database in SQL Server 2000. The problem resolved if i the complete directry path is selected i-e C:\Program Files\Microsoft SQL Server\90\Tools\Binn. But i want to enter command on every selected directry on command prompt.

Regards

Haseeb Ahmad

I'm not certain what you're asking here - but if you want the 2005 version of BCP to be the default, change your PATH variable in the operating system to have the binary directories for SQL Server 2005 to be above the ones for SQL Server 2000. You can also create a batch file in the operating system to use instead of calling BCP.EXE that has the full path in it if you don't want to change the PATH variable.|||

Thanks a lot for your help. After changing the path in enviornment variable, the problem has been resolved.

Once again thank you for your cooperation.

Haseeb Ahmad