Database has invalid owner

I get this error when I try to view the database diagram. This is strange because it was about two weeks ago that I created and edited the database diagram. What is wrong with my login now as compared to when I did those edits?

The error suggests to use the ALTER AUTHORIZATION to change to a valid login. I am using windows authentication. If my login (the database ownere) is not the valid login then who is?

And what are the database diagram support objects that it suggests I install. I never heard of them, and where are they? Why didn't I need to install anything special when I worked on the diagrams two weeks ago?

Error message:

TITLE: Microsoft SQL Server Management Studio Express

Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects.

BUTTONS:
OK

Does anyone have any suggestions?

dbuchanan

Right click the database in question and select "properties". Select the "Files" from 'Select a Page' on the left side.

On the right side browse or add the owner that you want.

If things dont work then try using the sa owner. I also faced the same problem but when I sed the sa login then it worked wonders.

Xavier

sql

Database has invalid owner

I get this error when I try to view the database diagram. This is strange because it was about two weeks ago that I created and edited the database diagram. What is wrong with my login now as compared to when I did those edits?

The error suggests to use the ALTER AUTHORIZATION to change to a valid login. I am using windows authentication. If my login (the database ownere) is not the valid login then who is?

And what are the database diagram support objects that it suggests I install. I never heard of them, and where are they? Why didn't I need to install anything special when I worked on the diagrams two weeks ago?

Error message:

TITLE: Microsoft SQL Server Management Studio Express

Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects.

BUTTONS:
OK

Does anyone have any suggestions?

dbuchanan

Right click the database in question and select "properties". Select the "Files" from 'Select a Page' on the left side.

On the right side browse or add the owner that you want.

If things dont work then try using the sa owner. I also faced the same problem but when I sed the sa login then it worked wonders.

Xavier

Database growing unexpectedly

Hi all,
Running sql2000 ee SP4 on win2003.
I have a small database which havent been inserted/updated since it was
created 6 months ago. No DDL changes. This database was about 1,5 Mb for
the first months, but have started to grow. The size is now 30 Mb and it
is growing with about 2 Mb a month. It is set to autogrow with 10%.
Can someone explain this growth?
name rows reserved
form_lang 1 56 KB
grid_expr 0 0 KB
GridViewCategory 0 0 KB
GridViewDefinition 0 0 KB
hierarchy_tables 0 0 KB
invitation 0 0 KB
iteration 1 24 KB
lookup 0 0 KB
lookup_lang 0 0 KB
PanelistCredit 0 0 KB
quota 1 56 KB
response_control 2 104 KB
response1 0 0 KB
SampleLog 0 0 KB
weightmodel 0 0 KB
weightmodelform 0 0 KBTry running DBCC UPDATEUSAGE(0) and report back the space used.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"Gurba" <gurbao@.hotmail.com> wrote in message
news:Xns977AEC59B7F29gurbaohotmailcom@.129.250.171.65...
Hi all,
Running sql2000 ee SP4 on win2003.
I have a small database which havent been inserted/updated since it was
created 6 months ago. No DDL changes. This database was about 1,5 Mb for
the first months, but have started to grow. The size is now 30 Mb and it
is growing with about 2 Mb a month. It is set to autogrow with 10%.
Can someone explain this growth?
name rows reserved
form_lang 1 56 KB
grid_expr 0 0 KB
GridViewCategory 0 0 KB
GridViewDefinition 0 0 KB
hierarchy_tables 0 0 KB
invitation 0 0 KB
iteration 1 24 KB
lookup 0 0 KB
lookup_lang 0 0 KB
PanelistCredit 0 0 KB
quota 1 56 KB
response_control 2 104 KB
response1 0 0 KB
SampleLog 0 0 KB
weightmodel 0 0 KB
weightmodelform 0 0 KB|||"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in news:#noh#6kPGHA.1532
@.TK2MSFTNGP12.phx.gbl:
> Try running DBCC UPDATEUSAGE(0) and report back the space used.
>
Hi,
seems the first output from
USE MyDb; EXEC sp_MSforeachtable 'EXEC sp_spaceused [?]'
was missing some tables...
I ran UpdateUsage and the sp_spaceused again and found the reason for the
growth.
Case closed :-)
Thanks,sql

Database files are "Hidden" after becoming Suspect

We had created some databases on the C Drive. Today the C drive went bad and
all the databases that
were on the C Drive became suspect.
I tried to copy the files onto another drive and I did to the D drive.
However, when I tried to attach the
datafile the data file was not showing up. I checked the properties and the
file's "Read Only" attribute was checked.
I unchecked it. However, the "Hidden" attribute has been greyed out and
looks like this is the reason why
the files are not showing up.
Would someone know how to address this problem ?
Thanks,
rgn
Hi
This is an OS issue, but here goes:
Run
ATTRIB
This returns all the files that are hidden in the current directory.
If some of your files are listed, run
ATTRIB -H <filename.ext>
This will remove the Hidden attribute on the file.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"rgn" <gopinathr@.healthasyst.com> wrote in message
news:OUyfFwoEFHA.3244@.TK2MSFTNGP15.phx.gbl...
> We had created some databases on the C Drive. Today the C drive went bad
and
> all the databases that
> were on the C Drive became suspect.
> I tried to copy the files onto another drive and I did to the D drive.
> However, when I tried to attach the
> datafile the data file was not showing up. I checked the properties and
the
> file's "Read Only" attribute was checked.
> I unchecked it. However, the "Hidden" attribute has been greyed out and
> looks like this is the reason why
> the files are not showing up.
> Would someone know how to address this problem ?
> Thanks,
> rgn
>

