Database I/O error

I am using SQL 2000 Dev edition. I create a DB on box
1. I run a simple program that loops through all records
in a table. It works fine. (VBA Code in MS Access
accessing the SQL table via ADO if it matters.) I then
detach the database and copy the file, plus log file, to
Box 2.
I attach the database on Box 2 and run the same code to
loop through all records in the table. It fails with an
I/O error 998 (Invalid access to memory location)
detected during read at offset 0x00000b8f1e0000 in
file 'My DB File'
It does not always stop at the same point. When I check,
it shows EOF to be true - even though a counter shows I
am less than 30% of the way through the file.
Is there some form of utility to check the validity of
the DB? I ran a ShrinkDatabase on box 1. Then copied
the file to box 2 again. Same results.
Known differences:
- Hardware.
- OS. (Can that really matter?)
- Box1 = Win2003 Server.
- Box2 = Win XP Pro SP1
Both boxes are SQL 2000 Developers edition SP3.
I'm pulling my hair out on this. Any help is greatly
appreciated.
Thank you.
Sounds like a hardware issue, I have seen similar problems just prior to a
hard disk crapping out. Have you run any disk checking utilities against
the problem machine? Checked the event viewer for operating system and/or
Disk errors/warnings?
http://www.aspfaq.com/
(Reverse address to reply.)
"DB" <anonymous@.discussions.microsoft.com> wrote in message
news:180801c4d6fc$9cb189c0$a501280a@.phx.gbl...
> I am using SQL 2000 Dev edition. I create a DB on box
> 1. I run a simple program that loops through all records
> in a table. It works fine. (VBA Code in MS Access
> accessing the SQL table via ADO if it matters.) I then
> detach the database and copy the file, plus log file, to
> Box 2.
> I attach the database on Box 2 and run the same code to
> loop through all records in the table. It fails with an
> I/O error 998 (Invalid access to memory location)
> detected during read at offset 0x00000b8f1e0000 in
> file 'My DB File'
> It does not always stop at the same point. When I check,
> it shows EOF to be true - even though a counter shows I
> am less than 30% of the way through the file.
> Is there some form of utility to check the validity of
> the DB? I ran a ShrinkDatabase on box 1. Then copied
> the file to box 2 again. Same results.
> Known differences:
> - Hardware.
> - OS. (Can that really matter?)
> - Box1 = Win2003 Server.
> - Box2 = Win XP Pro SP1
> Both boxes are SQL 2000 Developers edition SP3.
> I'm pulling my hair out on this. Any help is greatly
> appreciated.
> Thank you.
>
sql

Database I/O error

I am using SQL 2000 Dev edition. I create a DB on box
1. I run a simple program that loops through all records
in a table. It works fine. (VBA Code in MS Access
accessing the SQL table via ADO if it matters.) I then
detach the database and copy the file, plus log file, to
Box 2.
I attach the database on Box 2 and run the same code to
loop through all records in the table. It fails with an
I/O error 998 (Invalid access to memory location)
detected during read at offset 0x00000b8f1e0000 in
file 'My DB File'
It does not always stop at the same point. When I check,
it shows EOF to be true - even though a counter shows I
am less than 30% of the way through the file.
Is there some form of utility to check the validity of
the DB? I ran a ShrinkDatabase on box 1. Then copied
the file to box 2 again. Same results.
Known differences:
- Hardware.
- OS. (Can that really matter?)
- Box1 = Win2003 Server.
- Box2 = Win XP Pro SP1
Both boxes are SQL 2000 Developers edition SP3.
I'm pulling my hair out on this. Any help is greatly
appreciated.
Thank you.Sounds like a hardware issue, I have seen similar problems just prior to a
hard disk crapping out. Have you run any disk checking utilities against
the problem machine? Checked the event viewer for operating system and/or
Disk errors/warnings?
--
http://www.aspfaq.com/
(Reverse address to reply.)
"DB" <anonymous@.discussions.microsoft.com> wrote in message
news:180801c4d6fc$9cb189c0$a501280a@.phx.gbl...
> I am using SQL 2000 Dev edition. I create a DB on box
> 1. I run a simple program that loops through all records
> in a table. It works fine. (VBA Code in MS Access
> accessing the SQL table via ADO if it matters.) I then
> detach the database and copy the file, plus log file, to
> Box 2.
> I attach the database on Box 2 and run the same code to
> loop through all records in the table. It fails with an
> I/O error 998 (Invalid access to memory location)
> detected during read at offset 0x00000b8f1e0000 in
> file 'My DB File'
> It does not always stop at the same point. When I check,
> it shows EOF to be true - even though a counter shows I
> am less than 30% of the way through the file.
> Is there some form of utility to check the validity of
> the DB? I ran a ShrinkDatabase on box 1. Then copied
> the file to box 2 again. Same results.
> Known differences:
> - Hardware.
> - OS. (Can that really matter?)
> - Box1 = Win2003 Server.
> - Box2 = Win XP Pro SP1
> Both boxes are SQL 2000 Developers edition SP3.
> I'm pulling my hair out on this. Any help is greatly
> appreciated.
> Thank you.
>