Database files are "Hidden" after becoming Suspect

We had created some databases on the C Drive. Today the C drive went bad and
all the databases that
were on the C Drive became suspect.
I tried to copy the files onto another drive and I did to the D drive.
However, when I tried to attach the
datafile the data file was not showing up. I checked the properties and the
file's "Read Only" attribute was checked.
I unchecked it. However, the "Hidden" attribute has been greyed out and
looks like this is the reason why
the files are not showing up.
Would someone know how to address this problem ?
Thanks,
rgnHi
This is an OS issue, but here goes:
Run
ATTRIB
This returns all the files that are hidden in the current directory.
If some of your files are listed, run
ATTRIB -H <filename.ext>
This will remove the Hidden attribute on the file.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"rgn" <gopinathr@.healthasyst.com> wrote in message
news:OUyfFwoEFHA.3244@.TK2MSFTNGP15.phx.gbl...
> We had created some databases on the C Drive. Today the C drive went bad
and
> all the databases that
> were on the C Drive became suspect.
> I tried to copy the files onto another drive and I did to the D drive.
> However, when I tried to attach the
> datafile the data file was not showing up. I checked the properties and
the
> file's "Read Only" attribute was checked.
> I unchecked it. However, the "Hidden" attribute has been greyed out and
> looks like this is the reason why
> the files are not showing up.
> Would someone know how to address this problem ?
> Thanks,
> rgn
>

Database files are "Hidden" after becoming Suspect

We had created some databases on the C Drive. Today the C drive went bad and
all the databases that
were on the C Drive became suspect.
I tried to copy the files onto another drive and I did to the D drive.
However, when I tried to attach the
datafile the data file was not showing up. I checked the properties and the
file's "Read Only" attribute was checked.
I unchecked it. However, the "Hidden" attribute has been greyed out and
looks like this is the reason why
the files are not showing up.
Would someone know how to address this problem ?
Thanks,
rgnHi
This is an OS issue, but here goes:
Run
ATTRIB
This returns all the files that are hidden in the current directory.
If some of your files are listed, run
ATTRIB -H <filename.ext>
This will remove the Hidden attribute on the file.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"rgn" <gopinathr@.healthasyst.com> wrote in message
news:OUyfFwoEFHA.3244@.TK2MSFTNGP15.phx.gbl...
> We had created some databases on the C Drive. Today the C drive went bad
and
> all the databases that
> were on the C Drive became suspect.
> I tried to copy the files onto another drive and I did to the D drive.
> However, when I tried to attach the
> datafile the data file was not showing up. I checked the properties and
the
> file's "Read Only" attribute was checked.
> I unchecked it. However, the "Hidden" attribute has been greyed out and
> looks like this is the reason why
> the files are not showing up.
> Would someone know how to address this problem ?
> Thanks,
> rgn
>

Database file and log

Hi,

I am just about to get familiar with SQL-Server 2005. Since I created a database and played a little with it I recognized that the database file has grown up to 150 MB as well as the log file.

I used the shrink task to resize the database file. After doing so the .ldf remained as it was (150 MB). Since I would not need log information stored there, is it possible to shrink the ldf-file as well?

Thanks for your help!

Hi,

have a look here: http://www.aspfaq.com/show.asp?id=2471

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||rather than shrink the log file every single time, you can set the recovery model to SIMPLE for the database, which uses minimal disk space for the log file. See ALTER DATABASE on books online.|||

Hi,

but keep in mind that with your setting backup mode to simple you might loose some features of your implemented database backpup strategy. Read more about this in the BOL under "Rovery models".

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||Thanks to both of you I could finally learn something about the log files and also resolve my problem.

Database file and log

Hi,

I am just about to get familiar with SQL-Server 2005. Since I created a database and played a little with it I recognized that the database file has grown up to 150 MB as well as the log file.

I used the shrink task to resize the database file. After doing so the .ldf remained as it was (150 MB). Since I would not need log information stored there, is it possible to shrink the ldf-file as well?

Thanks for your help!

Hi,

have a look here: http://www.aspfaq.com/show.asp?id=2471

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||rather than shrink the log file every single time, you can set the recovery model to SIMPLE for the database, which uses minimal disk space for the log file. See ALTER DATABASE on books online.|||

Hi,

but keep in mind that with your setting backup mode to simple you might loose some features of your implemented database backpup strategy. Read more about this in the BOL under "Rovery models".

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||Thanks to both of you I could finally learn something about the log files and also resolve my problem.

Database display/manipulation

I have a web page called homepage.aspx created in Visual Studio 2005 using VB. It contains some hyperlinks on the left side. I have a database created in SQL Server 2005. I need to add, delete, edit, update data in the database directly from this same page. How can I achieve this?. i.e is it possible to, say, have a form on a section of this same web page that would allow me to directly manipulate/modify and update the database? (If you may give code, you may use abstract names for the database, tables and column and/or field names-I will understand). Many thanks in advance.

Yes, what you want to do is possible - and is one of the main points behind ASP.NET. You need to read some of the many free tutorials that are available. It's not the sort of thing anyone can describe in useful detail in a reply to a post in this forum. Here are a couple:

http://msconline.maconstate.edu/tutorials/ASPNET20/default.htm
http://quickstarts.asp.net/QuickStartv20/aspnet/doc/data/default.aspx

|||

The links above are useful in this regard. The question I have is a bit different. I have arleady written the code to manipulate the database using GridView control. This ofcourse works in conjunction with the SqlDataSource control. The SqlDataSource control permits selecting a single database table at a time for actions of delete, add, edit etc. This means that if I need to do the above actions on many tables, I will need to reconfigure the SqlDataSource for each table. This also means that I will be able to delete, add, update data in all tables by using a number of web pages as each each table manipulation will have to be done via a seperate web page. This is ok but is very usable. I want to put,say, a form on just one web page and then this form will allow me to perform actions of add, delete, update etc on all tables using just this page. In brief: How can I fit a form on the existing web page and use this form to add, delete, udate the entire database data?.

|||The SqlDataSource will take any valid SQL or the name of a stored procedure for its CommandText property. You can assign this value at runtime in the code-behind. Most applications of the type you are describing tend to not show one "table" at a time - they show data from related tables using joins. Each data maintenance task usually has its own page/form, so adding/editing/deleting a story, for example would all be managed from one page, whereas adding/editing/deleting a contact would be done on a different one. You could do it all in one page, but I would never do so. Maintenance of code would be a mightmare.

database diagrams

Using SQL 2005, I am not able to access existing database diagrams created i
n
SQL 2000. It tells me there is no valid owner for the database and can not
install the diagram support objects. The database properties say SA is the
owner and that is also how I am connected. I have tried everything I can
think of to get to the diagrams.
Any help would be appreciated.You need to set the database compatibility level of the database to 90. You
can do this by running the following statement, or by selecting the
Properties page of the database in SQL Server Mangement Studio.
EXEC sp_dbcmptlevel <database_name> , 90
This is documented in the readme, but is easy to miss. The Books Online
topics on database diagrams will be updated with this information in the
April download of BOL.
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
"Richard Kohler" <Richard Kohler@.discussions.microsoft.com> wrote in message
news:EDC8EBA9-E131-4553-B965-82FE1AD38CA7@.microsoft.com...
> Using SQL 2005, I am not able to access existing database diagrams created
> in
> SQL 2000. It tells me there is no valid owner for the database and can not
> install the diagram support objects. The database properties say SA is the
> owner and that is also how I am connected. I have tried everything I can
> think of to get to the diagrams.
> Any help would be appreciated.|||That worked! Thank you for your quick reply.
"Gail Erickson [MS]" wrote:

> You need to set the database compatibility level of the database to 90. Y
ou
> can do this by running the following statement, or by selecting the
> Properties page of the database in SQL Server Mangement Studio.
> EXEC sp_dbcmptlevel <database_name> , 90
> This is documented in the readme, but is easy to miss. The Books Online
> topics on database diagrams will be updated with this information in the
> April download of BOL.
> --
> Gail Erickson [MS]
> SQL Server Documentation Team
> This posting is provided "AS IS" with no warranties, and confers no rights
> "Richard Kohler" <Richard Kohler@.discussions.microsoft.com> wrote in messa
ge
> news:EDC8EBA9-E131-4553-B965-82FE1AD38CA7@.microsoft.com...
>
>

Database diagrams

Hi
I'm trying to view a SQL 2000 Diagram that was created by my colleage. When
I click on "Design Diagram" it appears blank (ie it does show any of the
table links). However if I create a diagram I can view that and my colleage I
can view the diagram that I've created and my colleage can also view it.
Any ideas.
TIA
Dwight
Dwight,
Did you apply Visual Studio Service Pack 6?
If so, this has happened to many people. I don't know if
there is a knowledge base article or supported fix for the
issue. Others have reported working around the issue by
installing an older version of mdt2df.dll
-Sue
On Mon, 10 Jan 2005 03:47:03 -0800, Dwight
<Dwight@.discussions.microsoft.com> wrote:

>Hi
>I'm trying to view a SQL 2000 Diagram that was created by my colleage. When
>I click on "Design Diagram" it appears blank (ie it does show any of the
>table links). However if I create a diagram I can view that and my colleage I
>can view the diagram that I've created and my colleage can also view it.
>Any ideas.
>TIA
>Dwight
|||Hi Sue,
Yes I have install VS SP6. I'll see if I can find an old version of
mdt2df.dll and reinstall it.
Thanks
"Sue Hoegemeier" wrote:

> Dwight,
> Did you apply Visual Studio Service Pack 6?
> If so, this has happened to many people. I don't know if
> there is a knowledge base article or supported fix for the
> issue. Others have reported working around the issue by
> installing an older version of mdt2df.dll
> -Sue
> On Mon, 10 Jan 2005 03:47:03 -0800, Dwight
> <Dwight@.discussions.microsoft.com> wrote:
>
>

Database diagrams

Hi
I'm trying to view a SQL 2000 Diagram that was created by my colleage. When
I click on "Design Diagram" it appears blank (ie it does show any of the
table links). However if I create a diagram I can view that and my colleage
I
can view the diagram that I've created and my colleage can also view it.
Any ideas.
TIA
DwightDwight,
Did you apply Visual Studio Service Pack 6?
If so, this has happened to many people. I don't know if
there is a knowledge base article or supported fix for the
issue. Others have reported working around the issue by
installing an older version of mdt2df.dll
-Sue
On Mon, 10 Jan 2005 03:47:03 -0800, Dwight
<Dwight@.discussions.microsoft.com> wrote:

>Hi
>I'm trying to view a SQL 2000 Diagram that was created by my colleage. When
>I click on "Design Diagram" it appears blank (ie it does show any of the
>table links). However if I create a diagram I can view that and my colleage
I
>can view the diagram that I've created and my colleage can also view it.
>Any ideas.
>TIA
>Dwight|||Hi Sue,
Yes I have install VS SP6. I'll see if I can find an old version of
mdt2df.dll and reinstall it.
Thanks
"Sue Hoegemeier" wrote:

> Dwight,
> Did you apply Visual Studio Service Pack 6?
> If so, this has happened to many people. I don't know if
> there is a knowledge base article or supported fix for the
> issue. Others have reported working around the issue by
> installing an older version of mdt2df.dll
> -Sue
> On Mon, 10 Jan 2005 03:47:03 -0800, Dwight
> <Dwight@.discussions.microsoft.com> wrote:
>
>

Database diagrams

Hi
I'm trying to view a SQL 2000 Diagram that was created by my colleage. When
I click on "Design Diagram" it appears blank (ie it does show any of the
table links). However if I create a diagram I can view that and my colleage I
can view the diagram that I've created and my colleage can also view it.
Any ideas.
TIA
DwightDwight,
Did you apply Visual Studio Service Pack 6?
If so, this has happened to many people. I don't know if
there is a knowledge base article or supported fix for the
issue. Others have reported working around the issue by
installing an older version of mdt2df.dll
-Sue
On Mon, 10 Jan 2005 03:47:03 -0800, Dwight
<Dwight@.discussions.microsoft.com> wrote:
>Hi
>I'm trying to view a SQL 2000 Diagram that was created by my colleage. When
>I click on "Design Diagram" it appears blank (ie it does show any of the
>table links). However if I create a diagram I can view that and my colleage I
>can view the diagram that I've created and my colleage can also view it.
>Any ideas.
>TIA
>Dwight|||Hi Sue,
Yes I have install VS SP6. I'll see if I can find an old version of
mdt2df.dll and reinstall it.
Thanks
"Sue Hoegemeier" wrote:
> Dwight,
> Did you apply Visual Studio Service Pack 6?
> If so, this has happened to many people. I don't know if
> there is a knowledge base article or supported fix for the
> issue. Others have reported working around the issue by
> installing an older version of mdt2df.dll
> -Sue
> On Mon, 10 Jan 2005 03:47:03 -0800, Dwight
> <Dwight@.discussions.microsoft.com> wrote:
> >Hi
> >
> >I'm trying to view a SQL 2000 Diagram that was created by my colleage. When
> >I click on "Design Diagram" it appears blank (ie it does show any of the
> >table links). However if I create a diagram I can view that and my colleage I
> >can view the diagram that I've created and my colleage can also view it.
> >
> >Any ideas.
> >
> >TIA
> >Dwight
>

database diagram in server explorer

I've created a connection to an SQL 2000 server in an asp.net 2.0 web application using Visual Studio 2005. When I view the database node in the server explorer, it doesn't show the database diagram node. Is there something I need to load to make this node appear? Thanks.

You might want to post this question to the Visual Studio group. I can't recall if this facility is version dependent. They would be able to better answer your question.

Terrence Nevins

SQL Server Program Manager

|||

Unfortunately, Management Studio 2005 and Visual Studio 2005 cannot work with diagrams on SQL Server 2000 servers.

Best regards,
Steve

database diagram in server explorer

I've created a connection to an SQL 2000 server in an asp.net 2.0 web application using Visual Studio 2005. When I view the database node in the server explorer, it doesn't show the database diagram node. Is there something I need to load to make this node appear? Thanks.

You might want to post this question to the Visual Studio group. I can't recall if this facility is version dependent. They would be able to better answer your question.

Terrence Nevins

SQL Server Program Manager

|||

Unfortunately, Management Studio 2005 and Visual Studio 2005 cannot work with diagrams on SQL Server 2000 servers.