Database I/O error

I am using SQL 2000 Dev edition. I create a DB on box
1. I run a simple program that loops through all records
in a table. It works fine. (VBA Code in MS Access
accessing the SQL table via ADO if it matters.) I then
detach the database and copy the file, plus log file, to
Box 2.
I attach the database on Box 2 and run the same code to
loop through all records in the table. It fails with an
I/O error 998 (Invalid access to memory location)
detected during read at offset 0x00000b8f1e0000 in
file 'My DB File'
It does not always stop at the same point. When I check,
it shows EOF to be true - even though a counter shows I
am less than 30% of the way through the file.
Is there some form of utility to check the validity of
the DB? I ran a ShrinkDatabase on box 1. Then copied
the file to box 2 again. Same results.
Known differences:
- Hardware.
- OS. (Can that really matter?)
- Box1 = Win2003 Server.
- Box2 = Win XP Pro SP1
Both boxes are SQL 2000 Developers edition SP3.
I'm pulling my hair out on this. Any help is greatly
appreciated.
Thank you.Sounds like a hardware issue, I have seen similar problems just prior to a
hard disk crapping out. Have you run any disk checking utilities against
the problem machine? Checked the event viewer for operating system and/or
Disk errors/warnings?
http://www.aspfaq.com/
(Reverse address to reply.)
"DB" <anonymous@.discussions.microsoft.com> wrote in message
news:180801c4d6fc$9cb189c0$a501280a@.phx.gbl...
> I am using SQL 2000 Dev edition. I create a DB on box
> 1. I run a simple program that loops through all records
> in a table. It works fine. (VBA Code in MS Access
> accessing the SQL table via ADO if it matters.) I then
> detach the database and copy the file, plus log file, to
> Box 2.
> I attach the database on Box 2 and run the same code to
> loop through all records in the table. It fails with an
> I/O error 998 (Invalid access to memory location)
> detected during read at offset 0x00000b8f1e0000 in
> file 'My DB File'
> It does not always stop at the same point. When I check,
> it shows EOF to be true - even though a counter shows I
> am less than 30% of the way through the file.
> Is there some form of utility to check the validity of
> the DB? I ran a ShrinkDatabase on box 1. Then copied
> the file to box 2 again. Same results.
> Known differences:
> - Hardware.
> - OS. (Can that really matter?)
> - Box1 = Win2003 Server.
> - Box2 = Win XP Pro SP1
> Both boxes are SQL 2000 Developers edition SP3.
> I'm pulling my hair out on this. Any help is greatly
> appreciated.
> Thank you.
>

Database group

In sql server 2005 you have a group of databases called System Databases -
Is it possible to create your own database group?

Best regards,

Jakobsgaard
If you mean in the Object Explorer tree, no not in this version.|||

This seems like a tease. Is this in grouping the works?

I am coming from an Oracle perspective where the world revolves around Schemas and Tablespaces.

The Database group makes sense to me.

Thanks

Database group

In sql server 2005 you have a group of databases called System Databases -
Is it possible to create your own database group?

Best regards,

Jakobsgaard
If you mean in the Object Explorer tree, no not in this version.|||

This seems like a tease. Is this in grouping the works?

I am coming from an Oracle perspective where the world revolves around Schemas and Tablespaces.