Best regards,
Steve

Database Diagram

Hi,
I created a database with diagram in ServerA. After that I backup and
restore this database in ServerB. I try to open the database diagram in
ServerB, but it show empty. Is there anyone know why like that?
Thanks,
Kenny
Kenny
If I remember well a diagram is stored in dtproperties system table. Try
transfer the table into the new server.
"Kenny" <keejh@.hotmail.com> wrote in message
news:uvKbXSTdEHA.2520@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I created a database with diagram in ServerA. After that I backup and
> restore this database in ServerB. I try to open the database diagram in
> ServerB, but it show empty. Is there anyone know why like that?
> Thanks,
> Kenny
>
|||did you backup and restore the transaction log?
Another way is to detach the database from one server, copy it to the new
one, then attach the database to the new server
aoxpsql
"Kenny" <keejh@.hotmail.com> wrote in message
news:uvKbXSTdEHA.2520@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I created a database with diagram in ServerA. After that I backup and
> restore this database in ServerB. I try to open the database diagram in
> ServerB, but it show empty. Is there anyone know why like that?
> Thanks,
> Kenny
>
|||Hi,
Use the below link to transfer diagrams between servers.
http://support.microsoft.com/default...;en-us;Q320125
It is just copying the contents of dtproperties from source server to
destination as pointed by Uri. Since you the restored the same database, the
contents will be already there in destination.
Probably you have to delete the contents before you folow the link mentioned
above.
Thanks
Hari
MCDBA
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:u8xwqWTdEHA.3260@.TK2MSFTNGP09.phx.gbl...
> Kenny
> If I remember well a diagram is stored in dtproperties system table. Try
> transfer the table into the new server.
> "Kenny" <keejh@.hotmail.com> wrote in message
> news:uvKbXSTdEHA.2520@.TK2MSFTNGP12.phx.gbl...
>
|||Detach / Attach the database also having the same problem ...
"aoxpsql" <anonymous@.discussion.com> wrote in message
news:OcZnytTdEHA.1356@.TK2MSFTNGP09.phx.gbl...
> did you backup and restore the transaction log?
> Another way is to detach the database from one server, copy it to the new
> one, then attach the database to the new server
> aoxpsql
>
> "Kenny" <keejh@.hotmail.com> wrote in message
> news:uvKbXSTdEHA.2520@.TK2MSFTNGP12.phx.gbl...
>
|||Hi,
FYI,
I am using SQL Server 2000 in both ServerA and ServerB. The solution you
guys help me is when SQL 7.0 to SQL 2000 if I am not mistaken.
Again, I backup database from ServerA to ServerB but the disgram is
blank, but when I update the diagram in ServerB and transfer back to
ServerA, I can see it. Why?
Thanks,
Kenny
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||Hi Kenne,
Those steps mentioned in the old post will work for SQL 2000 as well. It
uses DTS to exports the dtproperties table from source and load it in
detination.
Please delete the contents of destination before running the DTS.
FYI, I can see the diagrams after restoring the database to a different
server.
Thanks
Hari
MCDBA
"Kenny Kee" <keejh@.hotmail.com> wrote in message
news:#VSNHNVdEHA.3132@.TK2MSFTNGP11.phx.gbl...
> Hi,
> FYI,
> I am using SQL Server 2000 in both ServerA and ServerB. The solution you
> guys help me is when SQL 7.0 to SQL 2000 if I am not mistaken.
> Again, I backup database from ServerA to ServerB but the disgram is
> blank, but when I update the diagram in ServerB and transfer back to
> ServerA, I can see it. Why?
> Thanks,
> Kenny
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
|||Hi Hari,
I still not able to view the diagram with your suggestion.
Here is another testing.
remarks:
-> Backup and Restore Process
ServerA -> ServerB
In ServerB, the ServerADiagram is blank. I created another Diagram in
ServerBDiagram
ServerB -> ServerA
I can view ServerADiagram and ServerBDiagram
- If i didnt update the ServerBDiagram and ServerA -> ServerB, I still can
view the ServerBDiagram in ServerB
- If i update the ServerBDiagram in ServerA, and ServerA -> ServerB, now i
cant view the ServerBDiagram in ServerB
So, it looks like some permission block it after update and cause the
problem to view it?
Thanks,
Kenny
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:uNkB$4VdEHA.2544@.TK2MSFTNGP10.phx.gbl...
> Hi Kenne,
> Those steps mentioned in the old post will work for SQL 2000 as well. It
> uses DTS to exports the dtproperties table from source and load it in
> detination.
> Please delete the contents of destination before running the DTS.
> FYI, I can see the diagrams after restoring the database to a different
> server.
>
> Thanks
> Hari
> MCDBA
>
> "Kenny Kee" <keejh@.hotmail.com> wrote in message
> news:#VSNHNVdEHA.3132@.TK2MSFTNGP11.phx.gbl...
>

Database Diagram