The Database group makes sense to me.

Thanks

Database for BCM causing errors?

Hi All,

I tried to create a new project in BCM and I get an error indicating that there is already a project with that name. There is no project with that name in my list of projects! However, I think during one of the frequent installs and uninstalls before I was able to install a somewhat stable BCM, i might have created a project with that name prior to one of the many crashes (it still hangs and has to be killed in task manager periodically). I suspect I might have a rogue database that was created during one of the reinstalls which included installing and uninstalling small business accounting, which I have since also uninstalled. I have tried to use studio manager express to look at the tables in the databases, of which there are two, "mssmallbusiness" and "contctmgr 16022007" , in order to find an instance of a record with the name in question, no joy yet. Do I need the "mssmallbusiness" database to run BCM and if not can I delete it? I suspect that the mssmallbusiness database could be interfering somehow with the "contctmgr 16022007".

Since installing BCM, my outlook has slowed down considerably and hangs often on launch, I would abandon BCM, but I think it's a really cool tool and I would like to install small business accounting too! My machine is a centrino duo with 1 GB RAM and plenty HD space.

I know this message is somwhat convoluted, but if you can make sense of my issues, pls help.

Regards,

EdincoT

You should ask this in a forum that support BCM, not SQL Express. I've got no idea what is and isn't required for BCM to operate.

Mike

Database Filename error -- cannot create db From MS online tutorials

I am using VB with Visual Studio Express. I am new to these tools. I have SQL Server 2005 Express installed on my machine. I think that I have the right version. I am just using Express for taking classes and teaching myself on my machine.

When I follow the examples in the book, I keep getting this error when I go to my ASP.NET configuration and click on the security tab to add myself as a user.

"There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store.

The following message may help in diagnosing the problem:The database filename can not contain the following 3 characters: [ (open square brace), ] (close square brace) and ' (single quote) " -- end of erro msg.

I have an apostrophe in my last name. Could that be what is causing it? Is it creating a db based on my name or something? Or do I have the wrong version of SQL Server Express installed.

Thank you for any help. I appreciate it.

--Mark

Have you checked Provide of your ASP.NET configuration? Just go to Provide panel and 'Test' it. Can you see any error message?

Database error

I am using vb.net and a ms sql database. I can create datasets for every table in my database except for 1 table. Vb.net says that i have an error in my database. What can i do? is there a site that lists common database errors? Its driving me crazy, it just tells me my database has an error. It doesnt specify it. Any suggestions?

thanksTake the SQL from the connection and run it in Query Analyzer. Does it produce any errors there?|||How about showing us what the code is?

The list is long

http://support.microsoft.com/default.aspx?scid=kb;EN-US;306908|||I ran it though the query analyzer and it produced no errors. So the error must be in VB.net? All i am doing is using the data adapter wizard to create the connection and adapters. then i use the wizard to generate the dataset.
any suggestions? i have 12 other tables that work fine. but its just this one table that never works.|||I ran it though the query analyzer and it produced no errors. So the error must be in VB.net? All i am doing is using the data adapter wizard to create the connection and adapters. then i use the wizard to generate the dataset.
any suggestions? i have 12 other tables that work fine. but its just this one table that never works.

Create copy of your problem table and try to open it (removing columns by one) - I bet you'll finally find what is wrong...

Database Documentation

Please advise me of any tools that are available that allow to create a data dictionary of a SQL 2000 database into either Microsoft Word or Excel.

Bill Partridge

you can use visio i think

Database Diagrams on SQL 2000

So there is no way to create a Database diagram on a SQL 2000 database using
SQL Server management studio 2005 even though that database diagrams is not
a
new feature?
ThanksHi Lazer,
Thats right, you should use SQL Enterprise Manager to admin/create database
diagrams on SQL Server 2000.
You can use Management Studio only to create diagrams against SQL Server
2005 servers and databases.
Tony.
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials
"Lazer" <Lazer@.discussions.microsoft.com> wrote in message
news:3F59CE7A-30EE-4D63-9F75-9341AF211698@.microsoft.com...
> So there is no way to create a Database diagram on a SQL 2000 database
> using
> SQL Server management studio 2005 even though that database diagrams is
> not a
> new feature?
> Thanks