Hi,
I created a database with diagram in ServerA. After that I backup and
restore this database in ServerB. I try to open the database diagram in
ServerB, but it show empty. Is there anyone know why like that?
Thanks,
KennyKenny
If I remember well a diagram is stored in dtproperties system table. Try
transfer the table into the new server.
"Kenny" <keejh@.hotmail.com> wrote in message
news:uvKbXSTdEHA.2520@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I created a database with diagram in ServerA. After that I backup and
> restore this database in ServerB. I try to open the database diagram in
> ServerB, but it show empty. Is there anyone know why like that?
> Thanks,
> Kenny
>|||did you backup and restore the transaction log?
Another way is to detach the database from one server, copy it to the new
one, then attach the database to the new server
aoxpsql
"Kenny" <keejh@.hotmail.com> wrote in message
news:uvKbXSTdEHA.2520@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I created a database with diagram in ServerA. After that I backup and
> restore this database in ServerB. I try to open the database diagram in
> ServerB, but it show empty. Is there anyone know why like that?
> Thanks,
> Kenny
>|||Hi,
Use the below link to transfer diagrams between servers.
http://support.microsoft.com/defaul...b;en-us;Q320125
It is just copying the contents of dtproperties from source server to
destination as pointed by Uri. Since you the restored the same database, the
contents will be already there in destination.
Probably you have to delete the contents before you folow the link mentioned
above.
Thanks
Hari
MCDBA
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:u8xwqWTdEHA.3260@.TK2MSFTNGP09.phx.gbl...
> Kenny
> If I remember well a diagram is stored in dtproperties system table. Try
> transfer the table into the new server.
> "Kenny" <keejh@.hotmail.com> wrote in message
> news:uvKbXSTdEHA.2520@.TK2MSFTNGP12.phx.gbl...
>|||Detach / Attach the database also having the same problem ...
"aoxpsql" <anonymous@.discussion.com> wrote in message
news:OcZnytTdEHA.1356@.TK2MSFTNGP09.phx.gbl...
> did you backup and restore the transaction log?
> Another way is to detach the database from one server, copy it to the new
> one, then attach the database to the new server
> aoxpsql
>
> "Kenny" <keejh@.hotmail.com> wrote in message
> news:uvKbXSTdEHA.2520@.TK2MSFTNGP12.phx.gbl...
>|||Hi,
FYI,
I am using SQL Server 2000 in both ServerA and ServerB. The solution you
guys help me is when SQL 7.0 to SQL 2000 if I am not mistaken.
Again, I backup database from ServerA to ServerB but the disgram is
blank, but when I update the diagram in ServerB and transfer back to
ServerA, I can see it. Why?
Thanks,
Kenny
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!|||Hi Kenne,
Those steps mentioned in the old post will work for SQL 2000 as well. It
uses DTS to exports the dtproperties table from source and load it in
detination.
Please delete the contents of destination before running the DTS.
FYI, I can see the diagrams after restoring the database to a different
server.
Thanks
Hari
MCDBA
"Kenny Kee" <keejh@.hotmail.com> wrote in message
news:#VSNHNVdEHA.3132@.TK2MSFTNGP11.phx.gbl...
> Hi,
> FYI,
> I am using SQL Server 2000 in both ServerA and ServerB. The solution you
> guys help me is when SQL 7.0 to SQL 2000 if I am not mistaken.
> Again, I backup database from ServerA to ServerB but the disgram is
> blank, but when I update the diagram in ServerB and transfer back to
> ServerA, I can see it. Why?
> Thanks,
> Kenny
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!|||Hi Hari,
I still not able to view the diagram with your suggestion.
Here is another testing.
remarks:
-> Backup and Restore Process
ServerA -> ServerB
In ServerB, the ServerADiagram is blank. I created another Diagram in
ServerBDiagram
ServerB -> ServerA
I can view ServerADiagram and ServerBDiagram
- If i didnt update the ServerBDiagram and ServerA -> ServerB, I still can
view the ServerBDiagram in ServerB
- If i update the ServerBDiagram in ServerA, and ServerA -> ServerB, now i
cant view the ServerBDiagram in ServerB
So, it looks like some permission block it after update and cause the
problem to view it?
Thanks,
Kenny
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:uNkB$4VdEHA.2544@.TK2MSFTNGP10.phx.gbl...
> Hi Kenne,
> Those steps mentioned in the old post will work for SQL 2000 as well. It
> uses DTS to exports the dtproperties table from source and load it in
> detination.
> Please delete the contents of destination before running the DTS.
> FYI, I can see the diagrams after restoring the database to a different
> server.
>
> Thanks
> Hari
> MCDBA
>
> "Kenny Kee" <keejh@.hotmail.com> wrote in message
> news:#VSNHNVdEHA.3132@.TK2MSFTNGP11.phx.gbl...
>

Database Diagram