Database Diagrams in SQL server 2005

Hello, i'm new to this forum but I need help with SQL Server 2005. I know on 2003 you can do database diagrams to create table diagrams to show the relationships. But for 2005 it won't allow me to do database diagrams. When I click on my database in Object or Solution explorer, I right click on database diagrams and it doesn't give me the option to do a database diagram. It just gives me a help option ("Working with SQL server 2000 diagrams"). I don't why it gives this option, because I'm using the 2005 version. Does anyone know how to elect to do database diagrams in SQL Server 2005? I would appreciate the help.

Not quite sure what problem you're running into...

Are you using SQL Server Management Studio or Visual Studio? You should be using SQL Server Management Studio.

What version of the SSMS are you using? Go to the Help -> About menu. Then look for these: 9.0.1399, 9.0.2047, Express, Developer.

You should be able to right click on the Database Diagrams node and choose "New Database Diagram"

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

|||

Management Studio can't create or open diagrams on SQL Server 2000 servers. Are you connected to a SQL Server 2000 server, or a SQL Server 2005 server?

Thanks,
Steve

|||Thanks Steve, I'm connecting to SQL Server 2000 server, I wasn't aware you couldn't create diagrams if connected to that server. That answers my question, thanks.

Database Diagrams from SQL Server

In your experiences, what is the best way to create Database Diagrams?
SQL Server Enterprise Manager Diagrams or Visio?
In SQL Server Enterprise Manager, when I create a "Diagram" and then try to
"Autosize Selected Tables" it leaves a lot of white space at the top which
results in the Table printing over one page. Is there any way to control
this? Does that have something to do with my printer set-up? Even if I
click and drag the table to the top of the page, it automatically slides it
down again creating that white space.
If I Reverse Engineer the Table into Visio, the column attributes are not
showing up.
I welcome your opinions and your help is GREATLY appreciated.
Thanks!
wnfisba
My best way to do this is to use Visio Enterprise Edition (with
reeingineering tool). YOu have a good chance to do your modifications
in here and deploy them right away in the server. Another tool which is
often mentioned is Erwin - a database modelling solution.
HTH, Jens Suessmeyer.
|||When attempting to Reverse Engineer into Visio, I am not seeing the column
attributes. The column names are coming
over, but not their attributes. Can I change that?
Please let me know.
Thanks!
"Jens" wrote:

> My best way to do this is to use Visio Enterprise Edition (with
> reeingineering tool). YOu have a good chance to do your modifications
> in here and deploy them right away in the server. Another tool which is
> often mentioned is Erwin - a database modelling solution.
> HTH, Jens Suessmeyer.
>
|||I also prefer Visio (or Erwin or ERstudio or pretty much
anything) over the Diagram tool in Enterprise Manager.
In terms of the columns in Visio, that's just a setting you
can change. In Visio, open the diagram, go to the menu and
select Database, then Options, then Document. A database
document window pops up. On the tables tab, you can select
what is displayed for the tables in the diagram (which types
of columns, if you want to display data types, etc.).
-Sue
On Thu, 19 Jan 2006 11:50:02 -0800, "wnfisba"
<wnfisba@.discussions.microsoft.com> wrote:

>In your experiences, what is the best way to create Database Diagrams?
>SQL Server Enterprise Manager Diagrams or Visio?
>In SQL Server Enterprise Manager, when I create a "Diagram" and then try to
>"Autosize Selected Tables" it leaves a lot of white space at the top which
>results in the Table printing over one page. Is there any way to control
>this? Does that have something to do with my printer set-up? Even if I
>click and drag the table to the top of the page, it automatically slides it
>down again creating that white space.
>If I Reverse Engineer the Table into Visio, the column attributes are not
>showing up.
>I welcome your opinions and your help is GREATLY appreciated.
>Thanks!
>wnfisba

Database Diagrams export

Hi, Can someone help me?
I need to create a tree structured diagram of our Server databases. I know how to create diagrams via the Enterprise manager, but I don't know how I can export them into some format, that I can further work with (doc., txt.,etc.). Is there some other tool, then the one in enterprise manager?
Thanks in advance.
Magdalena.That may be helpful:

Script SQL Server 2005 diagrams to a file

Database diagrams

I have just installed SQL server Express and am trying to create a database diagram. When I right click on database diagram, I just get the options to use help or to refresh. There is no option to create a new diagram,

Thanks,

Sarah

Express doesn't contain that option. You might try some of the freeware offerings to create database diagrams, or you can use Microsoft's Visio for Enterprise Architects.

Buck Woody

|||Can they not be created in the management studio?|||

Yes, but not against SQL Server Express.

Buck Woody

|||

I have now installed SQL server 2005 and need to be able to produce ERD's. Through the management studio, I do not ge the option to create new diagrams, I only get refresh or help. Should I be creating the some other way?

Thanks.

|||

No, you're in the right place. If you have installed a Standard Edition of SQL Server 2005 or higher, you will be able to create diagrams, but not against an Express database. Express databases don't have the ability to create the objects required for a database diagram. If you're using the 2005 tools to hit a 2000 database, you'll run into the same issue. You need to create 2000 diagrams in 2000.

|||i currently have the managemet studio express on my machine and there is support for creating database diagrams. if your are connecting to a remote server through the management studio it could be because of the security settings server side that will disallow the option. if you set up a local server it will give you the option

Database Diagrams

Do you need to be a member of the dbo role or an sa on a particular sql server to create a database diagram? I just want to confirm this is the case.
Any assistance will be helpful.
MariaYou have to logged as dbo or system administrator (sa or member of server group system administrators).|||Great, that's what I thought.

Thanks,

Maria|||Even if you are not a dbo or sysadmin, you can still create the diagrams and save them. But you will not be able to make changes to the tables as you don't have DML permissions.|||Okay, that is the problem. My developers can't seem to create a database diagram because the message is that they don't have sufficient permissions. Is there a particular role that they should be assigned to in order to do this? Or a level of permissions that is associated?

Maria|||Make sure the following stored procedures exist in the database:

dbo.dt_getobjwithprop_u
dbo.dt_adduserobject
dbo.dt_setpropertybyid_u
dbo.dt_getpropertiesbyid_u|||Great, I'll try that tomorrow and let you know.

Maria|||Hi,

The procs exist in the database. The problem is that my users are still unable to create the diagrams on the db. It claims they don't have enough permissions.

That's where the initial inquiry came into play. If this is wrong and they should be able to create a diagram regardless of the role they are grouped into on the db, then does anyone know what the problem is?

Maria

Database diagrams

I have just installed SQL server Express and am trying to create a database diagram. When I right click on database diagram, I just get the options to use help or to refresh. There is no option to create a new diagram,

Thanks,

Sarah

Express doesn't contain that option. You might try some of the freeware offerings to create database diagrams, or you can use Microsoft's Visio for Enterprise Architects.

Buck Woody

|||Can they not be created in the management studio?|||

Yes, but not against SQL Server Express.

Buck Woody

|||

I have now installed SQL server 2005 and need to be able to produce ERD's. Through the management studio, I do not ge the option to create new diagrams, I only get refresh or help. Should I be creating the some other way?

Thanks.

|||

No, you're in the right place. If you have installed a Standard Edition of SQL Server 2005 or higher, you will be able to create diagrams, but not against an Express database. Express databases don't have the ability to create the objects required for a database diagram. If you're using the 2005 tools to hit a 2000 database, you'll run into the same issue. You need to create 2000 diagrams in 2000.

|||i currently have the managemet studio express on my machine and there is support for creating database diagrams. if your are connecting to a remote server through the management studio it could be because of the security settings server side that will disallow the option. if you set up a local server it will give you the option

Database diagrams

I have just installed SQL server Express and am trying to create a database diagram. When I right click on database diagram, I just get the options to use help or to refresh. There is no option to create a new diagram,

Thanks,

Sarah

Express doesn't contain that option. You might try some of the freeware offerings to create database diagrams, or you can use Microsoft's Visio for Enterprise Architects.

Buck Woody

|||Can they not be created in the management studio?|||

Yes, but not against SQL Server Express.

Buck Woody

|||

I have now installed SQL server 2005 and need to be able to produce ERD's. Through the management studio, I do not ge the option to create new diagrams, I only get refresh or help. Should I be creating the some other way?