Hi,
I created a database with diagram in ServerA. After that I backup and
restore this database in ServerB. I try to open the database diagram in
ServerB, but it show empty. Is there anyone know why like that?
Thanks,
KennyKenny
If I remember well a diagram is stored in dtproperties system table. Try
transfer the table into the new server.
"Kenny" <keejh@.hotmail.com> wrote in message
news:uvKbXSTdEHA.2520@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I created a database with diagram in ServerA. After that I backup and
> restore this database in ServerB. I try to open the database diagram in
> ServerB, but it show empty. Is there anyone know why like that?
> Thanks,
> Kenny
>|||did you backup and restore the transaction log?
Another way is to detach the database from one server, copy it to the new
one, then attach the database to the new server
aoxpsql
"Kenny" <keejh@.hotmail.com> wrote in message
news:uvKbXSTdEHA.2520@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I created a database with diagram in ServerA. After that I backup and
> restore this database in ServerB. I try to open the database diagram in
> ServerB, but it show empty. Is there anyone know why like that?
> Thanks,
> Kenny
>|||Hi,
Use the below link to transfer diagrams between servers.
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q320125
It is just copying the contents of dtproperties from source server to
destination as pointed by Uri. Since you the restored the same database, the
contents will be already there in destination.
Probably you have to delete the contents before you folow the link mentioned
above.
Thanks
Hari
MCDBA
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:u8xwqWTdEHA.3260@.TK2MSFTNGP09.phx.gbl...
> Kenny
> If I remember well a diagram is stored in dtproperties system table. Try
> transfer the table into the new server.
> "Kenny" <keejh@.hotmail.com> wrote in message
> news:uvKbXSTdEHA.2520@.TK2MSFTNGP12.phx.gbl...
> > Hi,
> >
> > I created a database with diagram in ServerA. After that I backup and
> > restore this database in ServerB. I try to open the database diagram in
> > ServerB, but it show empty. Is there anyone know why like that?
> >
> > Thanks,
> > Kenny
> >
> >
>|||Detach / Attach the database also having the same problem ...
"aoxpsql" <anonymous@.discussion.com> wrote in message
news:OcZnytTdEHA.1356@.TK2MSFTNGP09.phx.gbl...
> did you backup and restore the transaction log?
> Another way is to detach the database from one server, copy it to the new
> one, then attach the database to the new server
> aoxpsql
>
> "Kenny" <keejh@.hotmail.com> wrote in message
> news:uvKbXSTdEHA.2520@.TK2MSFTNGP12.phx.gbl...
> > Hi,
> >
> > I created a database with diagram in ServerA. After that I backup and
> > restore this database in ServerB. I try to open the database diagram in
> > ServerB, but it show empty. Is there anyone know why like that?
> >
> > Thanks,
> > Kenny
> >
> >
>

Database Design Assistance

I have 2 tables that will be created from flat files and recreated on a
daily basis with 300,000+ records and growing daily (tables will be
truncated and re-loaded via a batch process because we do not "own" the
data). I would like to extract the address information from these
tables and create a simple database design that will be relational and
efficient (there are additional Customer and Account fields but these
are the fields currently of interest).
Customer [table name]
TaxID [PK]
Addr1
Addr2
City
State
Zip
Country
MAddr1
MAddr2
MCity
MState
MZip
MCountry
Account [table name]
AccountNumber [PK]
TaxID
SecTaxID
Addr1
Addr2
City
State
Zip
Country
Every Customer in Customer table will have 2 addresses per TaxID,
Mailing and Physical even if they are the same. Every AccountNumber
will have exactly 1 address (Mailing) associated with it. So, if you
are a customer with 2 accounts, you would have 1 record in the customer
table (with both address and Mailing address populated) and 2 records
in the Account table. All 4 addresses could be the same or unique.
Mailings will EITHER go out at the Account level OR the Customer level
so I'm not sure if it is beneficial to combine the addresses into one
table or just create some sort of Account address table and another
customer address table but then i get one-to-one relationships and I'm
not sure how beneficial that is. This is how the data will be received
from the vendor and there isn't any leeway there. Any assistance that
could be provided would be greatly appreciated.Hi
If you do not store all the addresses as received you will probably end up
with a data cleansing excercise to make sure that you are not duplicating th
e
same address that is input slightly differently. Moving the address out to
another table will be a good idea if you have occassions to retrieve the
customer/account information without the address details. I would start with
a normalised design and if performance is being severely compromised you can
then de-normalise.
John
"jasonl22@.yahoo.com" wrote:

> I have 2 tables that will be created from flat files and recreated on a
> daily basis with 300,000+ records and growing daily (tables will be
> truncated and re-loaded via a batch process because we do not "own" the
> data). I would like to extract the address information from these
> tables and create a simple database design that will be relational and
> efficient (there are additional Customer and Account fields but these
> are the fields currently of interest).
> Customer [table name]
> TaxID [PK]
> Addr1
> Addr2
> City
> State
> Zip
> Country
> MAddr1
> MAddr2
> MCity
> MState
> MZip
> MCountry
> Account [table name]
> AccountNumber [PK]
> TaxID
> SecTaxID
> Addr1
> Addr2
> City
> State
> Zip
> Country
> Every Customer in Customer table will have 2 addresses per TaxID,
> Mailing and Physical even if they are the same. Every AccountNumber
> will have exactly 1 address (Mailing) associated with it. So, if you
> are a customer with 2 accounts, you would have 1 record in the customer
> table (with both address and Mailing address populated) and 2 records
> in the Account table. All 4 addresses could be the same or unique.
> Mailings will EITHER go out at the Account level OR the Customer level
> so I'm not sure if it is beneficial to combine the addresses into one
> table or just create some sort of Account address table and another
> customer address table but then i get one-to-one relationships and I'm
> not sure how beneficial that is. This is how the data will be received
> from the vendor and there isn't any leeway there. Any assistance that
> could be provided would be greatly appreciated.
>|||so you import it exactly as it comes from your source. that is life,
and how it is done. .
from there, you have an account table, that ONLY has accountnumber,
taxid, and maybe sectaxid depending on what the heck sectaxid is.
you will have an "address table." it will have primary key of
Taxid,Addresstype
AddressType
TaxID
Addr1
Addr2
City
State
Zip
You will have an addresstype table.
it will have
addresstype (M or P)
AddressDescr (Either "Mailing or Physical)|||Jason,
I'd go for something like
Customer [table name]
TaxID [PK]
Physical_address_id
-- both could point to the same row
mailing_address_id
SInce one and the same addres can be both physical and mailing, I'd
rather not have address_type column in address table|||my answer was more normalized......

Database Design Assistance

I have 2 tables that will be created from flat files and recreated on a
daily basis with 300,000+ records and growing daily (tables will be
truncated and re-loaded via a batch process because we do not "own" the
data). I would like to extract the address information from these
tables and create a simple database design that will be relational and
efficient (there are additional Customer and Account fields but these
are the fields currently of interest).
Customer [table name]
TaxID [PK]
Addr1
Addr2
City
State
Zip
Country
MAddr1
MAddr2
MCity
MState
MZip
MCountry
Account [table name]
AccountNumber [PK]
TaxID
SecTaxID
Addr1
Addr2
City
State
Zip
Country
Every Customer in Customer table will have 2 addresses per TaxID,
Mailing and Physical even if they are the same. Every AccountNumber
will have exactly 1 address (Mailing) associated with it. So, if you
are a customer with 2 accounts, you would have 1 record in the customer
table (with both address and Mailing address populated) and 2 records
in the Account table. All 4 addresses could be the same or unique.
Mailings will EITHER go out at the Account level OR the Customer level
so I'm not sure if it is beneficial to combine the addresses into one
table or just create some sort of Account address table and another
customer address table but then i get one-to-one relationships and I'm
not sure how beneficial that is. This is how the data will be received
from the vendor and there isn't any leeway there. Any assistance that
could be provided would be greatly appreciated.Hi
If you do not store all the addresses as received you will probably end up
with a data cleansing excercise to make sure that you are not duplicating the
same address that is input slightly differently. Moving the address out to
another table will be a good idea if you have occassions to retrieve the
customer/account information without the address details. I would start with
a normalised design and if performance is being severely compromised you can
then de-normalise.
John
"jasonl22@.yahoo.com" wrote:
> I have 2 tables that will be created from flat files and recreated on a
> daily basis with 300,000+ records and growing daily (tables will be
> truncated and re-loaded via a batch process because we do not "own" the
> data). I would like to extract the address information from these
> tables and create a simple database design that will be relational and
> efficient (there are additional Customer and Account fields but these
> are the fields currently of interest).
> Customer [table name]
> TaxID [PK]
> Addr1
> Addr2
> City
> State
> Zip
> Country
> MAddr1
> MAddr2
> MCity
> MState
> MZip
> MCountry
> Account [table name]
> AccountNumber [PK]
> TaxID
> SecTaxID
> Addr1
> Addr2
> City
> State
> Zip
> Country
> Every Customer in Customer table will have 2 addresses per TaxID,
> Mailing and Physical even if they are the same. Every AccountNumber
> will have exactly 1 address (Mailing) associated with it. So, if you
> are a customer with 2 accounts, you would have 1 record in the customer
> table (with both address and Mailing address populated) and 2 records
> in the Account table. All 4 addresses could be the same or unique.
> Mailings will EITHER go out at the Account level OR the Customer level
> so I'm not sure if it is beneficial to combine the addresses into one
> table or just create some sort of Account address table and another
> customer address table but then i get one-to-one relationships and I'm
> not sure how beneficial that is. This is how the data will be received
> from the vendor and there isn't any leeway there. Any assistance that
> could be provided would be greatly appreciated.
>|||so you import it exactly as it comes from your source. that is life,
and how it is done. .
from there, you have an account table, that ONLY has accountnumber,
taxid, and maybe sectaxid depending on what the heck sectaxid is.
you will have an "address table." it will have primary key of
Taxid,Addresstype
AddressType
TaxID
Addr1
Addr2
City
State
Zip
You will have an addresstype table.
it will have
addresstype (M or P)
AddressDescr (Either "Mailing or Physical)|||Jason,
I'd go for something like
Customer [table name]
TaxID [PK]
Physical_address_id
-- both could point to the same row
mailing_address_id
SInce one and the same addres can be both physical and mailing, I'd
rather not have address_type column in address table|||my answer was more normalized......