Thanks.

|||

No, you're in the right place. If you have installed a Standard Edition of SQL Server 2005 or higher, you will be able to create diagrams, but not against an Express database. Express databases don't have the ability to create the objects required for a database diagram. If you're using the 2005 tools to hit a 2000 database, you'll run into the same issue. You need to create 2000 diagrams in 2000.

|||i currently have the managemet studio express on my machine and there is support for creating database diagrams. if your are connecting to a remote server through the management studio it could be because of the security settings server side that will disallow the option. if you set up a local server it will give you the option

Database diagram support objects cannot be installed...

I can't make a diagram on our server(Win2003 x64,SQL 2005 Enterprise x64 sp2 3054).

I have tried to login as an admin and create a new db, but get the same message -

'Database diagram support objects cannot be installed because this database does not have a valid owner. To..'

Also tried to make a diagram from the ReportServer db.

Any suggestions?

Two things to check.

1. please make sure that db has a owner (as the error suggests).

2. please check your compatibility level.

|||

Thanks Meher for your reply.

1. Both of the databases I tried has a owner.

2. I'm pretty sure the compatibility level is 90 (SQL 2005) since one is created during installation(ReportServer) and the other is created as a new db in SQL Management Studio. (To be sure I will check next week)

Any other suggestions?

|||

Are you still getting the error message?. As you have mentioned check the compatibility level once again and if you are still getting the message we can look a bit further.

|||

The compatibility level is 90(SQL Server 2005).

|||

what role do you belong to?. pls check

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/uirfsql9/html/6fdecefb-7bd3-4203-a58c-36d46ee628bf.htm

|||db_owner |||

Hi olof,

can you please go through the steps outlined in section 4.8.1 in http://support.microsoft.com/?id=910228

As per the section in the article, looks like you might have to install the diagram support.

To create database diagrams, change the database compatibility level to 2005, install database diagram support, and then return the database to the desired database compatibility level.

MVPs, please correct me if I am missing something.

Thanks

Meher

|||

one other thing I forgot to mention is that the installation of support objects can fail if the database

has been attached or restored from another instance of SQL Server. In such a case there is a

possibility that the database owner name stored in the database may not be a valid logon for the

instance of the SQL Server on to which the database is restored to (or attached to).

I would suggest if thats the case then you can use the Alter statement to change the owner to a valid logon.

ALTER AUTHORIZATION ON DATABASE::your dbname TO yourdesiredlogin

(please see BOL for more details on ALTER AUTHORIZATION).

I would suggest doing through T-SQL than UI and see if it solves your issue.

Thanks

Meher

Database Diagram in SQL Server 6.5

Hi,
I am new to SQL SERVER. I have got recently trained in SQL SERVER 2000. In S
QL SERVER 2000, I know how to create a database diagram using Enterprise Man
ager.
We have got another system which is based on SQL SERVER 6.5. I want get a da
tabase diagram of this database. Can you please suggest how to get the Datab
ase Diagram in SQL SERVER 6.5.
Thanks,
ShailajaI think that this may be useful:
http://www.microsoft.com/technet/tr...ate/sqlugrd.asp|||It's been a while since I worked with SQL Server 6.5, but I don't think the
diagramming feature is available in SQL Server 6.5
You could generate a script for all the 6.5 tables, including the
relationships. Then create a database in SQL Server 2000, and run those
scripts to recreate the tables. Once the tables are created, you could use
SQL Server 2000 Enterprise Manager to generate disgram from this database.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Shailaja Somisetty" <shailaja_somisetty@.yahoo.com> wrote in message
news:55F7DC49-53DA-4763-90EB-117FA4B41871@.microsoft.com...
Hi,
I am new to SQL SERVER. I have got recently trained in SQL SERVER 2000. In
SQL SERVER 2000, I know how to create a database diagram using Enterprise
Manager.
We have got another system which is based on SQL SERVER 6.5. I want get a
database diagram of this database. Can you please suggest how to get the
Database Diagram in SQL SERVER 6.5.
Thanks,
Shailaja|||Hi,
In SQL 6.5 you can not create diagrams. infact there was no options for
diagrams.
To add on Vyas post,
1. Generate the table creation script and save the file as table.sql
2. If you have ERwin or any other database modeling tool, you can reverse
engineer the table.sql to get a ER diagram.
Which is identical to SQL server diagrams
Thanks
Hari
MCDBA
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:eDBXdHY6DHA.2540@.TK2MSFTNGP11.phx.gbl...

quote:

---

> It's been a while since I worked with SQL Server 6.5, but I don't think

---

the

quote:

---

> diagramming feature is available in SQL Server 6.5
> You could generate a script for all the 6.5 tables, including the
> relationships. Then create a database in SQL Server 2000, and run those
> scripts to recreate the tables. Once the tables are created, you could use
> SQL Server 2000 Enterprise Manager to generate disgram from this database.
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> Is .NET important for a database professional?
> http://vyaskn.tripod.com/poll.htm
>
> "Shailaja Somisetty" <shailaja_somisetty@.yahoo.com> wrote in message
> news:55F7DC49-53DA-4763-90EB-117FA4B41871@.microsoft.com...
> Hi,
> I am new to SQL SERVER. I have got recently trained in SQL SERVER 2000. In
> SQL SERVER 2000, I know how to create a database diagram using Enterprise
> Manager.
> We have got another system which is based on SQL SERVER 6.5. I want get a
> database diagram of this database. Can you please suggest how to get the
> Database Diagram in SQL SERVER 6.5.
> Thanks,
> Shailaja
>

---

|||On Mon, 2 Feb 2004 03:31:06 -0800, Shailaja Somisetty wrote:

quote:

---

>I am new to SQL SERVER. I have got recently trained in SQL SERVER 2000. In
SQL SERVER 2000, I know how to create a database diagram using Enterprise Ma
nager.
>We have got another system which is based on SQL SERVER 6.5. I want get a database diagram
of this database. Can you please suggest how to get the Database Diagram in SQL SERVER 6.5.[
/color]

---

Take a look at Visio. Several versions will allow you to reverse
engineer a diagram from SQL Server 6.5, and the Enterprise versions of
Visio 2000 and 2002 also allow you to generate SQL DDL script from the
diagrams.
If all you want is to diagram and document an existing database (i.e.
you never want to generate scripts from your diagram / design), then you
don't need to spend the extra bucks on visio Enterprise - just get Visio
Professional.
NB: visio Standard doesn't do database diagrams!
http://www.microsoft.com/office/vis...fo/default.mspx
Also, I think that visio Enterprise is now part of VS.Net Enterprise -
can't remember, but you can check that out on the website.
cheers,
Ross.
--
Ross McKay, WebAware Pty Ltd
"Words can only hurt if you try to read them. Don't play their game" - Zoola
nder|||FWIW, as far as I remember, Visual Studio has diagram feature that work agai
nst 6.5.
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ls
erver
"Shailaja Somisetty" <shailaja_somisetty@.yahoo.com> wrote in message
news:55F7DC49-53DA-4763-90EB-117FA4B41871@.microsoft.com...

quote:

---

> Hi,
> I am new to SQL SERVER. I have got recently trained in SQL SERVER 2000. In SQL SERVER 2000
, I know

---

how to create a database diagram using Enterprise Manager.

quote:

---

> We have got another system which is based on SQL SERVER 6.5. I want get a database diagram
of this

---

database. Can you please suggest how to get the Database Diagram in SQL SERVER 6.5.

quote:

---

arkred">
> Thanks,
> Shailaja

---

|||Thanks for your valuable inputs.
Shailaja

Database Diagram in SQL Server 6.5

Hi
I am new to SQL SERVER. I have got recently trained in SQL SERVER 2000. In SQL SERVER 2000, I know how to create a database diagram using Enterprise Manager.
We have got another system which is based on SQL SERVER 6.5. I want get a database diagram of this database. Can you please suggest how to get the Database Diagram in SQL SERVER 6.5
Thanks
ShailajaI think that this may be useful:
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/deploy/upgrdmigrate/sqlugrd.asp|||It's been a while since I worked with SQL Server 6.5, but I don't think the
diagramming feature is available in SQL Server 6.5
You could generate a script for all the 6.5 tables, including the
relationships. Then create a database in SQL Server 2000, and run those
scripts to recreate the tables. Once the tables are created, you could use
SQL Server 2000 Enterprise Manager to generate disgram from this database.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Shailaja Somisetty" <shailaja_somisetty@.yahoo.com> wrote in message
news:55F7DC49-53DA-4763-90EB-117FA4B41871@.microsoft.com...
Hi,
I am new to SQL SERVER. I have got recently trained in SQL SERVER 2000. In
SQL SERVER 2000, I know how to create a database diagram using Enterprise
Manager.
We have got another system which is based on SQL SERVER 6.5. I want get a
database diagram of this database. Can you please suggest how to get the
Database Diagram in SQL SERVER 6.5.
Thanks,
Shailaja|||Hi,
In SQL 6.5 you can not create diagrams. infact there was no options for
diagrams.
To add on Vyas post,
1. Generate the table creation script and save the file as table.sql
2. If you have ERwin or any other database modeling tool, you can reverse
engineer the table.sql to get a ER diagram.
Which is identical to SQL server diagrams
Thanks
Hari
MCDBA
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:eDBXdHY6DHA.2540@.TK2MSFTNGP11.phx.gbl...
> It's been a while since I worked with SQL Server 6.5, but I don't think
the
> diagramming feature is available in SQL Server 6.5
> You could generate a script for all the 6.5 tables, including the
> relationships. Then create a database in SQL Server 2000, and run those
> scripts to recreate the tables. Once the tables are created, you could use
> SQL Server 2000 Enterprise Manager to generate disgram from this database.
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> Is .NET important for a database professional?
> http://vyaskn.tripod.com/poll.htm
>
> "Shailaja Somisetty" <shailaja_somisetty@.yahoo.com> wrote in message
> news:55F7DC49-53DA-4763-90EB-117FA4B41871@.microsoft.com...
> Hi,
> I am new to SQL SERVER. I have got recently trained in SQL SERVER 2000. In
> SQL SERVER 2000, I know how to create a database diagram using Enterprise
> Manager.
> We have got another system which is based on SQL SERVER 6.5. I want get a
> database diagram of this database. Can you please suggest how to get the
> Database Diagram in SQL SERVER 6.5.
> Thanks,
> Shailaja
>|||On Mon, 2 Feb 2004 03:31:06 -0800, Shailaja Somisetty wrote:
>I am new to SQL SERVER. I have got recently trained in SQL SERVER 2000. In SQL SERVER 2000, I know how to create a database diagram using Enterprise Manager.
>We have got another system which is based on SQL SERVER 6.5. I want get a database diagram of this database. Can you please suggest how to get the Database Diagram in SQL SERVER 6.5.
Take a look at Visio. Several versions will allow you to reverse
engineer a diagram from SQL Server 6.5, and the Enterprise versions of
Visio 2000 and 2002 also allow you to generate SQL DDL script from the
diagrams.
If all you want is to diagram and document an existing database (i.e.
you never want to generate scripts from your diagram / design), then you
don't need to spend the extra bucks on Visio Enterprise - just get Visio
Professional.
NB: Visio Standard doesn't do database diagrams!
http://www.microsoft.com/office/visio/prodinfo/default.mspx
Also, I think that Visio Enterprise is now part of VS.Net Enterprise -
can't remember, but you can check that out on the website.
cheers,
Ross.
--
Ross McKay, WebAware Pty Ltd
"Words can only hurt if you try to read them. Don't play their game" - Zoolander|||FWIW, as far as I remember, Visual Studio has diagram feature that work against 6.5.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Shailaja Somisetty" <shailaja_somisetty@.yahoo.com> wrote in message
news:55F7DC49-53DA-4763-90EB-117FA4B41871@.microsoft.com...
> Hi,
> I am new to SQL SERVER. I have got recently trained in SQL SERVER 2000. In SQL SERVER 2000, I know
how to create a database diagram using Enterprise Manager.
> We have got another system which is based on SQL SERVER 6.5. I want get a database diagram of this
database. Can you please suggest how to get the Database Diagram in SQL SERVER 6.5.
> Thanks,
> Shailaja|||Thanks for your valuable inputs
Shailaja